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

DRG-10835: WITHIN operator not supported for theme index

1 Answers  


KUP-04026: field too long for datatype

1 Answers  


ORA-00328: archived log ends at change string, need later change string

1 Answers  


NNL-00800: Query requests received: number

1 Answers  


ORA-25291: Buffer does not exist for the specified queue

1 Answers  


TNS-00074: * status - get statistics from the process_name

1 Answers  


ORA-22976: incorrect number of arguments to MAKE_REF

1 Answers  


TNS-04066: The following log events can be enabled or disabled:

1 Answers  


ORA-37030: (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.

1 Answers  


NNO-00052: invalid domain description list

1 Answers  


DRG-11715: attempt to add a BT relation between 2 KB categories string and string

1 Answers  


TNS-00039: INTCTL: error while spawning a process

1 Answers  


Categories