Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

TNS-01405: Host: string

1 Answers  


PLS-00548: invalid use of operator.

1 Answers  


ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.

1 Answers  


ORA-39080: failed to create queues "string" and "string" for Data Pump job

1 Answers  


ORA-01804: failure to initialize timezone information

2 Answers  






LPX-00608: Repeated declaration of '~1S' in element '~2S'.

1 Answers  


ORA-16635: NetSlave connection was broken in the middle of a transmission session.

1 Answers  


RMAN-08011: including current controlfile in backupset

1 Answers  


TNS-00001: INTCTL: error while getting command line from the terminal

1 Answers  


ORA-16128: User initiated shut down successfully completed

1 Answers  


PCC-02417: Illegal type conversion between attribute and host variable

1 Answers  


RMAN-06562: available space of number kb needed to avoid reading the backup set multiple times

1 Answers  






Categories