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 !