oci-oracle-xe
oci-oracle-xe copied to clipboard
[QUESTION] Any way to not include the initial database?
I just ran the latest slim version and looking at the database I see a large number of empty tables (e.g. LOGMNR_, MVIEW$_) and schemas - what is the purpose of those? Is there an easy way to run the image with a blank db?
Hi @aleybovich,
These are all part of the Oracle Database data dictionary. The first is for a feature called LogMiner, the second is the dictionary table containing information about materialized views.
Likewise, the schemas are for various different features or administrative purposes, see, for example, here.
In essence, a DB with all these schemas and tables is a blank DB. If you were to delete some of those, some functionality will ultimately not work anymore.
Hope this helps!