Best way to unfragment a table?

In your experience, what's the best way to unfragment a table? I'm debating the best way to reduce a table with many extents.

Would you...

     Export/import the table using compression?
     Create a new table and copy the data?
     

I was planning to try the second method but quickly realized that there are sequences, triggers, indexes and constraints to consider.

The export/import seems easier because it should maintain the relationships amongst objects.

Your experiences?

Rose Received on Tue Feb 16 1999 - 13:13:21 CST