Freeing up Disk space
I have just done an offline table reorg for all tablespaces using brtools and oracle 10g, with the intention of dropping some datafiles and allocating them elsewhere.
But even though I now have 90G free I am unable to remove any datafiles.
How do I remove these datafiles or resize them properly? I've read countless postings but none of them result in the space saving I can see in dbacockpit.
I'm sorry to bring the bad news, but there is no other way (or I will be very happy to be proved wrong) to recover that space.
Oracle does know it has free space, it will use that free space by further object growth.
- You cannot drop a datafile unless it is empty (Dropping Datafiles) and (here It seems I was mistaken, thanks) it cannot be the first or only datafile.
- You cannot "empty" a datafile (at least easily as it would involve to export the objects that have a part on that datafile, drop those objects, drop the datafile and import them again)
- You can resize a datafile as mentioned but only if there is no object on the space to be freed (Managing Datafiles and Tempfiles)
For that reason I said that the best would have planned it previously