-
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?
Thank you all.
-
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
I'm stmontgo and I approve of this message
-
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.
-- Dilip
-
Thanks friends....
Where can i find docs about the other schemas being created and their functionalities? (like outln, etc)
-
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
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|