Removing default schemas

[sgnerd]

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?

[Sameer]

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

[clio_usa]

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