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
SQL Loader to load FA data into Oracle
-
- Posts: 130
- Joined: Sun Mar 11, 2007 1:47 am
- Location: India
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..
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..
Hello,
here you have a goog link:
http://orafaq.com/wiki/SQL*Loader#Conditional_Load
Hope it helps,
Jose L.
here you have a goog link:
http://orafaq.com/wiki/SQL*Loader#Conditional_Load
Hope it helps,
Jose L.
Who is online
Users browsing this forum: No registered users and 1 guest