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.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Jan 6 '12 at 15:28
This question came from our site for professional and enthusiast programmers.
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.