Re: which SCHEMAS are actually needed?

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Fri, 5 Sep 2003 15:01:48 -0700
Message-ID: <DR76b.29$pP2.167@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;
@?/rdbms/admin/catalog
@?/rdbms/admin/catproc

Everything that doen't fit into this database is optional. Received on Fri Sep 05 2003 - 17:01:48 CDT