Thursday, September 04, 2008

How load flat file to oracle

I just know how to load flat file into oracle database. Oracle has provided us to use both of External Table and SQL Loader. The main functionality for External table is to store data from flat file to oracle database and the SQL Loader is used for load flat file data into External table. Actually for load flat file into oracle we only need SQL Loader, but using External Table is very usefull for operation purpose

Here is a nice tutorial about external table http://www.orafaq.com/node/848
and also about SQL* Loader