I queried the Oracle 8i (8.1.6) database and found out that we've used 90% of the space available. The CEO believes that the space was claimed because of the allocated space during creation but the database does not contain enough data to fill up this space.
Can anyone out there throw more light on this in case there is a way to distinguish the weed from the corn.
Thanks! It works. I queried one of the tables and got 4 blocks. The block size is 8192.
Does this mean that there are 4 x 8192 bytes and if so what's taking up the rest of the space and how do Isafely reclaim the space.
At the moment the above-mentioned table is taking up 440,401,920 bytes. What's hapenning.