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-06418: proxy incremental backups with level > 0 not supported
DRG-50863: string assignment failed
ORA-01666: controlfile is for a standby database
ORA-12685: Native service required remotely but disabled locally
SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string
ORA-02815: Unable to attach shared memory
ORA-12721: operation cannot execute when other sessions are active
DRG-11720: too many synonyms per synonym ring
LFI-00115: Buffer free failed.
ORA-17620: failed to register the network adapter with Oracle Disk Manager library: string
ORA-38408: The ADT "string" does not exist in the current schema.
ORA-15052: ASM file name 'string' is not in diskgroup "string"