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-10565: Another test recovery session is active

1 Answers  


ORA-06001: NETASY: port set-up failure

1 Answers  


TNS-00114: Internal error- Allocation of addresses not performed

1 Answers  


ORA-00300: illegal redo log block size string specified - exceeds limit of string

1 Answers  


PLS-00411: Number of values in aggregate and in subquery don't match

1 Answers  






ORA-30510: system triggers cannot be defined on the schema of SYS user

1 Answers  


ORA-01605: missing numbers in clause "string" of string

1 Answers  


TNS-01081: Started with pid=string

1 Answers  


ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  


ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.

1 Answers  


ORA-34363: (MXDSS13) number other user writing

1 Answers  


RMAN-06427: recovery catalog already exists

1 Answers  


Categories