Removing Oracle schemas...

[qatester]

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

[stecal]

Everyone but sys and system, assuming you are not using any features that are associated with the other users.

[SANJAY_G]

Metalink says: These are the oracle created schemas used by various features you can drop them if you are not using those features..

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..

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)

[Mr.Hanky]

Why do you want to remove them, they do not take up a lot of space.

MH

[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

[julian]

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!

[stecal]

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.