ankush@thavali> desc emp Name Null? Type ------------------------ ------- -------- ----- EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SAL NUMBER(7,2) COMM NUMBER(7,2) DEPTNO NUMBER(2) ankush@thavali> create table emp_new as select * from emp where 1=2; Table created. ankush@thavali> insert /*+ APPEND */ into emp_new select * from emp; 14 rows created. ankush@thavali> select * from emp_new where empno = 7839; select * from emp_new where empno = 7839 * ERROR at line 1: ORA-12838: cannot read/modify an object after modifying it in parallel
ankush@thavali> drop table emp_new; Table dropped. ankush@thavali> create table emp_new as select * from emp where 1=2; Table created. ankush@thavali> insert /*+ APPEND */ into emp_new select * from emp; 14 rows created. ankush@thavali> commit; Commit complete. ankush@thavalig> select * from emp_new where empno = 7839; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7839 KING PRESIDENT 17-NOV-81 5000.15 10