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-01113: HAVING clause of mv, string, is more restrictive
than query



QSM-01113: HAVING clause of mv, string, is more restrictive than query..

Answer / guest

Cause: The materialized view contains a selection condition
in the HAVING clause that is more restrictive than the
corresponding selection condition in the request query.

Action: Change the selection criteria in the request query
to be at least as restrictive as the selection criteria in
the materialized view, or drop and recreate the materialized
view using less restrictive selection criteria.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02282: duplicate or conflicting ORDER/NOORDER specifications

1 Answers  


TNS-01184: Listener rejected registration or update of service handler "string"

1 Answers  


LSX-00333: literal "~S" is not valid with respect to the pattern

1 Answers  


PLS-00515: The type of the REF INTO variable 'string' must be REF to the table's type

1 Answers  


SQL*Loader-00937: parallel load requested and string has enabled triggers or constraints

1 Answers  


RMAN-06750: SPFILE cannot be backed up by proxy.

1 Answers  


ORA-07234: slemcw: fseek error.

1 Answers  


ORA-06736: TLI Driver: server not running

1 Answers  


ORA-08194: Flashback Table operation is not allowed on materialized views

1 Answers  


ORA-27144: attempt to kill process failed

1 Answers  


ORA-14607: Tablespace was not specified for previous subpartitions in template but is specified for string

1 Answers  


RMAN-06067: RECOVER DATABASE required with a backup or created controlfile

1 Answers  


Categories