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-29557: Java system class string cannot be modified

1 Answers  


ORA-27065: cannot perform async vector I/O to file

1 Answers  


IMP-00064: Definition of LOB was truncated by export

0 Answers  


RMAN-06150: auxiliary name for datafile number set to: string

1 Answers  


KUP-04054: internal error: invalid bad row number identified for bad column number

1 Answers  


ORA-04052: error occurred when looking up remote object stringstringstringstringstring

1 Answers  


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

1 Answers  


ORA-25290: Cannot complete operation on queue string with existing messages

1 Answers  


SQL*Loader-00269: Null string not allowed as clause comparison text.

1 Answers  


DRG-11718: multiple Preferred Terms for term string

1 Answers  


ORA-15125: ASM file name 'string' contains an invalid template name

1 Answers  


ORA-19751: could not create the change tracking file

1 Answers  


Categories