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

NNL-00208: Cancelled reload check

1 Answers  


ORA-30075: TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint

1 Answers  


ORA-01890: NLS error detected

2 Answers  


ORA-07650: sigunc: $GETJPIW failure

1 Answers  


TNS-03601: Failed in route information collection

1 Answers  






ORA-13208: internal error while evaluating [string] operator

1 Answers  


ORA-24309: already connected to a server

2 Answers  


IMG-00521: invalid value for dataOffset

1 Answers  


LSX-00145: attribute "~1S" invalid derived value "~2S"

1 Answers  


NCR-04006: NCRR: Invalid argument descriptor

1 Answers  


ORA-26063: Can not flashback to specified SCN value - Wrap: string Base: string.

1 Answers  


ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor

1 Answers  


Categories