Page 1 of 1
SQL Loader to load FA data into Oracle
Posted: Thu Aug 16, 2007 3:56 am
by prema
Hi everybody
has anybody used SQL Loader to load data into Oracle
if yes, can you please send me a stepwise procedure of how to do it
thanks
prema
Posted: Thu Aug 16, 2007 7:29 am
by siva sankar
Hi Prema,
When we uploading the data from flat file to Oracle tables.
we can use the SQL*LODER to upload the date from flat file to oracle.
1)First we Receive the flat file from the client(Formats like .txt,.dat,.csv)
2)We prepare the Control File.
Syntax:
LOAD DATA
INFILE "data file path"
INSERT INTO table_name
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED By " "
START---> RUN---> cmd
SQLLDR=Control file path
IF any error occur in this..
If you are facing any problem regarding this please let me know..
Posted: Fri Aug 17, 2007 7:18 am
by jscrunch
Hello,
here you have a goog link:
http://orafaq.com/wiki/SQL*Loader#Conditional_Load
Hope it helps,
Jose L.