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-06565: cannot execute string from within stored procedure

1 Answers  


ORA-33064: (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.

1 Answers  


ORA-25106: only one of PARALLEL or NOPARALLEL clause may be specified

1 Answers  


NNO-00600: warning: forwarder count number exceeds maximum of number, first number will be loaded

1 Answers  


PCC-02332: attempted to redefine SQL identifier

1 Answers  


PLS-01463: STDDEV is not a standard set function

1 Answers  


DRG-10830: SHARELEVEL is not 0 or 1

1 Answers  


ORA-14612: Duplicate lob segment name string for lob column string in template

1 Answers  


ORA-07394: unable to append string to text file

1 Answers  


ORA-28005: invalid logon flags

1 Answers  


ORA-09794: szrbuild: length of role name is greater than buffer.

1 Answers  


ORA-23420: interval must evaluate to a time in the future

1 Answers  


Categories