-
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