This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,534 Users
  • 2,269,776 Discussions
  • 7,916,824 Comments

Discussions

Creating tables for partition exchange

mtefft
mtefft Member Posts: 852 Gold Badge
edited Jan 11, 2016 6:21PM in Database Ideas - Ideas

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.

Lothar FlatzctriebRandolf GeistManish ChaturvediL-MachineGunMartin PreisscaadecarvalhohimmyFranck PachotZlatko SiroticPravin TakpireAish13William RobertsonulohmannpankajrangaRodrigo Jorge DBABPeaslandDBAkulikouskiAndrewSayerSven W.user3623132
23 votes

Active · Last Updated

Comments