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-25306: Queue table string has buffered queues. Cannot alter

1 Answers  


NNL-00851: Renames refused, name is not a leaf name: number

1 Answers  


LCD-00209: missing value for keyword at end of string [string]

1 Answers  


RMAN-03038: Spooling started in trace file: string

1 Answers  


ORA-23515: materialized views and/or their indices exist in the tablespace

1 Answers  






QSM-00766: a SQL statement is required for the current workload operation

1 Answers  


ORA-06261: NETNTT: nrange() failed

1 Answers  


ORA-19557: device error, device type: string, device name: string

1 Answers  


ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

2 Answers  


ORA-06912: CMX: write error in datarq

1 Answers  


ORA-19008: Invalid version of the XMLType

1 Answers  


ORA-29960: line string, string

1 Answers  


Categories