Re: Does export/import compress (deallocate) extents used by table ?

In article <12694_at_inews.intel.com> kortikar_at_mipos2.intel.com () writes:
>since oracle does not deallocate extents after a delete of say 95% rows from
>a 50 will export, drop table, import do the trick ?

Yes, but remember to specify compress=y during export so the initial extent of the table upon import will be the size of the exported data (ie, compressed into one extent).

        % exp help=y

The above will give you all the exp command line options and their default settings.

• Kathy Jou
• Oracle Corporation