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 |
RMAN-06065: The backup operand [string] conflicts with another specified operand.
ORA-16732: Error executing dbms_logstdby.skip procedure
ORA-31675: worker process interrupt for unexpected death of master process
ORA-31443: deadlock detected while acquiring lock on string
ORA-38720: Missing log file number.
ORA-12679: Native services disabled by other process but required
AMD-00152: Workspace "string" is not currently open.
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...
ORA-29393: user string does not exist or is not logged on
LSX-00250: invalid normalizedString "~S"
ORA-29892: indextypes with array DML do not support the given data type
QSM-00788: the table string is invalid for directive string