Oracle 11g partitioning interval reference
I have a current table design (1 parent table, 10 child tables) that
would benefit from both interval and reference partitioning.The parent table key is id1 and the partition key would be id2 - both are number(18).
The child tables all have id1 as the key.
All my queries are driven by either id or id2.
I would like to setup the parent table to use interval partitioning so as new id2s are created they go into a new partition for the parent table, I then want the child table to be reference partitioning so the partitions are created when the new interval partition gets created at the parent.
The child tables all have id1 as the key.
All my queries are driven by either id or id2.
I would like to setup the parent table to use interval partitioning so as new id2s are created they go into a new partition for the parent table, I then want the child table to be reference partitioning so the partitions are created when the new interval partition gets created at the parent.
0