| SQLLDR [message #316530] |
Fri, 25 April 2008 10:10  |
chintu00
Messages: 15
Registered: February 2007
Location: Tampa FLorida |
Junior Member |
|
|
I am using SQLLDR
my control file
1 load data infile 'source.dat'
2 into table xx_ips_promotion_coupon_temp
3 fields terminated by "," optionally enclosed by '"'
4 (promo_id, coupon_code)
source.dat
1 18,18745643
2 18,19417947
3 18,19892898
4 18,42063136
5 18,86868654
6 20,69430714
7 21,12498599
8 21,15080689
9 21,19267689
10 21,19935689
11 21,96207089
12 22,17064678
13 22,29188260
14 23,14908136
15 23,19578920
My Log file
2 SQL*Loader: Release 8.0.6.3.0 - Production on Fri Apr 25 11:01:00 2008
3
4 (c) Copyright 1999 Oracle Corporation. All rights reserved.
5
6 SQL*Loader-503: Error appending extension to file ()
7 Additional information: 7217
Can somebody help please?
|
|
|
| Re: SQLLDR [message #316537 is a reply to message #316530 ] |
Fri, 25 April 2008 10:39  |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
If you have 9.2 version why do you use a 8.0 loader?
Regards
Michel
|
|
|
| Re: SQLLDR [message #316624 is a reply to message #316537 ] |
Sat, 26 April 2008 11:22 |
chintu00
Messages: 15
Registered: February 2007
Location: Tampa FLorida |
Junior Member |
|
|
|
There are other SQLLDR programs with same versions/environment
|
|
|
| Re: SQLLDR [message #316636 is a reply to message #316624 ] |
Sat, 26 April 2008 15:55 |
Littlefoot
Messages: 5640
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
Hm? There are? Are you saying that, when you install Oracle version 9.2, you get SQL*Loaders versions (just for example) 9.2, 8.0, 8.1.7 and 10g? Because, I always thought that there's one utility version per database version.
|
|
|
| Re: SQLLDR [message #316637 is a reply to message #316636 ] |
Sat, 26 April 2008 16:12 |
chintu00
Messages: 15
Registered: February 2007
Location: Tampa FLorida |
Junior Member |
|
|
I am working in Oracle Apps environment Oracle_Home requires directory to be in 8i
|
|
|
| Re: SQLLDR [message #316638 is a reply to message #316537 ] |
Sat, 26 April 2008 16:14 |
chintu00
Messages: 15
Registered: February 2007
Location: Tampa FLorida |
Junior Member |
|
|
|
Michel , Is SQLLDR a client side intallation ?
|
|
|
|
| Re: SQLLDR [message #316649 is a reply to message #316530 ] |
Sat, 26 April 2008 22:06 |
TheSingerman
Messages: 16
Registered: April 2008
Location: Brighton, Michigan |
Junior Member |
|
|
|
It's been seven years since I've worked with anything that old (and never on WinDoze), but is is possible that this version of sqlldr is taking source.dat and trying to append .dat to it, and deciding that source.dat.dat is a No-No?
|
|
|
]
Members
Search
Help
Register
Login
Home
