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!

Which is the Best method to Split Partition

949291Dec 6 2012 — edited Dec 7 2012

Hello,

Could you please suggest, which is the best and less impacted and fast method to split partition ?
As of i know Following are there but i am not sure which is the best one.

1.Normal Split partition
2.Normal Split partition with alter index
3.Exchange table + split
4.dbms_redefination
5. fast split.

I have oracle 11.2.0.2.0 version db on linux machine.

Thanks in advance,
Sachin

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2013

Added on Dec 6 2012

#general-database-discussions

10 comments

1,085 views