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-30353: expression not supported for query rewrite



ORA-30353: expression not supported for query rewrite..

Answer / guest

Cause: The select clause referenced UID, USER, ROWNUM,
SYSDATE, CURRENT_TIMESTAMP, MAXVALUE, a sequence number, a
bind variable, correlation variable, a set result,a trigger
return variable, a parallel table queue column, collection
iterator, etc.

Action: Remove the offending expression 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-25454: error during evaluation of rule set: string.string for iterator: string

1 Answers  


ORA-00315: log string of thread string, wrong thread # string in header

1 Answers  


ORA-28611: bitmap index is corrupted - see trace file for diagnostics

1 Answers  


NZE-28862: SSL connection failed

1 Answers  


ORA-22907: invalid CAST to a type that is not a nested table or VARRAY

1 Answers  


SQL*Loader-00480: EXPRESSION may not be used with elements of a collection.

1 Answers  


ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.

1 Answers  


DRG-50864: number assignment failed

1 Answers  


ORA-14313: Value string does not exist in partition string

1 Answers  


ORA-00001: unique constraint (string.string) violated

1 Answers  


RMAN-03020: asynhronous RPC test will take 1 minute

1 Answers  


ORA-26502: error resignal

1 Answers  


Categories