I have a large Oracle table that need to be re-partition. I was wonder there is a way to know that I have enough space to create a copy of this table with new partition and swap the new one with the old one.
migrated from stackoverflow.com Jan 6 '12 at 15:28
A rough estimate of your table size is:
However, see the question How do I calculate tables size in Oracle for better detail as the real size of a copied table on disk can differ from the original. You can then check how much space you have in the tablespace using:
If you don't have enough space then check your other tablespaces as you can temporarily create the table in there if you have permissions.