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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02436：在CHECK约束中错误指定的日期或系统变量,
.原因：试图在CREATE TABLE或ALTER TABLE语句中未完全指定的检查约束中使用日期常量或系统变量（如USER）。例如，指定的日期没有世纪。,
.操作：完全指定日期常量或系统变量。设置事件10149允许诸如“a1> '10 -MAY-96'”的约束，其允许在版本8之前创建错误。,
.

aiaiDBA

13718043309

010-86462881

ORA-02436: date or system variable wrongly specified in CHECK constraint

1 个回答

相似问题