OraFAQ Forum: Server Utilities » How to close sql loader?

Home » RDBMS Server » Server Utilities » How to close sql loader?

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

How to close sql loader? [message #259270]

Tue, 14 August 2007 22:27

poy_sian
Messages: 7
Registered: July 2007
Location: Thailand

Junior Member

Plase help me!
How to close this window when insert data already?
I have a batch file and control file to load data into table.
I run batch file to call load control file then system will raise command prompt window and can not close this window.

--load control file--
LOAD
DATA INFILE 'C:\file_list.txt'
APPEND
INTO TABLE TMP_OUI
(file_name char(30))
---------------------

--batch file to call control file--
C:\Ora81\BIN\SQLLDR user_name/password@database c:\load.ctl c:result.log
-----------------------------------

Attachment: error1.jpeg
(Size: 643.92KB, Downloaded 981 times)

Report message to a moderator

Re: How to close sql loader? [message #259273 is a reply to message #259270]

Tue, 14 August 2007 22:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

--batch file to call control file--

C:\Ora81\BIN\SQLLDR user_name/password@database c:\load.ctl c:result.log
exit

Report message to a moderator

Re: How to close sql loader? [message #261518 is a reply to message #259270]

Wed, 22 August 2007 22:42

poy_sian
Messages: 7
Registered: July 2007
Location: Thailand

Junior Member

It still not close window when add command exit follow your suggest. Please tell me other method again.
Thanks.

Report message to a moderator

Re: How to close sql loader? [message #261555 is a reply to message #261518]

Thu, 23 August 2007 00:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This method exits successfully for me. So, could you post another screenshot, please?

BTW, I'd rather worry about

screenshot

partial record found at end of datafile

What do you plan to do about it?

Report message to a moderator

Previous Topic:	How to migrate from Oracle 8i to Oracle 10g with 100GB Data?
Next Topic:	tuning for export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:05:08 CST 2024