Hi,

I would like to know a fast method to insert a large number of rows from a text file to an Oracle table. The text file is on the client machine whereas the table is on the server.

Hi,
I think python/php can give a quick method of capturing all the text records into a multidimmention list, then read the records and insert them into the oracle database.
you need to be sure that the records in the text file match your table columns. you can split the text file records at spaces.
hope this helps you. :)

Thanx muteesa.

But I know nothing about python or php.

I know a bit of PL/SQL. Would like to know if a procedure / package written in PL/SQL can speed up the insertion.

Is the text file's content comma separated or space separated?
You can import a formated text file to oracle db using import utility.

Or you can use MS Access to create a link table in your oracle db and then import the text file to this link table from MS Access.