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 |
PCC-02302: cannot open code generation output file "string"
ORA-23609: unable to find directory object for directory string
ORA-29370: pending area is already active
LSX-00153: invalid combination of default and fixed attributes
PCC-02424: The number of values and host variables does not match
QSM-02134: agg(expr) requires correspondng MAX(expr) function
RMAN-06045: LEVEL option not supported for archive log or current/standby controlfile copies
ORA-00374: parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
NZE-28871: Peer certificate chain is incomplete.
RMAN-04032: using contents of file string
ORA-26517: materialized view control entry for 'string.string' was not found
ORA-14401: inserted partition key is outside specified partition