ORA-30086: interval year-month result not allowed for
datetime subtraction
- 1 Answers
- 2615 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-17626: ksfdcre: string file exists
ORA-02046: distributed transaction already begun
ORA-39705: component 'string' not found in registry
DRG-11823: Not Found
RMAN-06546: Error occurred getting response - assuming NO response
TNS-00261: Interchange Name Community Link Down Time Remaining (secs)
ORA-30083: syntax error was found in interval value expression
KUP-04067: internal error allocating handle type string
RMAN-06489: no configuration found to allocate clone channel number for device type string
IMG-00824: fail queue pop failed
NZE-28794: data type attribute did not initialize
ORA-28583: remote references are not permitted during agent callbacks
Oracle Errors 
