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-06812: TLI Driver: could not read the ethernet driver's node address

1 Answers  


ORA-26565: Call to <type>_arg made before calling dbms_defer.call

1 Answers  


ORA-10651: incorrect file number block number specified

1 Answers  


O2I-00103: Two file names refer to the same HFILE file in the INTYPE file

1 Answers  


ORA-04073: column list not valid for this trigger type

1 Answers  






LFI-00130: Input option specified on output only file.

1 Answers  


ORA-31661: there are no metadata transform values of type VARCHAR2

1 Answers  


ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes

1 Answers  


RMAN-12008: could not locate backup piece string

1 Answers  


LSX-00331: missing comma

1 Answers  


RMAN-05501: aborting duplication of target database

1 Answers  


ORA-28044: unsupported directory type

1 Answers  


Categories