Insert using /*+ append */ hint not reduced my time

[hrishy]

I would guess that fetch of 30K records from remote DB.. is taking most of ur time.. you can do a simple test for urself and check it..

Wass ur Arraysize? ( it does matter for data over n/w )

@Hrishy,

Append indeed works if even indexes are there.. but only for table.. for indexes its a usual way to have redo recorded.. And again here your suggestion without even thinking?

Rgds
Abhay.

I always drop or disable indexes on the table where i am doing a dataload and rebuild those indexes in parallel and nologging mode.Thats why i said i think so..wasnt really confident :-)

regards
Hrishy