Skip to Main Content

Database Software

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!

Creating tables for partition exchange

mtefftApr 10 2015 — edited Jan 11 2016

Many datawarehouse load processes use partition-exchange techniques to introduce new data. However, creating and maintaining the tables needed for this operation can be burdensome and prone to error. I suggest a syntax like:

CREATE TABLE my_nonpartitioned_table

EXCHANGEABLE WITH my_partitioned_table;

which would pick up the columns in the correct order, the organization, indexes matching the local indexes, etc.

Taking this a step further, it should also support

CREATE TABLE my_partitioned_table

EXCHANGEABLE WITH my_subpartitioned_table;

which would have partitioning of my_partitioned_table equivalent to the subpartitioning of my_subpartitioned_table, etc.

Comments

Processing

Post Details

Added on Apr 10 2015
3 comments
585 views