-
Dear DBA's
I am loading data throgh SQL*LOADER in Oracle. I have some problem, While Inserting data into multiple table I have created Control file in followinf way which is giving me error, Second my numeric data in data file has decimal seprator "," for ex. "123,45" not "123.45" which is giving me error. Please help me.
Thanks
Shailesh
UNRECOVERABLE LOAD DATA
INFILE 't2.dat'
INSERT INTO TABLE t2
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( l1 char,l2 char,l4 char,mydate date,l3 char(2000000))
INFILE 't1.dat'
INSERT INTO TABLE t1
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( f1 char,f2 char,f4 char))
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|