8i+
alter table BLAH move;
and then rebuild indexes..
Cheers
Connor
--- Muthaiah <[EMAIL PROTECTED]> wrote: > Hi,
>
> 1. Create a dummy table by using
> create table dummy_table as select * from
> original_table;
> 2. Truncate your original_table
> 3. insert into original_table sele
Hi,
1. Create a dummy table by using
create table dummy_table as select * from original_table;
2. Truncate your original_table
3. insert into original_table select * from dummy_table;
This will eliminate the fragmenataion
Hope this helps,
Regards,
Muths
At 11:40 PM 4/28/01 -0800, yo
hi oracle gurus,
how can I defrag a table?
this table has many relations,I was going to drop them and export the table
and import it again,then create the relations.
this is very tedious!
is their any better way?
stuck with fragmented tables
_