Table defragmentation

Hi,
Oracle 9.2.0.5

Other than recreating the table and index, is there any other method to reduce number of extents and chanined rows.

TIA,
Rakesh
groraAsked:
Who is Participating?
 
BobMcConnect With a Mentor Commented:
Only way to reduce chained rows is to either make your database blocks bigger, or reduce the size of the table (data stored per row).

To reduce the number of extents, you need to change the storage parameters - make NEXT bigger will stop it extending, but wont reduce the number of extents.

Personally, I would move the table to a locally managed tablespace with uniform extents (of suitable size), and forget all about it.

HTH
Bob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.