find $filepath -maxdepth 1 -type f | while read file
do
sqlldr $user/$password@dbname control=$controlfile bad=$badfilepath/${file}_bad log=$logfilepath/${file}_log
wait
mv $filepath/$file $archive
done
If you have any specific naming format for data file this code can be trimmed. archive,logfilepath,badfilepath are directories, The reason I am using them is to avoid "find" feeding log/bad files to sqlldr.
Last edited by 47shailesh; 04-17-2012 at 12:17 PM..
Reason: correction
Hi,
I have Oracle, and I want to execute simple queries in it. Is it possible to do this using a UNIX shell scripts. Are there any commands in Shell scripting where in I can communicate to ORACLE!?
Thanks, (2 Replies)
Hi All
I am new to unix.
I need a shell script to load a datafile in to oracle.
I already have a control file, and data file. all I need is if i execute the shell it must load the data using the ctl file to table.
Control file : PAY0001.ctl
Datafile : mon_grs_det.dat
log file :... (3 Replies)
Like class loader in java, can we make a function loader in shell script, for this can someone throw some light on how internally bash runs a shell script , what happenes in runtime ...
thanks in advance.. (1 Reply)
Hi
I would like to know how to load oracle data to unix flat file using a shell script.
Can we use sqlldr to import data from oracle, if so can anyone help me with it. (2 Replies)
Hi,
Can anyone tell me how to call a oracle package from a Unix shell script? I want to pass some input parameters to package and it will return me the output which I want to use further in my shell script. I want to know the way to capture the output values in my shell script. Please send some... (1 Reply)
Hi,
I have a tab-delimited txt file as below. It is part of the original file.
I want to cut the lines starting with "3" in column1 and paste them before the lines starting with "1" in column 1. So I will get
Anyone knows any simple shell scripts to do that? The original file is... (5 Replies)
Dear Members,
I have a table REQUESTS in Oracle which has an attribute REQUEST_ACTION. The entries in REQUEST_ACTION are like, ME, MD, ND, NE etc.
I would like to create a script which will will call other scripts based on the request action.
Can we directly read from the REQUEST_ACTION... (2 Replies)
I am trying to get the data from oracle table to a variable I have tried the below code
#/usr/bin/sh
echo " I am in correct loop"
SPOOL_FILE=/app/scripts/alt.lst
sqlplus /nolog <<END_SQL
connect bindu/bindu@gis
whenever sqlerror exit failure rollback;... (4 Replies)
Discussion started by: Kiransagar
4 Replies
LEARN ABOUT OPENSOLARIS
lorder
lorder(1) User Commands lorder(1)NAME
lorder - find ordering relation for an object or library archive
SYNOPSIS
lorder filename...
DESCRIPTION
The input is one or more object or library archive filenames (see ar(1)). The standard output is a list of pairs of object file or archive
member names; the first file of the pair refers to external identifiers defined in the second. The output may be processed by tsort(1) to
find an ordering of a library suitable for one-pass access by ld. Note that the link editor ld is capable of multiple passes over an ar-
chive in the portable archive format (see ar.h(3HEAD)) and does not require that lorder be used when building an archive. The usage of
the lorder command may, however, allow for a more efficient access of the archive during the link edit process.
The following example builds a new library from existing .o files.
ar -cr library `lorder *.o | tsort`
FILES
TMPDIR/*symref temporary files
TMPDIR/*symdef temporary files
TMPDIR usually /var/tmp but can be redefined by setting the environment variable TMPDIR (see tempnam() in tmpnam(3C))
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWbtool |
+-----------------------------+-----------------------------+
SEE ALSO ar(1), ld(1), tsort(1), tmpnam(3C), ar.h(3HEAD), attributes(5)NOTES
lorder will accept as input any object or archive file, regardless of its suffix, provided there is more than one input file. If there is
but a single input file, its suffix must be .o.
The length of the filename for TMPDIR is limited to whatever sed allows.
SunOS 5.11 29 Oct 1991 lorder(1)