ORA-01870: the intervals or datetimes are not mutually
comparable



ORA-01870: the intervals or datetimes are not mutually comparable..

Answer / guest

Cause: The intervals or datetimes are not mutually comparable.

Action: Specify a pair of intervals or datetimes that are
mutually comparable.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13770: Baseline "string" does not exist.

1 Answers  


RMAN-06054: media recovery requesting unknown log: thread string seq string lowscn string

1 Answers  


ORA-25284: Invalid value string for string

1 Answers  


ORA-13282: failure on initialization of coordinate transformation

1 Answers  


TNS-00537: Index into protocol adapter table is out of legal range

1 Answers  






NNC-00004: connection is broken

1 Answers  


ORA-22163: left hand and right hand side collections are not of same type

1 Answers  


ORA-19668: cannot do full restore of datafile string

1 Answers  


NNL-00556: set|show reset_stats_interval [<seconds>] [<server_list>] : set|show server statistic counter reset interval

1 Answers  


DRG-12015: The source document for this operation has moved - continue?

1 Answers  


KUP-03999: error occurred while processing a date format: ORA-number: string

1 Answers  


QSM-01099: non-tolerated reference to stale portion of mv for table string

1 Answers  


Categories