Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30353: expression not supported for query rewrite
- 1 Answers
- 5382 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The select clause referenced UID, USER, ROWNUM,
SYSDATE, CURRENT_TIMESTAMP, MAXVALUE, a sequence number, a
bind variable, correlation variable, a set result,a trigger
return variable, a parallel table queue column, collection
iterator, etc.
Action: Remove the offending expression or disable the
REWRITE option on the materialized view.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.
ORA-14638: cannot MERGE subpartitions in different Range Composite partitions
ORA-01671: controlfile is a backup, cannot make a standby controlfile
ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.
ORA-24153: rule set string.string already exists
ORA-26041: DATETIME/INTERVAL datatype conversion error
TNS-00527: Protocol Adapter not loadable
TNS-00146: Internal-- Retry data request withing pump.
NMP-00002: no such SNMP variable name
ORA-38404: schema extension not allowed for the attribute set name
ORA-01276: Cannot add file string. File has an Oracle Managed Files file name.
PLW-05000: mismatch in NOCOPY qualification between specification and body
Oracle Errors 
