HELP How to delete SYSTEM's objects or SYSTEM schema?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: HELP How to delete SYSTEM's objects or SYSTEM schema?

  1. #1
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    93

    Exclamation

    Hi friends, I have a problem. I created a database in oracle 8.0.6 on HP-UX server. When I finished I runned some scripts (catalogs.sql, catproc.sql, caths.sql). But ungratefuly my SYSTEM tablespace (the file system01.dbf) have growned so much (like 400 Mb !!). I would like to know how to solve this problem, because we don't have enought space for our information.

    I think one solution, probably is to delete the tablespace SYSTEM, and after create it again, and run only one or two scripts. I'm not sure if it is a good idea or how to solve this problem. By other hand, I have thinked to drop all objects in this tablespace, but I don't know if this is possible. After i could run these scripts.

    Please help me! Any ideas would be appreciated a lot !

    Thanks in advance.


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You cannot delete the system tablespace. If you try oracle will not allow you.

    Secondly you would require all the objects that are generated through catlog and catproc scripts for the database to function.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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