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

ORA-36376: (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.

1 Answers  


RMAN-11006: WARNING: test recovery results: string

1 Answers  


ORA-15014: location 'string' is not in the discovery set

1 Answers  


ORA-01516: nonexistent log file, datafile, or tempfile "string"

1 Answers  


ORA-06550: line string, column string: string

1 Answers  






ORA-17504: ksfddel:Failed to delete file string

1 Answers  


ORA-24018: STOP_QUEUE on string failed, outstanding transactions found

1 Answers  


LPX-00261: invalid URL ~s

1 Answers  


DRG-11306: operation cannot be performed on a policy

1 Answers  


ORA-09916: Required password was not specified.

1 Answers  


RMAN-10005: error opening cursor

1 Answers  


ORA-29843: indextype should support atleast one operator

1 Answers  


Categories