-
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
-
Everyone but sys and system, assuming you are not using any features that are associated with the other users.
-
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"
-
Why do you want to remove them, they do not take up a lot of space.
MH
I remember when this place was cool.
-
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
-
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
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|