I have a flat file. How do i upload the text file to my database. Basically i have a webserver running servlet and an oracle database server. Average a falt file can contain at least 2,000 lines.
1. Should i invoke the LOAD DATA command
2. Should i read one by one record.

Thank you