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-24381: error(s) in array DML

1 Answers  


ORA-16096: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY

1 Answers  


LPX-00003: duplicate entry in hash table

1 Answers  


PLS-00951: %s Feature is not supported by this release

1 Answers  


ORA-09280: sllfcf: error closing file

1 Answers  






ORA-36960: (XSFCAST27) The value of the string expression must be an odd number. You specified number.

1 Answers  


ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.

1 Answers  


ORA-28035: Cannot Get Session Key for Authentication

1 Answers  


DRG-12411: SQL processing error: string

1 Answers  


RMAN-06401: database is already started

1 Answers  


ORA-30032: the suspended (resumable) statement has timed out

1 Answers  


ORA-15064: communication failure with ASM instance

1 Answers  


Categories