04-23-2007
Guys,
Quick question on this, hopefully.
I am going to go down the road that i have mentioned above, i.e. having one control file of format:
@database
--connection details
@procedure
--procedures etc
.
.
.
@database
--connection details
Basically my question is could someone give me some hints on how to parse the file so that i can grab all the stuff between (for example) the two @databases. I want to know what i should be loading against one database, and what against the others, if there is more than one @database, as it may be the case that everything has to be done against one database.
Hope that makes sense.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi Folks,
I have created a number of unix scripts that i can run from the scheduler on a server-side application that we use (Chordiant Marketing Director). All scripts are working except one. This last script is a user load script which first truncates a table and then loads it using a flat... (2 Replies)
Discussion started by: jibbadiah
2 Replies
2. Shell Programming and Scripting
Hi,
Please let me know if anybody is having a solution handy for the below tasks...
It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task.
Task:
Check if the network drive exists
Check... (0 Replies)
Discussion started by: sayydevara
0 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I am trying to load the records in a .txt file into the data base using SQL loader. I gave:
$ sqlldr user/pass@DB control=filename.ctl log =mylog.log
It throwed the following error:
SQL*Loader-297: Invalid syntax or bind variable in SQL string for column STATUS.
ORA-01756: quoted... (2 Replies)
Discussion started by: risshanth
2 Replies
4. Shell Programming and Scripting
hi all
i am new to shell scripting.
i have 35 flat files delimited files that i have to load in to a table.
i was asked to create a shell script that loads the data into the table...
could you please help me if you have a script.
Also .. how to create logs files...does my sql... (3 Replies)
Discussion started by: rajesh_tns
3 Replies
5. Shell Programming and Scripting
Hi Frnds,
I wanto load the data thats in data file with comma(,) delimited.
it throw this errors
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified
Plz look at my file... (3 Replies)
Discussion started by: Gopal_Engg
3 Replies
6. UNIX for Dummies Questions & Answers
HI Experts,
We have a ksh file named ldr_empdelta.ksh and it is having the SQL*LOADER script as follows.
print "LOAD DATA" > $WEDB_GEN/ldrscan.ctl
print "INFILE '"$LED_SCAN"/delta/led_del.dat'" >> $WEDB_GEN/ldrparms.ctl
print "TRUNCATE" >> $WEDB_GEN/ldrscan.ctl
print "PRESERVE BLANKS" >>... (1 Reply)
Discussion started by: ajaykumarkona
1 Replies
7. UNIX for Dummies Questions & Answers
I am new in unix..
I am running a sql loader script where I have to specify the data file path but the file name contains spaces in it
so giving error multiple arguments
I have tried it with "" and '' but does n't work the command is :
$ORACLE_HOME/bin/sqlldr... (1 Reply)
Discussion started by: Sandip Dey
1 Replies
8. Shell Programming and Scripting
All,
Below is the code written when sql loader loads the data:
$ORACLE_EXEC_PATH/sqlldr userid=$user_passwd control=$CNTR_FILES/invoice.ctl log=$LOG_FILES/$INVOICE_FILE.log bad=$ER
ROR_FILES/$INVOICE_FILE.bad data=$DATA_FILES/$INVOICE_FILE silent=FEEDBACK direct=false errors=50000
rc=$?... (1 Reply)
Discussion started by: Oracle_User
1 Replies
9. Homework & Coursework Questions
Hi,
I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script.
The table has two columns - Acct_number (not nullable) and date (timestamp).
I'm not able to write a shell script for that. Can any one help me?
... (3 Replies)
Discussion started by: saisudeep
3 Replies
10. Shell Programming and Scripting
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
LEARN ABOUT ULTRIX
xrmputfiledatabase
XrmMergeDatabases(3X11) MIT X11R4 XrmMergeDatabases(3X11)
Name
XrmMergeDatabases, XrmGetFileDatabase, XrmPutFileDatabase, XrmGetStringDatabase, XrmDestroyDatabase - manipulate resource databases
Syntax
void XrmMergeDatabases(source_db, target_db)
XrmDatabase source_db, *target_db;
XrmDatabase XrmGetFileDatabase(filename)
char *filename;
void XrmPutFileDatabase(database, stored_db)
XrmDatabase database;
char *stored_db;
XrmDatabase XrmGetStringDatabase(data)
char *data;
void XrmDestroyDatabase(database)
XrmDatabase database;
Arguments
data Specifies the database contents using a string.
database Specifies the database that is to be used.
filename Specifies the resource database file name.
source_db Specifies the resource database that is to be merged into the target database.
stored_db Specifies the file name for the stored database.
target_db Specifies a pointer to the resource database into which the source database is to be merged.
Description
The function merges the contents of one database into another. It may overwrite entries in the destination database. This function is
used to combine databases (for example, an application specific database of defaults and a database of user preferences). The merge is
destructive; that is, the source database is destroyed.
The function opens the specified file, creates a new resource database, and loads it with the specifications read in from the specified
file. The specified file must contain lines in the format accepted by If it cannot open the specified file, returns NULL.
The function stores a copy of the specified database in the specified file. The file is an ASCII text file that contains lines in the for-
mat that is accepted by
The function creates a new database and stores the resources specified in the specified null-terminated string. is similar to except that
it reads the information out of a string instead of out of a file. Each line is separated by a new-line character in the format accepted
by
If database is NULL, returns immediately.
See Also
XrmGetResource(3X11), XrmInitialize(3X11), XrmPutResource(3X11), XrmUniqueQuark(3X11)
X Window System: The Complete Reference, Second Edition, Robert W. Scheifler and James Gettys
XrmMergeDatabases(3X11)