-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|