OraFAQ Forum: Server Utilities » SQL*Loader

Home » RDBMS Server » Server Utilities » SQL*Loader - Closing Control File

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

SQL*Loader - Closing Control File [message #72626]

Thu, 07 August 2003 09:19

Phil Paxman
Messages: 4
Registered: August 2002

Junior Member

I have created a Windows 2000 bat file to load data using SQL*Loader. The problems is that the Control file will not close after the load so that additional processing of the bat file does not take place. Hoe can I close the control file. My scripts look like this:

Batch :

C:
cd OrantBIN
start/separate/wait sqlldr80.exe employee/employee@octd control= C:EmpLoadSap.ctl, log=C:EmpLoadSap.log

C:orantBINPLUS80W.EXE employee/employee@octd @C:insert_emp_SAP.sql

The problem is that @C:insert_emp_SAP.sql
never executes as the control file appears to be hung. I can't place an exit statement in the control file. Any help is appreciated .

Phil Paxman

Report message to a moderator

Re: SQL*Loader - Closing Control File [message #72627 is a reply to message #72626]

Thu, 07 August 2003 11:19

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

Senior Member
Account Moderator

there is nothng like  'closing' the controlfile.
first check the sql*loader is working properly by executing 
-- by the way, what is version of oralce u are using?
-- depending on that, your executable may vary
-- if it is atleast oracle 8i, try sqlldr and sqlplus instead of sqlldr80.exe  and plus80w.exe

sqlldr employee/employee@octd control= C:EmpLoadSap.ctl, log=C:EmpLoadSap.log 

-- if none of these of these are helping, please post the control file and the sqlloader logfile

Report message to a moderator

Previous Topic:	Data Migration
Next Topic:	Calling TNSPing through Visual Basic

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 18:52:10 CST 2024