Removing default schemas
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Removing default schemas

  1. #1
    Join Date
    Nov 2002
    Location
    India
    Posts
    22

    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?

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Thumbs up

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width