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 |
ORA-24769: cannot forget an active transaction
ORA-29927: error in executing the ODCIStatsCollect / ODCIStatsDelete routine
DRG-11877: This Cache Version Has Expired And Will Be Automatically Reloaded
ORA-02001: user SYS is not permitted to create indexes with freelist groups
ORA-15047: ASM file name 'string' is not in multiple-file creation form
QSM-01104: query is using flashback
PROC-00009: Cannot perform cluster registry operation because the buffer passed is too small.
NNO-00109: line string: invalid data type name "string", data ignored
RMAN-06496: must use the TO clause when the database is mounted or open
ORA-08451: invalid specification of DB in picture mask
DRG-51030: wildcard query expansion resulted in too many terms
PROC-00025: Error in the NLS services