Search notes:

Oracle: INSERT statement with APPEND hint

create table tq84_ora_12838 (
  col_1 number,
  col_2 varchar2(30)
);


insert /*+ append */ into tq84_ora_12838 select rownum, object_name from all_objects where rownum < 10;

--
-- commit the transaction and the ORA-12838 disappears.
-- 
-- commit;
--

-- Without commit: ORA-12838
select * from tq84_ora_12838;

drop table tq84_ora_12838 purge;
Github repository Oracle-Patterns, path: /SQL/insert/append_hint_ora_12838.sql

See also

The append hint.
insert statements
ORA-12838: cannot read/modify an object after modifying it in parallel
Inserting into an (empty?) table using the append hint causes the statement to perform an online statistics gathering.

Index