Originally posted by ly
agasimani: Yes, agree with you. I think SQL Loader should be the most efficient way for loading the data. However I need to manipulate the records when importing, like add some more columns for each record. Can SQL Loader do this? Thanks!

Any more advice??? And how can I check if my oracle server is efficient or not? What are the important parameter for it? Thanks very much!
Use SQLLDR Utility & load data in Some TEMP Table.

Use ur logic implemented in java & write PL/SQL to manipulate data & put it into ur working permanent table.

It wud require 5 Mins(approx) to load data of 12000 records from Text file & Pl/SQL wud at the most take 10 mins to implement wat so ever ur logic to manipulate data....