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-02115: mv references a remote object and is refreshed ON
COMMIT



QSM-02115: mv references a remote object and is refreshed ON COMMIT..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references a remote object and is
refreshed ON COMMIT.

Action: Re-phrase the query to avoid the reference to the
remote object or alter the materialized view to be refreshed
ON DEMAND.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01228: SET DATABASE option required to install seed database

1 Answers  


LFI-00110: Unable to initialize the Buffer Manager.

1 Answers  


ORA-06111: NETTCP: disconnect failure

1 Answers  


QSM-02029: PL/SQL function invocation

1 Answers  


TNS-12677: Authentication service not supported by database link

1 Answers  


ORA-25473: cannot store string in rule action context

1 Answers  


ORA-10630: Illegal syntax specified with SHRINK clause

1 Answers  


PLS-00485: in exception handler, 'string' must be an exception name

1 Answers  


SQL*Loader-00350: Syntax error at line number.

1 Answers  


ORA-23303: application raised generic exception during deferred RPC

1 Answers  


ORA-37020: (XSMULTI01) Analytic workspace string is not in MULTI mode.

1 Answers  


ORA-31097: Hierarchical Index not empty

1 Answers  


Categories