which SCHEMAS are actually needed?

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

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

THANKS!

[Mikito Harakiri]

"Hari Om" <hari_om@hotmail.com> wrote in message
news:d1d5ebe4.0309051358.6755aeb4@posting.google.com... 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.