You can upload the data from the text file into the Oracle Table through SQL Loader Utilityof the Oracle. In the text file you have to define the each column with some delimiter like space or comma etc..

You have to use two more file, One is as Control and Another is as Log file.

You have to define column name of the table in the control file. And log file shows the status of the loading of the data. How much data loaded and how much data not loaded due to some error.


Only through SQL Loader you can migrate the data from one application to oracle.


Naresh Kakrani
DBA - Reliance
[email protected]