Re: Reorganize a Table with a Long Field

Stéphane TALBOT wrote:
>
> Hello !
>
> I have a Table containing a LONG field. I have 13 expends, and I would like
> to reorganize it. I do not have PL-SQL installed.
>
> Want can I do for that ?
>
> Thanks.
> Stephane

Firstly, why do you need to re-organize? Contrary to popular opinion, multiple extents are *not* a performance handicap until you start getting > 100 where the space required to keep track of chains get noticeable.

If you *must* re-organize and you have the space, the simplest way is to

	create new_table as select * from old_table storage(...);
	drop old_table;	-- after backup!
	rename new_table to old_table;

Alternatively, you could EXPort your table, drop it (after backup), redefine it (don't let IMP do this) and then IMPort it. Received on Tue Feb 18 1997 - 00:00:00 CST