04-17-2012
File transfers are not instantaneous and data loads are not instantaneous.
This sort of process needs very careful design to avoid loading the same file twice or loading a part-transferred file. Common designs involves transferring files under a temporary name, then renaming them after successful transfer. Similarly loading files, then renaming them after a successful data load. Another design involves using a "interlock" files to mark the common directory as "busy" until the transfers complete and "busy" during the data load.
Do you have such precautions in place?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: mohanprabu
2 Replies
2. UNIX for Advanced & Expert Users
Hi,
Can some one help me in connecting to oracle through unix shell scripts with examples.
Regards
Narayana Gupta (1 Reply)
Discussion started by: guptan
1 Replies
3. Shell Programming and Scripting
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)
Discussion started by: raghuraja_r
3 Replies
4. Shell Programming and Scripting
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)
Discussion started by: mpsc_sela
1 Replies
5. Shell Programming and Scripting
shell script (4 Replies)
Discussion started by: frns5
4 Replies
6. Shell Programming and Scripting
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)
Discussion started by: raghav288
2 Replies
7. Shell Programming and Scripting
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)
Discussion started by: anil029
1 Replies
8. Shell Programming and Scripting
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)
Discussion started by: cliffyiu
5 Replies
9. Shell Programming and Scripting
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)
Discussion started by: Yoodit
2 Replies
10. Shell Programming and Scripting
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 XFREE86
modules-load.d
MODULES-LOAD.D(5) modules-load.d MODULES-LOAD.D(5)
NAME
modules-load.d - Configure kernel modules to load at boot
SYNOPSIS
/etc/modules-load.d/*.conf
/run/modules-load.d/*.conf
/usr/lib/modules-load.d/*.conf
DESCRIPTION
systemd-modules-load.service(8) reads files from the above directories which contain kernel modules to load during boot in a static list.
Each configuration file is named in the style of /etc/modules-load.d/program.conf. Note that it is usually a better idea to rely on the
automatic module loading by PCI IDs, USB IDs, DMI IDs or similar triggers encoded in the kernel modules themselves instead of static
configuration like this. In fact, most modern kernel modules are prepared for automatic loading already.
CONFIGURATION FORMAT
The configuration files should simply contain a list of kernel module names to load, separated by newlines. Empty lines and lines whose
first non-whitespace character is # or ; are ignored.
CONFIGURATION DIRECTORIES AND PRECEDENCE
Configuration files are read from directories in /etc/, /run/, and /lib/, in order of precedence. Each configuration file in these
configuration directories shall be named in the style of filename.conf. Files in /etc/ override files with the same name in /run/ and
/lib/. Files in /run/ override files with the same name in /lib/.
Packages should install their configuration files in /lib/. Files in /etc/ are reserved for the local administrator, who may use this logic
to override the configuration files installed by vendor packages. All configuration files are sorted by their filename in lexicographic
order, regardless of which of the directories they reside in. If multiple files specify the same option, the entry in the file with the
lexicographically latest name will take precedence. It is recommended to prefix all filenames with a two-digit number and a dash, to
simplify the ordering of the files.
If the administrator wants to disable a configuration file supplied by the vendor, the recommended way is to place a symlink to /dev/null
in the configuration directory in /etc/, with the same filename as the vendor configuration file. If the vendor configuration file is
included in the initrd image, the image has to be regenerated.
EXAMPLE
Example 1. /etc/modules-load.d/virtio-net.conf example:
# Load virtio-net.ko at boot
virtio-net
SEE ALSO
systemd(1), systemd-modules-load.service(8), systemd-delta(1), modprobe(8)
systemd 237 MODULES-LOAD.D(5)