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

ORA-25527: bad format of _DB_MTTR_SIM_TARGET

1 Answers  


ORA-26665: STREAMS process string already exists

1 Answers  


TNS-00540: SSL protocol adapter failure

1 Answers  


AMD-00138: level names parameter not null or defaulted

1 Answers  


TNS-00519: Operating system resource quota exceeded

2 Answers  






ORA-02224: EXECUTE privilege not allowed for tables

1 Answers  


ORA-09856: smpalo: vm_allocate error while allocating pga.

1 Answers  


PCC-00140: CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions

1 Answers  


RMAN-10023: RPC attempted to unrecognized package

1 Answers  


ORA-23453: requested operation is not supported on top flavor

1 Answers  


ORA-30365: left relation in the JOIN KEY clause cannot be same as right

1 Answers  


PCC-02316: illegal operator in constant expression

1 Answers  


Categories