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..

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

ORA-01159: file is not from same database as previous files - wrong database id

1 Answers  


QSM-00796: the specified SQL statement cannot be stored in the workload because table string does not have valid statistics

1 Answers  


ORA-14119: specified partition bound is too long

1 Answers  


ORA-29513: referenced class name too long

1 Answers  


ORA-38413: elementary attribute name may not be longer than 32 characters

1 Answers  






ORA-01236: Error string occurred during initialization of file header access

1 Answers  


ORA-12482: internal MLS error: string Error: string

1 Answers  


NCR-02004: NCRF: Invalid format interpreter type context

1 Answers  


EXP-00103: The FLASHBACK_TIME parameter was invalid

1 Answers  


ORA-31013: Invalid XPATH expression

1 Answers  


DRG-12223: section name string is a reserved name

1 Answers  


ORA-09802: Conversion of binary label to string failed.

1 Answers  


Categories