How to fix the Oracle error IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D.?

In this post, you’ll learn more about the Oracle ErrorIMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D.

Reason for the Error IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D.

Constraints exist in the data base that specify date values without fully specifying the year. These constraints could break in the year 2000 A.D.

How to fix the Error IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D. ?

You can fix this error in Oracle by following the below steps

Query ALL_CONSTRAINTS and correct those constraints marked as bad.