Is there any partitioning scenario in which the partitioned table is absolutely required to have primary key?


Yes, reference partitioning requires a primary key on the parent table.

Reference partitioning enables the partitioning of two tables that are related to one another by referential constraints.

The partitioning key is resolved through an existing parent-child relationship, enforced by enabled and active primary key and foreign key constraints.

If you try to do this with a unique key instead of a primary key, you will get this error:

ORA-02268: referenced table does not have a primary key
  • @M.Dawid You can partition index-organized tables too. Index-organized tables must have a primary key, but that is the requirement of the IOT, not partitioning. – Balazs Papp Feb 3 '19 at 14:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.