Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30086: interval year-month result not allowed for
datetime subtraction
- 1 Answers
- 3306 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 |
PLS-00406: length of SELECT list in subquery must match number of assignment targets
AMD-00102: invalid metadata entity: string "string"
ORA-30683: failure establishing connection to debugger
SQL*Loader-00607: partition not empty for INSERT option; table string, partition string
ORA-30738: object "string" does not exist in schema "string"
QSM-01009: materialized view, string, matched query text
ORA-04030: out of process memory when trying to allocate string bytes (string,string)
TNS-01047: Old Parameter File string
RMAN-06077: datafile string is a different version than contained in the controlfile
ORA-16543: invalid request made to broker
ORA-13430: the GeoRaster object has null attribute(s)
PLS-00228: Illegal declaration of variable of type LONG
Oracle Errors 
