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

DRG-13310: index owner does not have EXECUTE privilege on USER_LEXER stored procedure string

1 Answers  


PCC-02406: Expecting the form 'RETURN[ING] REF INTO :<ref>' only

1 Answers  


ORA-03213: Invalid Lob Segment Name for DBMS_SPACE package

1 Answers  


DRG-11609: URL store: unable to open local file specified by string

1 Answers  


ORA-31182: Too many PL/SQL DOM handles specified

1 Answers  






ORA-34145: (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object.

1 Answers  


ORA-15060: template "string" does not exist

1 Answers  


ORA-31686: error creating worker processes

1 Answers  


DRG-50850: %(1)s

1 Answers  


ORA-32152: Cannot perform operation on a null number

1 Answers  


ORA-09833: addCallback: bad message format.

1 Answers  


O2F-00329: Type or option specification expected

1 Answers  


Categories