Database DataWarehousing (MOSC)

MOSC Banner

Oracle 11g partitioning interval reference

edited Jul 10, 2013 4:22AM in Database DataWarehousing (MOSC) 2 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center