home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 330 of 2,288   
   Mikito Harakiri to Hari Om   
   Re: which SCHEMAS are actually needed?   
   05 Sep 03 15:01:48   
   
   XPost: comp.databases.oracle.tools, comp.databases.oracle.misc   
   From: mikharakiri@ywho.com   
      
   "Hari Om"  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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca