Re: Re-organizing tables containing LONG datatypes?

> I am re-organizing tables in an Oracle database to compress table
> extents,

If you have enough space for 2 copies of the table on-line -

• create the new table with required STORAGE
• use SQL*Plus COPY to copy the data from the old table to the new
• drop the old table
• rename the new one

Alastair Newson             'When the best leader's work is done, 
Technical Projects Manager          the people say, 
Glaxo Pharms UK Ltd              "We did it ourselves!"'