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

SQL*Loader-00647: Integer to number conversion error

1 Answers  


ORA-02437: cannot validate (string.string) - primary key violated

1 Answers  


QSM-02170: tables must be identical across the UNION operator

1 Answers  


ORA-25141: invalid EXTENT MANAGEMENT clause

1 Answers  


LFI-00141: Unable to abort file in operation string.

1 Answers  


ORA-30455: summary contains VARIANCE without corresponding SUM & COUNT

1 Answers  


ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table

1 Answers  


ORA-37070: You may not execute OLAP DML programs in a parallel query session.

1 Answers  


DRG-50906: score threshold string is not an integer

1 Answers  


ORA-39046: Metadata remap string has already been specified.

1 Answers  


ORA-31616: unable to write to dump file "string"

1 Answers  


ORA-01678: parameter string must be pairs of pattern and replacement strings

1 Answers  


Categories