SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Building a PK Constraint Using Parallel

rjsosiSep 17 2021 — edited Sep 17 2021

Hi,
Were using Oracle 12c.
We're building a PK Constraint on a table that has over 37 billion rows in it.
The table is partitioned.
Is there a way to build the constraint on this table wit some kind of Parallel option?

An alternative question would be, is it possible to build a PK Constraint on just the latest partition?
Thanks

Added on Sep 17 2021

#dba, #oracle

15 comments

4,057 views