ORA-02436: date or system variable wrongly specified in
CHECK constraint
- 1 Answers
- 4846 Views
- I also Faced
- E-Mail Answers
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 |
PLS-00418: array bind type must match PL/SQL table row type
ORA-19800: Unable to initialize Oracle Managed Destination
NNL-00250: DEFAULT-FORWARDERS-ONLY mode is currently disabled
ORA-06913: CMX: error during redirection of connection
ORA-19685: SPFILE could not be verified
ORA-13294: cannot transform geometry containing circular arcs
ORA-15068: maximum number of diskgroups string already mounted
ORA-38732: Expected file size string does not match string.
PCC-01007: WORKING-STORAGE SECTION not found
PLS-00144: duplicate external CALLING STANDARD specification in subprogram expression
RMAN-05016: failover to previous backup
ORA-00317: file type string in header is not log file
Oracle Errors 
