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



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

Answer / guest

Cause: 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.

Action: Query ALL_CONSTRAINTS and correct those constraints
marked as bad.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LFI-00136: Unable to change type of open file.

1 Answers  


IMG-00842: image index allocation failed

1 Answers  


UDI-00050: unable to setup parameter processing.

1 Answers  


ORA-28275: Multiple mappings for user nickname to LDAP distinguished name exist.

1 Answers  


ORA-07612: $GETUAI failed in retrieving the user's clearance level

1 Answers  






ORA-36206: (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.

1 Answers  


PLW-05000: mismatch in NOCOPY qualification between specification and body

1 Answers  


TNS-00035: INTCTL: error while constructing full file name

1 Answers  


ORA-07700: sksarch: interrupt received

1 Answers  


ORA-12569: TNS:packet checksum failure

1 Answers  


IMG-00862: assert failure, inconsistency in merged area labels

1 Answers  


O2U-00203: Type to be declared must be an object type or a named collection type

1 Answers  


Categories