Re: which SCHEMAS are actually needed?

hari_om_at_hotmail.com (Hari Om) writes:

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

HR,OE,PM,QS% and SH are created by @?/demo/schema/mksample. The other schemas are created by additional options such as Oracle*Text, OLAP and so on.

The necessary schemas are SYS,SYSTEM,OUTLN,DBSNMP. They are created by the following catalogs:

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catexp.sql

Harald Received on Sat Sep 06 2003 - 02:10:01 CDT