Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02436: date or system variable wrongly specified in
CHECK constraint
- 1 Answers
- 4711 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 |
LPX-00214: CDATA section did not end in "]]>"
PCC-02338: structure contains a nested struct or union
PLS-00305: previous use of 'string' (at line string) conflicts with this use
SQL*Loader-00620: Initial enclosure character not found
ORA-24004: invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
PCC-00023: Unable to log off from ORACLE
NNL-00240: Starting "string"...
ORA-33280: (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.
ORA-37101: (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.
PCC-00002: Invalid syntax at column number in line number of file string
ORA-02834: Server unable to open file
LFI-00106: Path object holds more than one path.
Oracle Errors 
