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-14094: invalid ALTER TABLE EXCHANGE PARTITION option

1 Answers  


PCB-00214: JUSTIFIED clause not allowed for host variable "string"

1 Answers  


DRG-12302: invalid column list

1 Answers  


TNS-01414: "string", state string, established string, refused string, current string, max string

1 Answers  


ORA-27469: %s is not a valid string attribute

1 Answers  


ORA-01626: rollback segment number 'string' cannot handle more transactions

1 Answers  


ORA-26663: error queue for apply process string must be empty

1 Answers  


ORA-27028: skgfqcre: sbtbackup returned error

1 Answers  


PLS-01913: : instance must of be of type 'string' or one of its subtypes

1 Answers  


RMAN-08160: script commands will be loaded from file string

1 Answers  


ORA-31066: Insertion of string into string creates a cycle

1 Answers  


DRG-50921: EQUIV operand not a word or another EQUIV expression

1 Answers  


Categories