| Re: Return code from sqlldr [message #97589] |
Thu, 29 August 2002 06:47 |
narender
Messages: 4
Registered: August 2002
|
Junior Member |
|
|
Hi Vivek,
This is Narender. I have a question about sqlldr running from korn shell program. The shell looks like this
------------------filename.sh--------------
sqlldr parfile=filename.par
echo $?
-------------------------------------------
The filename.par will have all the information about the sqlldr file (control file, bad file, discard file, log file, username/ password of database) as shown
----------filename.par----------
DATA=filename.dat
USERID=ru/rv@A2CX
CONTROL=filename.ctl
LOG=filename.log
BAD=filename.bad
DISCARD=file.dsc
-----------------------
When i try to run the filename.sh from unix,
(1) If the password/username is change for the oracle db. It is prompting to enter username/password. I would like to avoid this. I want to see only the error message such as "ORA-01017: invalid username/password; logon denied". I dont want to see the prompt.
(1) I am getting the:
SQL*Loader: Release 8.1.6.0.0 - Production on Thu Aug 29 10:36:34 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Commit point reached - logical record count 8
How can i avoid this message from the screen. All i want is the success/ failed message.
(3) How can i catch the oracle error massages from the shell scripts.
Please help
Thanks
Narender
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
