If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Db Clean-up

Hi Friends,

DB = Oracle 9i
OS = Win2000

I noticed that there are lots of schemas created when i installed
Oracle9i. I know some of these are for demo applications which we
normally do not use. Can i drop all these schemas without corrupting
my database? I dont know which of these are needed by other tools in maintaining the database. Can I onty retain SYS,SYSTEM, and our
"to be" created application schemas?

Re: Db Clean-up

Originally posted by kris123 Hi Friends,

DB = Oracle 9i
OS = Win2000

I noticed that there are lots of schemas created when i installed
Oracle9i. I know some of these are for demo applications which we
normally do not use. Can i drop all these schemas without corrupting
my database? I dont know which of these are needed by other tools in maintaining the database. Can I onty retain SYS,SYSTEM, and our
"to be" created application schemas?

Thank you all.

you can drop most of them and you'll get left with lots of invalid objects, an argurment not to use the dbca to create databses.

When we create databases manually we are left with sys, system, dbmsnp and outln fyi

At the minimum, keep sys, system and outln user. Rest of schemas you can drop if your not using thier corresponding functionality. Like schema DBSNMP can be dropped if your not using Intelligent Agents.