Search notes:

Oracle: Conventional Path vs Direct Path Load

Data is added (inserted) to a table in one of two technically different ways:

Operation	Comment	Plan operation
Conventional insert	Oracle tries to (re-)use free space. Referential integrity is maintained	`LOAD TABLE CONVENTIONAL`
Direct-path insert	Data is inserted beyond the table's high water mark. The buffer cache is bypassed. Generation of redo and undo data can mostly be turned off, which helps improve performance.	`LOAD TABLE AS SELECT`

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...', 1788377804, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/DML/insert/paths/index(49): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Oracle: Conventional Path vs Direct Path Load

See also