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

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

Question Posted / guest

1 Answers
2734 Views
I also Faced
E-Mail Answers

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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string

1 Answers

RMAN-01008: the bad identifier was: string

1 Answers

RMAN-10025: connection is already registered for events

1 Answers

SQL*Loader-00481: HIDDEN may not be used with non-scalar fields.