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

RMAN-06065: The backup operand [string] conflicts with another specified operand.

1 Answers  


ORA-16732: Error executing dbms_logstdby.skip procedure

1 Answers  


ORA-31675: worker process interrupt for unexpected death of master process

1 Answers  


ORA-31443: deadlock detected while acquiring lock on string

1 Answers  


ORA-38720: Missing log file number.

1 Answers  






ORA-12679: Native services disabled by other process but required

1 Answers  


AMD-00152: Workspace "string" is not currently open.

1 Answers  


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

0 Answers   IBM,


ORA-29393: user string does not exist or is not logged on

1 Answers  


LSX-00250: invalid normalizedString "~S"

1 Answers  


ORA-29892: indextypes with array DML do not support the given data type

1 Answers  


QSM-00788: the table string is invalid for directive string

1 Answers  


Categories