Database DataWarehousing (MOSC)

MOSC Banner

Can I create interval partition on primary and reference partition on child on a column not referent

Oracle Database Enterprise Edition

19.14.0.0

Can I create interval partition on primary and reference partition on child on a column not referentially integrated?

We have two referentially integrated tables A (primary) and B (child) on column SQL_RUN_ID.

both the tables has one more common column FINISH_DATE.

Can I create interval partition on table A on column FINISH_DATE

and a reference partition on table B on column FINISH_DATE without creating reference constraint on FINISH_DATE.

Thanks for helping

Ranadeep

Tagged:

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