How to reduce the size of SYSTEM tablespace?
sape007Aug 3 2004 — edited Aug 4 2004* Solaris
* Oracle 9.2.0.4.0
* Locally managed database (since SYSTEM is locally managed TS)
I have a Oracle 9i database with is around 7 months old. Over the 7 months it had around 400 schemas at most and SYSTEM tablespace was increased to 850MB. Now it only has around 120 schemas and size of the SYSTEM tablespace still 850MB and its 99% used.
How can I get more free space on system tablespace?
* I have made sure that non-sys(tem) user dont have objects on SYSTEM tablespace.
* I understand that dropping schema does not give you all the space back, since objects are store as row in System tables etc.
Increasing disk is not an option for me. Any tips to free space on system welcome.
Thanks,
Nazrul Islam