Home » RDBMS Server » Server Utilities » SQLLDR (Oracle 9.2 , Unix)
SQLLDR [message #316530] Fri, 25 April 2008 10:10 Go to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
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?

Report message to a moderator

Re: SQLLDR [message #316537 is a reply to message #316530] Fri, 25 April 2008 10:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have 9.2 version why do you use a 8.0 loader?

Regards
Michel

Report message to a moderator

Re: SQLLDR [message #316624 is a reply to message #316537] Sat, 26 April 2008 11:22 Go to previous messageGo to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member
There are other SQLLDR programs with same versions/environment

Report message to a moderator

Re: SQLLDR [message #316636 is a reply to message #316624] Sat, 26 April 2008 15:55 Go to previous messageGo to next message
Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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.

Report message to a moderator

Re: SQLLDR [message #316637 is a reply to message #316636] Sat, 26 April 2008 16:12 Go to previous messageGo to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member

I am working in Oracle Apps environment Oracle_Home requires directory to be in 8i

Report message to a moderator

Re: SQLLDR [message #316638 is a reply to message #316537] Sat, 26 April 2008 16:14 Go to previous messageGo to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member
Michel , Is SQLLDR a client side intallation ?

Report message to a moderator

Re: SQLLDR [message #316647 is a reply to message #316638] Sat, 26 April 2008 19:04 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It can be if you install the Oracle client.

Report message to a moderator

Re: SQLLDR [message #316649 is a reply to message #316530] Sat, 26 April 2008 22:06 Go to previous message
TheSingerman
Messages: 49
Registered: April 2008
Location: Brighton, Michigan
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?

Report message to a moderator

Previous Topic: EXP-00008: ORACLE error 904 encountered, Error while expoerting
Next Topic: Stuck on SQL*LOADER problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 06:27:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.