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-19677: RMAN configuration name exceeds maximum length of string

1 Answers  


PCB-00554: Must include SQLCA when mode=ANSI and WHENEVER SQLWARNING used

1 Answers  


QSM-01120: recursive rewrite not allowed here

1 Answers  


ORA-06250: NETNTT: cannot allocate send and receive buffers

1 Answers  


ORA-30432: summary 'string.string' is in INVALID state

1 Answers  


ORA-03241: Invalid unit size

1 Answers  


ORA-07512: sscggtl: $enq unexpected return for client termination lock

1 Answers  


ORA-13231: failed to create index table [string] during R-tree creation

1 Answers  


ORA-28558: HS_FDS_CONNECT_STRING undefined for non-Oracle system

1 Answers  


ORA-38449: table "string" does not exist or is not accessible

1 Answers  


ORA-06926: CMX: T_ERROR during read data

1 Answers  


ORA-09968: scumnt: unable to lock file

1 Answers  


Categories