Removing Oracle schemas...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Removing Oracle schemas...

  1. #1
    Join Date
    Jul 2003
    Location
    Sacto
    Posts
    5

    Question Removing Oracle schemas...

    Hello fellow DBAers,

    What Oracle schemas can I remove from my Oracle 9iR2 database without causing problems...eg, CTXSYS, MDSYS, ORDSYS, ORDPLUGIN, WKSYS, WMSYS, ODM.

    One time I ran accross documentation showing what could be removed and what had to stay, but I cannot locate it again.

    Thanks to all who respond to my question...


    Thankyou,

    qatester

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Everyone but sys and system, assuming you are not using any features that are associated with the other users.

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Metalink says: These are the oracle created schemas used by various features you can drop them if you are not using those features..
    Code:
    DBSNMP if Enterprise Manager Intelligent Agent is installed 
    TRACESVR if Enterprise Manager is installed 
    AURORA$ORB$UNAUTHENTICATED \ 
    AURORA$JIS$UTILITY$ -- if Oracle Servlet Engine (OSE) is installed 
    OSE$HTTP$ADMIN / 
    MDSYS if Oracle Spatial option is installed 
    ORDSYS if interMedia Audio option is installed 
    ORDPLUGINS if interMedia Audio option is installed 
    CTXSYS if Oracle Text option is installed 
    REPADMIN if Replication Option is installed 
    LBACSYS if Oracle Label Security option is installed 
    ODM if Oracle Data Mining option is installed 
    ODM_MTR idem 
    OLAPSYS if OLAP option is installed 
    WMSYS if Oracle Workspace Manager script owmctab.plb is 
    executed. 
    ANONYMOUS if catqm.sql catalog script for SQL XML management 
    XDB is executed
    Also these sample schemas can be dropped safely..
    Code:
    HR (Human Resources) 
    OE (Order Entry) 
    PM (Product Media) 
    SH (Sales History) 
    QS (Queued Shipping) 
    QS_ADM (Administration) 
    QS_WS (Western Shipping) 
    QS_ES (Eastern Shipping) 
    QS_OS (Overseas Shipping) 
    QS_CBADM (Customer Billing Administration) 
    QS_CB (Customer Billing) 
    QS_CS (Customer Service)
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Why do you want to remove them, they do not take up a lot of space.

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Jul 2003
    Location
    Sacto
    Posts
    5
    MH,

    I know that they don't use to much space in the database, but I'm attempting to pull what I'm not using out to keep it clean and uncluttered. Plus, if I need something couldn't I just re-install...


    Regards,

    qatester

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by qatester
    MH,

    I know that they don't use to much space in the database, but I'm attempting to pull what I'm not using out to keep it clean and uncluttered. Plus, if I need something couldn't I just re-install...


    Regards,

    qatester
    Don't delete if you are not 100% sure you may delete!
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    A clear example of never having had command line or scripting skills/knowledge = Don't know what to do if the GUI tool won't do it for you.

  8. #8
    Join Date
    Apr 2014
    Posts
    1

    Some good links

    http://www.adp-gmbh.ch/ora/misc/known_schemas.html
    http://www.orafaq.com/wiki/List_of_d...database_users
    http://www.oracle-wiki.net/startdocsdefaultschemas

    Nearly all schemas except for SYS, SYSTEM, and OUTLN, can be removed. DO NOT REMOVE OUTLN...!!! When you restart Oracle, it will NOT come back up...

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