-
Removing default schemas
I am about to tune a small db which is having 100 tables. The db was created with OEM by mycollegues. While I check that schema I have found the following schema
-QS, QS_ADM, QS_CBABM, QS_CS, QS_ES, QS_OS, QS_WS.
My project has only one schema. It is having java scripts too.
So in this case may I remove those schemas. Will it affect any of the
other services?
-
These are the Oracle supplied sample schemas, you can remove those if you don't want. If you need more information on these schemas then refer to http://download-west.oracle.com/docs...talla.htm#4216
-
Those are the Queued Shipping demo schemas. They are used if you want to run the demo scripts in the $ORACLE_HOME/demo directories.
To remove these schemas safely, run the qs_drop.sql in the $ORACLE_HOME/demo/schema/shipping directory. It will remove the QS objects and the schema by itself.
Hope that helps,
clio_usa
OCP 8/8i/9i DBA
Visit our Web Site