Home » RDBMS Server » Server Utilities » How to close sql loader?
How to close sql loader? [message #259270] Tue, 14 August 2007 22:27 Go to next message
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 126 times)
Re: How to close sql loader? [message #259273 is a reply to message #259270] Tue, 14 August 2007 22:32 Go to previous messageGo to next message
BlackSwan
Messages: 25049
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
Re: How to close sql loader? [message #261518 is a reply to message #259270] Wed, 22 August 2007 22:42 Go to previous messageGo to next message
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.
Re: How to close sql loader? [message #261555 is a reply to message #261518] Thu, 23 August 2007 00:58 Go to previous message
Littlefoot
Messages: 20901
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?
Previous Topic: How to migrate from Oracle 8i to Oracle 10g with 100GB Data?
Next Topic: tuning for export
Goto Forum:
  


Current Time: Fri Dec 09 10:06:24 CST 2016

Total time taken to generate the page: 0.09320 seconds