471,049 Members | 1,407 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

which SCHEMAS are actually needed?

I am using Oracle 9.2.0.1 on IBM AIX 5.1 box.
It seems that when I install ORACLE, it gets FULLY LOADED with all the
SCHEMA's - wonder why. Following SCHEMAS are availavle when I checke
din OEM - but which of these are "actually" needed and which are not
needed and can be deleted safely without affecting normal DB
functions.

Here is a LOADED list:
CTXSYS, HR, MDSYS, ODM,ODM_MTR,OE,OLAPSYS,ORDPLUGINS,ORDSYS,OUTLN,PM, PUBLIC,QS,QS_ADM,QS_CBADM,QS_CS,QS_ES,QS_OS,SCOTT, SH,SYS,SYSTEM,WKSYS,XDB

Ofcourse I know we need SYS,SYSTEM and SCOTT...

Any related informatino on this is appreciated.....

THANKS!
Jul 19 '05 #1
2 2621
"Hari Om" <ha*****@hotmail.com> wrote in message
news:d1**************************@posting.google.c om...
I am using Oracle 9.2.0.1 on IBM AIX 5.1 box.
It seems that when I install ORACLE, it gets FULLY LOADED with all the
SCHEMA's - wonder why. Following SCHEMAS are availavle when I checke
din OEM - but which of these are "actually" needed and which are not
needed and can be deleted safely without affecting normal DB
functions.

Here is a LOADED list:
CTXSYS, HR, MDSYS, ODM,ODM_MTR,OE,OLAPSYS,ORDPLUGINS,ORDSYS,OUTLN,PM, PUBLIC,QS,QS_ADM,QS_CBADM,
QS_CS,QS_ES,QS_OS,SCOTT,SH,SYS,SYSTEM,WKSYS,XDB
Ofcourse I know we need SYS,SYSTEM and SCOTT...


It is easy to make an experiment.

create db test;
@?/rdbms/admin/catalog
@?/rdbms/admin/catproc

Everything that doen't fit into this database is optional.
Jul 19 '05 #2
Hari Om wrote:
I am using Oracle 9.2.0.1 on IBM AIX 5.1 box.
It seems that when I install ORACLE, it gets FULLY LOADED with all the
SCHEMA's - wonder why. Following SCHEMAS are availavle when I checke
din OEM - but which of these are "actually" needed and which are not
needed and can be deleted safely without affecting normal DB
functions.


What are (define) "normal DB functions"?

P.S.
Plz cease cross-posting.

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Hari Om | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.