Originally Posted by mallma
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 )
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?
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"