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

Oracle Error Message

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

Reason for the Error

User is trying to create a constraint on a time or timestamp with or without time zone column without explicitly specifying the time zone.

Solution

Use time or timestamp with time zone literals only.