Avatar

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 ?