Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30086: interval year-month result not allowed for
datetime subtraction
- 1 Answers
- 3355 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-00132: syntax error or unresolved network name 'string'
ORA-02087: object locked by another process in same transaction
ORA-01092: ORACLE instance terminated. Disconnection forced
DRG-13102: index partition name must be specified
PLS-01417: Use of %%attribute
ORA-24775: cannot prepare or commit transaction with non-zero lock value
ORA-36988: (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.
DRG-11612: URL store: unknown host specified in string
NNF-00002: Invalid value passed to function call
ORA-07624: smsdes: $DGBLSC failure
TNS-04212: Trace Assistant Internal ERROR: NACOM Type Error
ORA-12165: TNS:Trying to write trace file into swap space.
Oracle Errors 
