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 |
DRG-10750: unknown parameter string
RMAN-06093: recovery catalog contains obsolete version of datafile string
DRG-10851: Invalid grammar string specified for query template
ORA-38402: invalid name: empty string or spaces in the name
ORA-25185: index column other than last can not be specified for INCLUDE clause
ORA-06027: NETASY: channel close failure
TNS-00288: Navigator: Failed to Disable Interchange
ORA-01295: DB_ID mismatch between dictionary string and logfiles
DRG-11208: ORACLE_HOME is not set
ORA-23438: missing refresh group template
DRG-51311: DML lock handle previously allocated
DRG-11130: no data found in the collection