Oracle Database Discussions

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!

table fragmentation

1003614Dec 2 2013 — edited Dec 5 2013

Hi All,

Oracle 8i(8.1.7)

Solaris

Table Name:Activity

size : 22GB

Actual Data:10GB

Wasted Space: approx 12GB

having 7 indexes

Here am planning to remove the waste space what will be the best method?

am planning to do sql>alter table activity colsec; is it correct method or do i need to do anything extra.....?

if I enable row movement what will be the impact?

thanks,

Mike.

This post has been answered by KR10822864 on Dec 5 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2014

Added on Dec 2 2013

#general-database-discussions

14 comments

992 views