Search notes:

Oracle SQL Plan operation: LOAD TABLE CONVENTIONAL

The LOAD TABLE CONVENTIONAL plan operation indicates that data is inserted into a table using the conventional path (as opposed to the direct path). 
create table tq84_t (
   id  number,
   val varchar2(20)
);


explain plan for
   insert into tq84_t values(42, 'forty-two');

select * from table(dbms_xplan.display(format => 'basic'));
--
-- -------------------------------------------
-- | Id  | Operation                | Name   |
-- -------------------------------------------
-- |   0 | INSERT STATEMENT         |        |
-- |   1 |  LOAD TABLE CONVENTIONAL | TQ84_T |
-- -------------------------------------------


drop table   tq84_t;

See also

LOAD AS SELECT
plan operations

Index