Re: Table fragmentation

Don't forget the easiest way providing adequate space exists in the tablespace or the tablespace can be changed: alter table x move;

No loss of grants, constraints, etc... to worry about Just follow with alter index x_1 rebuild;

Same warning exists that the index tablespace must have enough free space to hold the index or you will have to relocate it to a new tablespace.

HTH -- Mark D Powell -- Received on Wed Jan 12 2005 - 18:09:36 CST