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-28550: pass-through SQL: cursor not found

1 Answers  


ORA-03205: partition name is required when partitioned type is specified

1 Answers  


RMAN-06467: could not translate DBA: number

1 Answers  


RMAN-10026: network error number-number occurred registering connection

1 Answers  


NNL-00920: Time until next config save: string

1 Answers  


LSX-00253: branch is empty

1 Answers  


ORA-23514: invalid or incorrect number of arguments

1 Answers  


ORA-14084: you may specify TABLESPACE DEFAULT only for a LOCAL index

1 Answers  


PCC-02154: Close file: string

1 Answers  


ORA-29531: no method string in class string

1 Answers  


PCC-02210: C++ punctuation sequences are not permitted

1 Answers  


TNS-12602: TNS: Connection Pooling limit reached

1 Answers  


Categories