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...


QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based



QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based..

Answer / guest

Cause: Query rewrite did not occur because the
OPTIMIZER_MODE was set to RULE.

Action: Change the optimizer mode using the OPTIMIZER_MODE
parameter.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LSX-00023: unknown namespace URI "~S"

1 Answers  


ORA-01478: array bind may not include any LONG columns

1 Answers  


ORA-12912: Dictionary managed tablespace specified as temporary tablespace

1 Answers  


ORA-01974: Illegal archive option

1 Answers  


ORA-30373: object data types are not supported in this context

1 Answers  


DRG-10310: servers were shutdown before processing request

1 Answers  


PCC-00102: FOR UPDATE is an Oracle extension

1 Answers  


QSM-02054: DISTINCT clause in select list in mv

1 Answers  


ORA-02210: no options specified for ALTER TABLE

1 Answers  


ORA-32583: query passed to table function has wrong number of elements in select list

1 Answers  


ORA-38746: error occurred while restoring data block (file# string, block# string)

1 Answers  


ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.

1 Answers  


Categories