ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME
ZONE literals



ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals..

Answer / guest

Cause: An attempt was made to use a time/timestamp
expression whose format does not explicitly have time zone
on a TIME/TIMESTAMP or TIME/TIMESTAMP WITH TIME ZONE column.

Action: Explicitly use TIME/TIMESTAMP WITH TIME ZONE literal.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

CLSR-00508: Invalid message number number

1 Answers  


SQL*Loader-00522: lfiopn failed for file (string)

1 Answers  


DRG-13306: 'len' attribute value must be in the range string..string, at line string

1 Answers  


ORA-06978: X.25 Driver: Too many callback tries

1 Answers  


ORA-15133: instance recovery required for diskgroup string

1 Answers  






LRM-00100: internal error [number]

1 Answers  


ORA-03251: Cannot issue this command on SYSTEM tablespace

1 Answers  


ORA-14553: cannot perform a lob write operation inside a query

1 Answers  


ORA-27502: IPC error deleting OSD context

1 Answers  


ORA-12983: cannot drop all columns in a table

1 Answers  


NZE-28810: Cannot create key descriptor.

1 Answers  


LFI-00145: User buffer too short.

1 Answers  


Categories