direct path insert and sga
Hello,
I tried below scenario and found blocks of table in sga after doing direct path insert - Please suggest what happens in direct path insert like how it's different from conventional?
SQL> select object_id from dba_objects where object_name='EMP_DATA2';
OBJECT_ID
----------
16543
SQL> select count(*) from v$bh where OBJD=16543;
COUNT(*)
----------
0
SQL> insert /*+ APPEND */ into emp_data2 select * from emp_data2;
insert /*+ APPEND */ into emp_data2 select * from emp_data2
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> conn vishal/vishal
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!