deleting schema's??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: deleting schema's??

  1. #1
    Join Date
    Nov 2000
    Posts
    198
    Hi,
    I am trying to clean up my database. I would like to remove
    all unnecessary schema's from (none)system tablespaces.

    I found these schema's in (none)system tablespaces(CTXSYS,MDSYS,ORDSYS,OUTLN), and I was wondering what r they and if I can delete them. Also why SYSTEM is using
    system and tools tablespaces.

    schema------table_name-------tablespace
    ---------------------------------------------
    CTXSYS ---> DR$----------------DRSYS
    MDSYS----->MD$,CS_SRS------SYSTEM
    ORDSYS--->ORD_---------------SYSTEM
    OUTLN----->OL$,OL$HINTS-----SYSTEM
    SYSTEM---->!!!!!-----------------SYSTEM,TOOLS
    SYS-------->!!!!!------------------SYSTEM

    THANKS,


  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I suggest you leave these schemas just the way they are.

  3. #3
    Join Date
    Aug 2000
    Posts
    132
    I believe the only schema you want in the SYSTEM tablespace is SYS (you should check your users temporary tablespaces as well - they should all be in TEMP). We have our System in TOOLS. I believe OUTLN, DBSNMP are part of interMedia and should go in DRSYS. Check out note: 1015980.102 which explains why DR$ indexes show up in SYSTEM tablespace - the index in SYSTEM tablespace takes no storage.

  4. #4
    Join Date
    Aug 2000
    Posts
    132
    Since I'm relatively new to Oracle I'll definitely defer to Halo. Curious though, our Oracle consultant advised us to keep all schemas but SYS out of the SYSTEM tablespace - overkill?

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    It depends on whats options you want to use. I had a tar on the same(not exactly same issue, but implications of changing default users pwds as a part of hack proofing our databases) with oracle. They were not sure, Finally they said to save the default pwds and change 'em. In case you want to use that option in future, it may not work though you reset the pwd using 'alter user' syntax. You have to run the saved passwords script to put 'em back. Thats what metalink says. Follow this interesting link for further information.

    [url]http://www.orafaq.org/faqdbase.htm#DEFUSERS[/url]

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