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!

removing fragmentation

Santosh PradhanSep 24 2012 — edited Sep 24 2012

Hi All,

I have table of 60 gb(indexes 60gb ) and it is subject to fragmentation around 10gb .

I m going to remove fragmentation .
As i know i have three options
1.expdp/impdp .
2.CTAS (create table ........as.......) with parallel option .
3.Moving table into another tablespace with parallel option .

I have 4 pgysical and 4 logical cores(total 8 cores) on server .

Plz suggest me which option would be more faster to decrease downtime .

Edited by: user12045405 on Sep 24, 2012 5:58 PM

Edited by: user12045405 on Sep 24, 2012 5:59 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2012

Added on Sep 24 2012

#general-database-discussions

6 comments

703 views