Re: "Defrag" a table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 24 Sep 1999 10:04:45 +0100
Message-ID: <938164315.16336.0.nnrp-08.9e984b29@news.demon.co.uk>

Your best bet may be to:

create new table from old table to copy the 3 rows truncate old_table
copy rows back from new_table to old_table

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Frederik Hansen wrote in message <37EB3288.A57337D1_at_post1.tele.dk>...
>Hi Chetan
>
>> If u can, export and import the table to eliminate the fragmentation.
>
>Isn't there another way??
>
>Frederik Hansen
Received on Fri Sep 24 1999 - 04:04:45 CDT