Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30086: interval year-month result not allowed for
datetime subtraction
- 1 Answers
- 3438 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 |
DRG-50936: query word string is too complex for index
DRG-11112: length of string exceeds maximum of string
ORA-13780: SQL statement does not exist.
DRG-13306: 'len' attribute value must be in the range string..string, at line string
RMAN-00567: Recovery Manager could not print some error messages
ORA-12409: policy startup failure for string policy
SQL*Loader-00929: Error parsing insert statement for table string.
RMAN-06582: AS COPY option cannot be used when backing up backupsets
ORA-16552: An error occurred when generating the CLIENT OPERATION table.
TNS-01414: "string", state string, established string, refused string, current string, max string
PCC-01202: Identifier "string" truncated to 31 characters
ORA-23431: wrong state: string
Oracle Errors 
