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

TNS-00211: Total Active Pumps : number

1 Answers  


ORA-35074: (QFHEAD02) EIF file string cannot be read by this version of string.

1 Answers  


ORA-02269: key column cannot be of LONG datatype

2 Answers  


PCC-00038: Unable to open a cursor

1 Answers  


RMAN-08073: deleted backup piece

1 Answers  






TNS-04069: Sleeping for number seconds...

1 Answers  


LPX-00401: invalid QName in the XSL file

1 Answers  


ORA-36690: (NTEXTCNV01) Error during conversion from NTEXT to TEXT.

1 Answers  


ORA-06804: TLI Driver: could not bind an IPX address at initialization

1 Answers  


NNL-00015: type "string" has "string" syntax, which has no textual representation

1 Answers  


PLS-00330: invalid use of type name or subtype name

1 Answers  


QSM-00513: one or more of the workload tables is missing

1 Answers  


Categories