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
BedrockMission!

Learn more

View all

Sign in to view all badges

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

Klaster
Level 2
Level 2

Hi,

 

I wonder how we can change generated SQL statements like

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

into

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
Milan_Vucetic
Community Advisor
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.

 

Regards,

Milan