OraFAQ Forum: Server Utilities » SQLLDR: path of the file!

Home » RDBMS Server » Server Utilities » SQLLDR: path of the file!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLLDR: path of the file! [message #73671]

Thu, 17 June 2004 02:53

Milly
Messages: 72
Registered: March 2004

Member

HI!

I've to launch the sqlldr and the command that I use (in the shell from vb6 application) is this:

cmd /C CD C:oracleora81bin & sqlldr system@BC_ONLINE/manager control=D:ApplicativiFabbricaSourceBackOfficeSysInt_MAINCommon V 2.0FileFormatBANCH_MANAGANAGR.dat log=D:ApplicativiFabbricaSourceBackOfficeSysInt_MAINCommon V 2.0LogBANCH_MANAGANAGR.log

My problem are:

1) in the path there's a blank, could it generate error?

2) is there a max length of the path?

3) in my machine there are 2 oracle client, the 8 and the 9, even if I set the path equal the 8 version, the sqlldr launched is the utility of the 9 version....

how can I do?

thanks!!!

3)

�

Report message to a moderator

Re: SQLLDR: path of the file! [message #73673 is a reply to message #73671]

Thu, 17 June 2004 03:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. User a parfile
sqlldr userid=dash/dash parfile=mypar.par
where mypar.par should contain all the other entries.

2. use parfile.
3. set PATH, ORACLE_HOME in the ENV and try again
instead of
>>CD C:oracleora81bin & sqlldr
give full path
c:oracleora81binsqlldr control=...

Report message to a moderator

Re: SQLLDR: path of the file! [message #73675 is a reply to message #73673]

Thu, 17 June 2004 05:03

Milly
Messages: 72
Registered: March 2004

Member

ok, but where I habve to put the parameter file? otherwise the problem will be raised again...

the path, oracle_home...where I have to set? in the par file?

thanks

Report message to a moderator

Re: SQLLDR: path of the file! [message #73676 is a reply to message #73673]

Thu, 17 June 2004 05:25

Milly
Messages: 72
Registered: March 2004

Member

I used the parfile, but I have the same problem...
sqlldr treat the blank as if there were multiple file ....
any other idea?

Report message to a moderator

Re: SQLLDR: path of the file! [message #73677 is a reply to message #73676]

Thu, 17 June 2004 06:02

Mahesh Rajendran\
Messages: 1
Registered: June 2004

Junior Member

C:>sqlldr userid=mag/mag@mutation parfile=myparfile.par

SQL*Loader: Release 8.1.6.0.0 - Production on Thu Jun 17 10:01:39 2004

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 3

C:>cat myparfile.par
control="c:folder with spacemember.ctl"

--
-- works even without a parfile!
-- enclose the path with single quotes

C:>sqlldr userid=mag/mag@mutation control='c:folder with spacemember.ctl'

SQL*Loader: Release 8.1.6.0.0 - Production on Thu Jun 17 10:03:39 2004

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 3

Report message to a moderator

Re: SQLLDR: path of the file! [message #73678 is a reply to message #73677]

Thu, 17 June 2004 06:07

Milly
Messages: 72
Registered: March 2004

Member

Yes...I'm sorry I was wrong...
But I've always the problem to set the oracle_home environment....I'm using the sqlldr utility in a vb6 application...is it possible to set the environment from the shell?

thanks!

Report message to a moderator

Re: SQLLDR: path of the file! [message #73679 is a reply to message #73678]

Thu, 17 June 2004 06:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i have no idea about VB.
did you try calling sqllldr.exe directly instead of changing the directory (CD to c:oracle)?
like

c:oracle......sqlldr.exe control=mycontrol.ctl ..

[Updated on: Wed, 28 July 2010 14:52]

Report message to a moderator

Re: SQLLDR: path of the file! [message #73682 is a reply to message #73679]

Thu, 17 June 2004 08:00

Milly
Messages: 72
Registered: March 2004

Member

It WORKS!!!!!
thanks....I eliminated the "CD" in the shell launching and it works!!!

THANKS!!!!

Report message to a moderator

Previous Topic:	How to know if a user exist?
Next Topic:	Problem with import full fromuser touser

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 10:37:50 CDT 2024