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