ORA-30354: Query rewrite not allowed on SYS relations
Answer / guest
Cause: A SYS relation was referenced in the select clause
for a materialized view with query rewrite enabled.
Action: Remove the reference to the SYS relation from the
select clause or disable the REWRITE option on the
materialized view.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
PCC-02331: undefined SQL identifier
ORA-01104: number of controlfiles (string) does not equal string
ORA-32018: parameter cannot be modified in memory on another instance
ORA-09808: Could not obtain user clearance.
ORA-01307: no LogMiner session is currently active
NNL-01007: VERSION SKEW responses received: number
NZE-28838: no identity descriptor
ORA-00910: specified length too long for its datatype
ORA-01157: cannot identify/lock data file string - see DBWR trace file
ORA-13016: specified topology [string] is invalid
RMAN-06195: auxiliary database not started