Home » RDBMS Server » Server Utilities » Shell in UNIX for validate SQL LOAD in 9i
Shell in UNIX for validate SQL LOAD in 9i [message #74104] Wed, 08 September 2004 07:52 Go to next message
Luis Hernández
Messages: 1
Registered: September 2004
Junior Member
how I can, by means of a shell in UNIX, to know if the bulk loader were ok?.  And otherwise, it is possible determinate in what registry of the flat file "crush" for to continue injecting?
Re: Shell in UNIX for validate SQL LOAD in 9i [message #74105 is a reply to message #74104] Thu, 09 September 2004 12:19 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Usually you just grep the log file. You can also check the return code from sqlldr.

#!/usr/bin/ksh
sqlldr ...
RETVAL=$?
#                                +-------+-------+------------+ 
#                                | UNIX  &#124Windows| VMS        | 
#   +----------------------------+-------+-------+------------+ 
#   | Successful                 |   0   |   0   | 1          | 
#   | Unrecoverable failure      |   1   |   3   | %X10000002 | 
#   | At least one row rejected  |   2   |   2   | 2          | 
#   | O/S Errors                 |   3   |   4   | 3          | 
#   +----------------------------+-------+-------+------------+ 
if [ $RETVAL -eq 2 ]; then
  exit 0;
else
  exit $RETVAL;
fi
Previous Topic: Import partitioned tables whith oracle 9.2.04
Next Topic: How I export/import Procedure,Function,DBtriggers etc at User level or object le
Goto Forum:
  


Current Time: Wed Jul 03 01:58:29 CDT 2024