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-01130: Multi MV rewrite not allowed if at least one
query block has no MVs



QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs..

Answer / guest

Cause: When only multimv query rewrite is enabled, every
query block should have at least one MV in it's from clause

Action: Disable only multimv query rewrite with ALTER
SESSION SET "_ONLY_MULTIMV_QUERY_REWRITE_ENABLED" = false .

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14621: cannot add subpartition when DEFAULT subpartition exists

1 Answers  


ORA-22920: row containing the LOB value is not locked

1 Answers  


ORA-00119: invalid specification for system parameter string

1 Answers  


ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

1 Answers  


RMAN-20401: script already exists

1 Answers  


ORA-06622: LU6.2 Driver: Unable to attach to SNA

1 Answers  


PLS-01450: This <value expression> contains a nonconforming data type

1 Answers  


TNS-01072: Started at string

1 Answers  


ORA-14401: inserted partition key is outside specified partition

1 Answers  


ORA-01526: error in opening file 'string'

1 Answers  


DRG-50906: score threshold string is not an integer

1 Answers  


NCR-03022: NCRO: Cannot send the break

1 Answers  


Categories