OraFAQ Forum: Server Utilities » SQL Loader silent on direct path

Home » RDBMS Server » Server Utilities » SQL Loader silent on direct path

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

SQL Loader silent on direct path [message #169231]

Tue, 25 April 2006 18:05

dandormont
Messages: 12
Registered: April 2006

Junior Member

I am running SQL*Loader, and because I am calling it from an external program, specifically a Java program, I need it to send absolutely nothing to standard output (I'm on Windows, Oracle client 9.2.0.1). When I invoke sqlldr like so:

sqlldr somename/somepass testtbl.ctl rows=200 silent=all

then as expected nothing gets printed. But if I add "direct=true", it prints things like "Save data point reached - logical record count 200" even though I have set silent mode. Any way to fix this?

thanks

Report message to a moderator

Re: SQL Loader silent on direct path [message #169233 is a reply to message #169231]

Tue, 25 April 2006 19:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Just a guess...
>sqlldr somename/somepass testtbl.ctl rows=200 silent=all > null

Report message to a moderator

Re: SQL Loader silent on direct path [message #169395 is a reply to message #169233]

Wed, 26 April 2006 11:18

dandormont
Messages: 12
Registered: April 2006

Junior Member

I don't think that will work, because I'm calling sqlldr from Java and shell redirection is not supported there as far as I can tell. I would prefer to just make sqlldr not print those messages.

Report message to a moderator

Re: SQL Loader silent on direct path [message #169399 is a reply to message #169395]

Wed, 26 April 2006 11:26

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

Senior Member
Account Moderator

Do not give rows=200 ( with or without direct load, committing every 200 records will be painful).
Try this. It should work.

sqlldr somename/somepass testtbl.ctl silent=all direct=true

Report message to a moderator

Previous Topic:	import error
Next Topic:	Importing data from dbf file of Foxpro to Oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 09:22:02 CDT 2024