ORA-30075: TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint

ORA-30075: TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint
Cause: User is trying to create a constraint on a time or timestamp with or without time zone column without explicitly specifying the time zone.
Action: Use time or timestamp with time zone literals only.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30075：TIME / TIMESTAMP WITH TIME ZONE字面值必须在CHECK约束中指定,
.原因：用户正在尝试在没有明确指定时区的情况下，对带有或不带有时区列的时间或时间戳创建约束。,
.操作：仅使用时区或时间戳与时区文字。,
.

aiaiDBA

13718043309

010-86462881

ORA-30075: TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint

1 个回答

相似问题