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-30378: MV_CAPABILITIES_TABLE is not compatible with Oracle version

1 Answers  


ORA-04047: object specified is incompatible with the flag specified

1 Answers  


PLS-00214: BEGIN...END block nesting is too deep

1 Answers  


TNS-01005: trace OFF | USER | ADMIN | SUPPORT [<listener_name>] : set tracing to the specified level

1 Answers  


ORA-13364: layer dimensionality does not match geometry dimensions

1 Answers  






ORA-38711: Corrupt flashback log block header: block string

1 Answers  


NNL-00017: cannot start server, program "string" does not exist

1 Answers  


RMAN-06606: RMAN configuration parameters are successfully reset to default value

1 Answers  


ORA-09827: SCLGT: atomic latch return unknown error.

1 Answers  


NNO-00062: cannot load domain data from configuration database

1 Answers  


TNS-01111: Log status can either be ON or OFF

1 Answers  


NNL-00544: Displays operations statistics

1 Answers  


Categories