重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-02436: date or system variable wrongly specified in CHECK constraint [打印本页]

作者: admin    时间: 2016-7-22 10:42
标题: ORA-02436: date or system variable wrongly specified in CHECK constraint
ORA-02436: date or system variable wrongly specified in CHECK constraint
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.






欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2