Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02436: date or system variable wrongly specified in
CHECK constraint
- 1 Answers
- 4788 Views
- I also Faced
- E-Mail Answers
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 |
TNS-12595: TNS:no confirmation
ORA-16757: Resource guard could not get property
ORA-27025: skgfqsbi: invalid media manager context area size
ORA-09825: Unable to disable allowmacaccess privilege.
PCC-00073: Cursor is declared but never OPENed at line number in file string.
LSX-00274: invalid padding in base64-encoded binary
ORA-00481: LMON process terminated with error
ORA-12723: regular expression too complex
ORA-01598: rollback segment 'string' is not online
RMAN-06464: BACKUP BACKUPSET is not supported with VALIDATE option
DRG-12300: an index with this column list already exists in the index set
SQL*Loader-00627: Character set conversion graph not available.
Oracle Errors 
