How do I load a flat file with delimited data into a Oracle Table
William Gill Thu May 27, 2010
I have a flat file with | delimited data that I need to do a one time manual load into a new table that is in the Oracle DB. Which sql functions do you recommend I use which will be easiest since I'm not very seasoned
John Gates Thu May 27, 2010
SQL*Loader is the command line utility for loading data into Oracle. You'll need to create an empty table and then a control file, which tells Oracle what format your data is in. There's a good example here: http://68.142.116.70/docs/cd/B28359_01/t…
There are other methods, but this is available to anyone and relatively easy.
Invite Friends
