ORA-30086: interval year-month result not allowed for
datetime subtraction
- 1 Answers
- 2584 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 |
IMP-00054: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
RMAN-08026: channel string: copied archive log
ORA-16807: unable to set protection mode to the database
ORA-09283: sllfsk: error skipping records
ORA-16550: truncated result
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
RMAN-06046: archive log name: string
ORA-22879: cannot use the LOB INDEX clause for partitioned tables
NZE-28785: parameter does not exist
LSX-00021: undefined element "~S"
ORA-30695: JDWP message format problem
ORA-27230: OS system call failure
Oracle Errors 
