Re: which SCHEMAS are actually needed?
Date: Fri, 5 Sep 2003 15:01:48 -0700
Message-ID: <DR76b.29$pP2.167_at_news.oracle.com>
"Hari Om" <hari_om_at_hotmail.com> wrote in message
news:d1d5ebe4.0309051358.6755aeb4_at_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;
_at_?/rdbms/admin/catalog
_at_?/rdbms/admin/catproc
Everything that doen't fit into this database is optional. Received on Sat Sep 06 2003 - 00:01:48 CEST