Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30086: interval year-month result not allowed for
datetime subtraction
- 1 Answers
- 3348 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-19004: Duplicate XMLType OBJECT RELATIONAL storage option
LSX-00011: internal error: ~s
ORA-02345: cannot create a view with column based on CURSOR operator
RMAN-08035: partial resync skipped, target database not mounted
NNL-00305: Server dumping statistics to the log file
PLS-00580: supertype must be an object type
IMP-00013: only a DBA can import a file exported by another DBA
NZE-28782: data source is not allocated
ORA-32509: watchpoint was already deleted
ORA-30157: An invalid argument was given to operating system call
ORA-37106: (XSVPART06) Invalid partition name number.
ORA-01861: literal does not match format string
Oracle Errors 
