Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-30354: Query rewrite not allowed on SYS relations



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

Post New Answer

More Oracle Errors Interview Questions

ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist

1 Answers  


PCC-02331: undefined SQL identifier

1 Answers  


ORA-01104: number of controlfiles (string) does not equal string

1 Answers  


ORA-32018: parameter cannot be modified in memory on another instance

1 Answers  


ORA-09808: Could not obtain user clearance.

1 Answers  


ORA-01307: no LogMiner session is currently active

1 Answers  


NNL-01007: VERSION SKEW responses received: number

1 Answers  


NZE-28838: no identity descriptor

1 Answers  


ORA-00910: specified length too long for its datatype

1 Answers  


ORA-01157: cannot identify/lock data file string - see DBWR trace file

1 Answers  


ORA-13016: specified topology [string] is invalid

1 Answers  


RMAN-06195: auxiliary database not started

1 Answers  


Categories