Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-02436: date or system variable wrongly specified in
CHECK constraint



ORA-02436: date or system variable wrongly specified in CHECK constraint..

Answer / guest

Cause: An attempt was made to use a date constant or system
variable, such as USER, in a check constraint that was not
completely specified in a CREATE TABLE or ALTER TABLE
statement. For example, a date was specified without the
century.

Action: Completely specify the date constant or system
variable. Setting the event 10149 allows constraints like
"a1 > '10-MAY-96'", which a bug permitted to be created
before version 8.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24769: cannot forget an active transaction

1 Answers  


ORA-29927: error in executing the ODCIStatsCollect / ODCIStatsDelete routine

1 Answers  


DRG-11877: This Cache Version Has Expired And Will Be Automatically Reloaded

1 Answers  


ORA-02001: user SYS is not permitted to create indexes with freelist groups

1 Answers  


ORA-15047: ASM file name 'string' is not in multiple-file creation form

1 Answers  


QSM-01104: query is using flashback

1 Answers  


PROC-00009: Cannot perform cluster registry operation because the buffer passed is too small.

1 Answers  


NNO-00109: line string: invalid data type name "string", data ignored

1 Answers  


RMAN-06496: must use the TO clause when the database is mounted or open

1 Answers  


ORA-08451: invalid specification of DB in picture mask

1 Answers  


DRG-51030: wildcard query expansion resulted in too many terms

1 Answers  


PROC-00025: Error in the NLS services

1 Answers  


Categories