QSM-02099: mv references a remote table or view in the FROM list



QSM-02099: mv references a remote table or view in the FROM list..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references a remote table or view in the
FROM list.

Action: Re-phrase the query to avoid references to remote
tables or views.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25283: either agent's name or address needed for non-repudiation

1 Answers  


ORA-28538: result set not found

1 Answers  


ORA-30018: Create Rollback Segment failed, USN string is out of range

1 Answers  


NNL-00295: Controller's local trace level is currently number

1 Answers  


ORA-30006: resource busy; acquire with WAIT timeout expired

1 Answers  


RMAN-06609: AS COPY can be configured only for disk device

1 Answers  


ORA-29313: tablespace 'string' cannot be imported twice

1 Answers  


ORA-27083: waiting for async I/Os failed

1 Answers  


DRG-11717: attempt to add Related Term string to non-Preferred Term string

1 Answers  


PLS-00160: AUTHID must specify CURRENT_USER or DEFINER

1 Answers  


IMG-00842: image index allocation failed

1 Answers  


NZE-28785: parameter does not exist

1 Answers  


Categories