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-30042: Cannot offline the undo tablespace

1 Answers  


ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 Answers  


SQL*Loader-00136: Invalid argument for RESUMABLE_NAME

1 Answers  


NNL-00553: Displays forwarding statistics

1 Answers  


ORA-01156: recovery in progress may need access to files

2 Answers  






ORA-32585: duplicate specification of a supplemental log attribute

1 Answers  


ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

1 Answers  


ORA-25020: renaming system triggers is not allowed

1 Answers  


NZE-28831: no data unit format

1 Answers  


ORA-04011: sequence string must range between string and string

1 Answers  


ORA-31673: worker process interrupt for normal exit by master process

1 Answers  


AMD-00125: dimension #string: analytic workspace column level dimension not specified

1 Answers  


Categories