Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30086: interval year-month result not allowed for
datetime subtraction
- 1 Answers
- 3376 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: An attempt was made to specify interval year to month
as the result of datetime subtraction.
Action: This is not allowed currently due to unclear
specification in SQL Standards for this interval type.
Change the interval type to interval day to second and
resubmit statement.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-12910: cannot specify temporary tablespace as default tablespace
ORA-28593: agent control utility: command terminated with error
ORA-13348: polygon boundary is not closed
ORA-28561: unable to set date format on non-Oracle system
ORA-00272: error writing archive log string
ORA-36198: (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified %4p as a weight.
ORA-06906: CMX: cannot get maximum packet size from CMX
ORA-32690: Hash Table Infrastructure ran out of memory
TNS-01159: Internal connection limit has been reached; listener has shut down
ORA-29316: datafile string been imported twice
ORA-25246: listen failed, the address string is an 8.0 style exception queue
ORA-36875: (XSFTDSC05) LIMITMAP is missing or is not a string literal.
Oracle Errors 
