Db Clean-up
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Db Clean-up

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    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

  3. #3
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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

  4. #4
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Thanks friends....

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

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
  •  


Click Here to Expand Forum to Full Width