Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why is my SYSTEM tablespace not freeing space?

sape007May 24 2004 — edited May 25 2004

Oracle 9.2.0.4.0 (64 bit) on Solaris 9

I have around 50 (similar) schemas on my database (each schema has 15 stored proc packages). This morning I saw the SYSTEM tablespace has only 1.5MB free (normally it has 10MB free).

Since I am running very low on physical OS disk, I decided to drop 5 unwanted schemas.

I was hoping that it will free 3 5 MB of SYSTEM space, since procedures, functions, packages, and triggers resides in the SYSTEM tablespace.

But this did not happen after dropping 5 schema I still have 1.5MB free, I did not even get a meg. Why is that, am I missing someting?

I will solve my disk problem some other way, but[b] I am now very interested in finding out why I did not get more free space from Oracle after dropping schemas that had many packages.

Thanks in advance if you have some info for me.
Regards, Nazrul Islam

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2004

Added on May 24 2004

#general-database-discussions

8 comments

520 views