ORA-30086: interval year-month result not allowed for
datetime subtraction



ORA-30086: interval year-month result not allowed for datetime subtraction..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-27481: "string.string" has an invalid schedule

1 Answers  


ORA-39707: compatibile parameter string too high for downgrade to string

1 Answers  


NZE-29047: Mismatch in Transport Layer Security extension

1 Answers  


ORA-13227: SDO_LEVEL values for the two index tables do not match

1 Answers  


ORA-24085: operation failed, queue string is invalid

1 Answers  






NNF-04005: Cannot open inputfile

1 Answers  


RMAN-06007: target database not mounted and db_name not set in init.ora

1 Answers  


RMAN-06724: backup not done; all files already backed up

1 Answers  


TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.

1 Answers  


ORA-14508: specified VALIDATE INTO table not found

1 Answers  


ORA-13003: the specified range for a dimension is invalid

1 Answers  


LCD-00128: invalid positional parameter value [string]

1 Answers  


Categories