Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-00258: Server-generated requests currently do not require authoritative answers

1 Answers  


QSM-02003: aggregate function nested within an expression

1 Answers  


ORA-31452: invalid value string for parameter, expecting: Y or N

1 Answers  


TNS-01047: Old Parameter File string

1 Answers  


ORA-25271: queue table not found for the given queue

1 Answers  






ORA-16174: user requested thread/sequence termination of managed recovery

1 Answers  


ORA-01224: group number in header string does not match GROUP string

1 Answers  


ORA-16007: invalid backup control file checkpoint

1 Answers  


RMAN-07507: cataloging files...

1 Answers  


ORA-31440: change set string is empty and cannot be advanced

1 Answers  


ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications

1 Answers  


RMAN-10023: RPC attempted to unrecognized package

1 Answers  






Categories