Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Inserting rows into worktables using APPEND (bulk load for Oracle)


Level 2



I wonder how we can change generated SQL statements like

INSERT INTO WKFxxxxxxx (col1,col2.....) SELECT ..........


INSERT /*+ append */ INTO WKFxxxxxxx (col1,col2.....) SELECT ..........


which is in fact bulk insert into table (Oracle database) - and it's greatly reduce redo logs size.


Any clues ?



1 Reply


Community Advisor

Hi @Klaster ,

This is nice idea as direct-path insert can perform significantly better than conventional insert.

However, there are some constraints here:

  • Data is written directly into datafiles, bypassing the buffer cache;
  • Free space in the table is not reused;
  • Rreferential integrity constraints are ignored.