| Invoking SQLLDR from Concurrent Program [message #155801] |
Wed, 18 January 2006 12:21  |
ahujasanjeev
Messages: 1
Registered: January 2006
|
Junior Member |
|
|
Hi,
I am trying to invoke sqlldr program from concurrent program in oracle applications. What is the simplest way to achieve that?
I am able to execute it from linux by the following command
sqlldr user/pass@database data=.dat control=.ctl
Thanks
|
|
|
|
| Re: Invoking SQLLDR from Concurrent Program [message #156687 is a reply to message #155801] |
Fri, 27 January 2006 01:25  |
voralux
Messages: 72
Registered: January 2006
|
Member |
|
|
you have 4 files
1. filename.ctl
LOAD DATA
INFILE 'text.txt'
APPEND
INTO TABLE TABLENAME
fields terminated by ','
optionally enclosed by '"'
TRAILING NULLCOLS
( field1,
field2)
2. filename.PAR
userid=username/password
control=filename.ctl
log=filename.log
bad=filename.bad
data=filename.txt
3. filename.SH
sqlldr parfile=filename.par
4.filename.txt
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
