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
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,
OCP 8/8i/9i DBA
Visit our Web Site
Click Here to Expand Forum to Full Width