Reclaiming space in your tablespace after a large delete or drop
Question: I need to move a large table from one tablespace into its own tablespace. What is the best approach to proceed taking into account that I need to reclaim the space from the old tablespace. Export/Import? Truncate the table afterward - though not sure if this lowers the high water mark, alter table move? A simplistic assignment but the proof in concept must work for large tables (10+ GB).
Thanks!
Dave