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!

can we change parition key in oracle

565966Sep 26 2011 — edited Sep 27 2011

Hi All,

I have a query regarding the partitioned tables.

1. Does oracle supports changing the partition key (9i/10/11g)? If yes, what are the best possible ways to change the current partition key to a new one.

Ex:

My existing table TEST has a range parition key on orders_date column and i would like to change it to invoice_date? The data is very huge since it has historical data in it.

Also the table TEST contains local indexes, will there be any impact on them?

~Pointer.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2011

Added on Sep 26 2011

#general-database-discussions

3 comments

159 views