We have a below script and based on which we have create a script which starts sqlldr loading.
INFO:
-----
If we run monitor script will call your program(DATACITI_orctl_load.sh): eg: DATACITI_orctl_load.sh $DATFILE
Our program will:
1. Verify that we have not already loaded this file
2. Do the load by finding sqlldr command in DATACITI_*_orctl1n.sh
eg: DATACITI*_orctl1n.sh file contents-
---------------------------------
3. Once successful, prevent this from being loaded again; (may need to comment out entry in DATACITI_*_orctl1n.sh)
---------- Post updated at 05:00 PM ---------- Previous update was at 04:59 PM ----------
Jim u can change the script in point 1. as well
Last edited by pludi; 02-02-2010 at 07:50 AM..
Reason: code tags, please...
Hey, im fairly new to unix and Im trying to make this unix project that would display a menu and do the following.
MENU
===========================
(p, P) Print users info
(a, A) Add new user
(s, S) Search user
(d, D) Delete user
(x,X) Exit
Enter your choice:
Trying to... (3 Replies)
Hi, I am very new to UNIX environment. And I am stuck in this problem.
In my Unix server, I have a file called "tablelist.txt" which gives me a list of the tables in my oracle database like shown below.
bmp.table1
bmp.table2
bmp.table3
:
:
bmp.table20
All these tables have 'batch_id'... (1 Reply)
Hi ,
I have a scenario, i have a directory where i receive around 14-15 files at a interval of 20-40 min not fixed, i want to write a unix scripts which invoke sqlldr command to load files into oracle automatically as soon as the file hit the directory.
Any help will be appreciated.
... (4 Replies)
I'll try to keep this short, but basically I need to figure out a way to load data in shared memory (this file will be called load.c) I will later access the data with a print.c program.
The "data" is in the form of a student database that looks like this
John Blakeman
111223333
560... (7 Replies)
Hi one help,
I need one procedure to load data from flat file to table. Table name as input parameter for the procedure. can anyone help me
Thanks,
Raj, (1 Reply)
Hi All,
I am trying to load a data from a files in a particular directory to a database..
cd $SCC
isql metdb >> ${LOGDATA}/LOAD.LOG < !
load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE
!
But it's showing the error "syntax error at line 46 : `<<' unmatched"
Can u plz help me... (5 Replies)
i am studying a script which is used for data loading.
it has functions which deletes all the existing data before loading and then loads new fresh data.
but i am stuck up at function Replace into table ( col 1,col 2....)
Does this signify All Inserts. (1 Reply)
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)