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

NNL-00509: set|show cache_checkpoint_interval [<seconds>] [<server_list>] : set|show the server's cache checkpoint interval

1 Answers  


PCB-00221: OCCURS DEPENDING ON clause not allowed for host variable "string"

1 Answers  


ORA-25329: AQ array operations not allowed on 8.0 queues

1 Answers  


ORA-24030: Only one of rule or rule-set must be specified

1 Answers  


DRG-10823: invalid query name

1 Answers  






ORA-19559: error sending device command: string

1 Answers  


ORA-16154: suspect attribute: string

1 Answers  


SQL*Loader-03120: Resumable parameters ignored -- current session not resumable

1 Answers  


ORA-07268: szguns: getpwuid error.

1 Answers  


PCC-00015: Unrecognized Host Language syntax ignored at line number in file string

1 Answers  


TNS-12521: TNS:listener does not currently know of instance requested in connect descriptor

1 Answers  


ORA-02213: duplicate PCTUSED option specification

1 Answers  


Categories