Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.