Db Clean-up

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

[stmontgo]

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

[patel_dil]

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.

[kris123]

Thanks friends....

Where can i find docs about the other schemas being created and their functionalities? (like outln, etc)

[stmontgo]

Originally posted by kris123
Thanks friends....

Where can i find docs about the other schemas being created and their functionalities? (like outln, etc)

http://download-west.oracle.com/docs...db.htm#1006823