Skip to Main Content

Oracle Database Free

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!

Purpose of PRECHECK ?

Mike KutzOct 22 2023

23c Constraints have another state: precheck

As I see it, it allows the DB to not perform the check and assume that the constraint was pre-validated within the application. (I liken it to a RAS External user/role)

But, doesn't rely disable allow for the same thing?

what is the “something special” that precheck provides that rely disable does not?

This post has been answered by Loïc Lefèvre-Oracle on Oct 30 2023
Jump to Answer
Comments
Post Details
Added on Oct 22 2023
9 comments
666 views