Skip to Main Content

SQL & PL/SQL

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!

Exchange and Split partition of List patitioning

User_H7I9VMar 30 2016 — edited Apr 1 2016

Hi,

Anyone can give idea about my below scenario.

Actually i have one non-partition table A which is having one column having distinct 200 values.

I want to create a List Partition Table and want to move data using EXCHANGE and SPLIT partition.

how can i do exchange and split for 200 list values?

is it possible to do SPLIT partition on LIST?

Regards

Sanjib

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2016
Added on Mar 30 2016
11 comments
900 views