Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

delete millions of rows and fragmentation

873236Mar 18 2013 — edited Mar 18 2013
Hi Gurus,

i have deleted 20 lak rows from a table which has 30 lak rows,

and i wanted to release the fragmented space , please tell me the procedure other than exp/imp or alter table move

and also the recommended way to do this prod env... (coalesce /alter move etc.. )

db version is 11.2

Thanks for great help
Raj
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2013
Added on Mar 18 2013
7 comments
981 views