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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759471094, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/DML/insert/append-hint/index(64): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78