Re: Best way to unfragment a table?

Rose,

Go export/import if u use referential integrity. Import will also manage your grants.....

But.... don't forget to re-compile the related views, procedures, packages, functions. Import won't do it for u.

Regards,

Marc Mazerolle

skubiszewski_at_Eisner.DECUS.Org wrote:

> 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:35:21 CST