Inserting rows into worktables using APPEND (bulk load for Oracle) | Community
Skip to main content
K
Klaster
Level 2
October 13, 2020
Question

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

  • October 13, 2020
  • 1 reply
  • 947 views

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 ?

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Milan_Vucetic
Milan_Vucetic
Level 9
October 15, 2020

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

Terms & ConditionsAccessibility statement

Loading footer...