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 |
RMAN-08090: channel string: starting proxy restore
ORA-00356: inconsistent lengths in change description
ORA-01413: illegal value in packed decimal number buffer
ORA-01469: PRIOR can only be followed by a column name
NZE-28797: invalid key data type
ORA-12995: no columns in partially dropped state
RMAN-06724: backup not done; all files already backed up
ORA-00335: online log string: No log with this number, log does not exist
ORA-01915: invalid auditing option for views
ORA-02403: plan table does not have correct format
LCD-00209: missing value for keyword at end of string [string]
ORA-19610: directory block string is corrupt