DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001


    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
    Saskatoon, SK, Canada
    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.


    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.