How to clean up space in system tablespace
683964Jun 29 2009 — edited Jun 29 2009Hi,
I am working as an Oracle etl developer. I have limited knowledge of database activities.
I am trying to free some space from my SYSTEM tablespace. When I try to query to identify how much space is availabe in system tablespace, it shows that it is 99.4% used. The total size is 2140 MB. Then I added a new data file to the tablespace of the same size. Now, it shows that it is 49.6% used.
My question here is that, when I checked the size of the disk where the database is installed in windows, prior to increase its size it shows that 1 GB of space is occupied out of 2.1 GB, but the tablespace query shows me that it is fully occupied. So, is it like the datafile keeps on increasing its size even if most of the blocks are empty. And, secondly how can I clean up the space from the system Tablespace.
Thanks!!!!!!