ORA-14132: table cannot be used in EXCHANGE
Answer / guest
Action: Make sure the non-partitioned table does not violate
any of the above restrictions for the ALTER TABLE EXCHANGE
PARTITION | SUBPARTITION command.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-06401: NETCMN: invalid driver designator
PLS-00124: name of exception expected for first arg in exception_init pragma
ORA-27123: unable to attach to shared memory segment
QSM-02135: agg(expr) requires correspondng AVG(expr) function
ORA-27092: size of file exceeds file size limit of the process
ORA-32815: message system link string is referenced by a foreign queue
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-02751: osnfsmmap: cannot map shared memory file
AMD-00139: level names parameter not valid
ORA-39140: dump file "string" belongs to job string
ORA-01518: CREATE DATABASE must specify more than one log file
RMAN-08074: crosschecked backup piece: found to be 'string'