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-27461: The value for attribute string is too large.
ORA-25294: Queue string has a buffer
DRG-11826: Proxy Authentication Required
ORA-16003: standby database is restricted to read-only access
DRG-11703: user string must have at least CTXAPP role to execute this function
RMAN-05504: at least two redo log files or groups must be specified for this command
ORA-21708: inappropriate operation on a transient object
SQL-02151: Invalid host variable for exact numeric SET statement item
ORA-14013: duplicate partition name
ORA-02791: Unable to open file for use with asynchronous I/O
RMAN-06520: archived logs required to recover from this backup will not be kept
KUP-04054: internal error: invalid bad row number identified for bad column number