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-02149: ON COMMIT with this MV requires 9.0 compatibility
or higher



QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher..

Answer / guest

Cause: You have specified a materialized view that uses some
combination of the following: joins aggregation filter
conditions in the WHERE clause a remote relation in the FROM
list a SUM(x) function without a corresponding COUNT(x)
function an omitted COUNT(*) aggregate function a MIN() or
MAX() aggregate function in combination with the REFRESH ON
COMMIT option while running in less than 9.0 compatibility mode.

Action: Set your compatibility mode to 9.0 or higher or
restructure the materialized view query.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38413: elementary attribute name may not be longer than 32 characters

1 Answers  


TNS-12623: TNS:operation is illegal in this state

1 Answers  


ORA-09748: pws_look_up: fork failed

1 Answers  


RMAN-06451: proxy copy handle=string recid=string stamp=string

1 Answers  


ORA-36266: (XSCGMDLAGG00) Invalid context for the AGGREGATION function

1 Answers  


TNS-01171: Event detection broke for dispatcher: string

1 Answers  


QSM-02128: does not meet the requirements of a primary key mv

1 Answers  


ORA-16617: unknown object identifier specified in request

1 Answers  


ORA-24090: at least one protocol must be enabled

1 Answers  


DRG-52206: error while registering index object

1 Answers  


O2F-00321: Error opening the OUTTYPE file for writing

1 Answers  


ORA-16756: Resource guard could not open standby readonly

1 Answers  


Categories