Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

QSM-02177: MV with UNION ALL in a view must match the view's SELECT list

1 Answers  


PROT-00012: Oracle Cluster Registry to be upgraded has an unsupported version

1 Answers  


TNS-04012: Unable to start Oracle Connection Manager instance.

1 Answers  


ORA-26677: Streams downstream capture process string cannot proceed

1 Answers  


ORA-38503: index already defined using the parameters

1 Answers  






TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.

1 Answers  


PCC-00045: %s clause inappropriate at line number in file string. Ignored.

1 Answers  


ORA-16192: Primary and standby network integrity mismatch

1 Answers  


ORA-01078: failure in processing system parameters

1 Answers  


RMAN-20201: datafile not found in the recovery catalog

1 Answers  


ORA-03248: Too much of segment creation activity during migration

1 Answers  


ORA-24172: rule set string.string has errors

1 Answers  






Categories