Skip to Main Content

Database Software


For appeals, questions and feedback, please email

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.

Post Details
Added on Apr 10 2015