QSM-02102: mv FROM list references an object in the SYS schema



QSM-02102: mv FROM list references an object in the SYS schema..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references an object in the SYS schema.

Action: Re-phrase the query to avoid the reference to the
SYS schema.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00524: Replaces a data item with another data item

1 Answers  


PLS-00634: type with NOT INSTANTIABLE methods must be declared NOT INSTANTIABLE

1 Answers  


RMAN-06583: at least 1 channel of TYPE DISK must be allocated to use AS COPY option

1 Answers  


ORA-32700: error occurred in DIAG Group Service

1 Answers  


ORA-27144: attempt to kill process failed

1 Answers  






ORA-36908: (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.

1 Answers  


ORA-28182: cannot acquire Kerberos service ticket for client

1 Answers  


ORA-28030: Server encountered problems accessing LDAP directory service

1 Answers  


ORA-15124: ASM file name 'string' contains an invalid alias name

1 Answers  


ORA-16568: cannot set property string

1 Answers  


TNS-02512: Invalid status received

1 Answers  


TNS-12661: Protocol authentication to be used

1 Answers  


Categories