10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have requirement to pull a bunch of SQL's from a table in DB and execute them in parallel and update the status of each query as and when they complete. Can you please help me with ideas on how this can be achieved?
create table list_of_sql
full_sql... (3 Replies)
Discussion started by: member2014
2. Shell Programming and Scripting
This is my Script which configure a list of nodes. ( 40 nodes, and the configuration 10 minutes)
echo "USE: ./start.sh nodes
nb_lignes=`wc -l $1 | cut -d " " -f1`
echo "$nb_lignes machines"
for i in $(seq $nb_lignes)
My... (2 Replies)
Discussion started by: chercheur111
3. Shell Programming and Scripting
I'm trying to do teh below thing.
I have a single script which uses 3 different parameters to do 3 different work like belwo.
test1.sh par1 -- it shuts down an instance
test1.sh par2 -- it shuts down an instance
test1.sh par3 -- it shuts down an instance
Now I created a script... (7 Replies)
Discussion started by: bhaski2012
4. Shell Programming and Scripting
I am trying to write a shell which will invoke 3 CTAS (ORACLE create table XXX as select * from YYYY). The approximate time for one CTAS is around 25 mins. So i want to run the CTAS script parallely.
My pseudocode is as below.
nohup sh CTAS1.sh &... (3 Replies)
Discussion started by: Showdown
5. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
6. UNIX for Advanced & Expert Users
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
7. Shell Programming and Scripting
There is a shell script that accepts positional parameter between 1-25 to execute case statement of script depending upon the parameter passed.
Now I need to run all the 25 sessions parallely. In each option of case statement it is connecting with sqlplus and executing a select... (11 Replies)
Discussion started by: Opamps123
8. Shell Programming and Scripting
I am a shell script which takes input parameters and performs various functions. My concern is, if we call the same shell script with different parameter values from different sessions, will the results be inconsistent?
Are there any precautions I need to take inorder to avoid conflicts... (1 Reply)
Discussion started by: jamjam10k
9. Shell Programming and Scripting
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
10. Shell Programming and Scripting
If I execute this script:
$ORACLE_HOME/bin/sqlplus -s <<EOF > oracle.log
the sql script executes with no errors.
IF I execute the following script:... (12 Replies)
Discussion started by: mh53j_fe