Search Results

The quotes around EOF stop any variable expansion. If you need the variable expanded you will need to remove the quotes and use backslash for any dollar $ characters you need in the passed SQL code....

Can I suggest a couple of things:

Indent all your if,do,while blocks you will find issues like this much easier

make use of <<-"EOF" when using here-documents

This allows you to indent the...

sed 's#_TE#_TH#g' file.sql > tmp; mv tmp file.sql

This: EOF

You cannot indent this, it has to be at the very beginning of the line. Otherwise it will not be considered the end of the here-document.

I would still suggest you move the $sch/$tpwd@$ttns to another line so that it does not appear to anyone else running ps -ef | grep sql

You might need to code it as:-sqlplus -s <<EOF...

pvmanikandan,

What are the values of $from and $to?

Are you trying to create a range of directories?

Also, some adjustments are in order in the variable assignment statement. You should...

$dpdir=DP_FROM_{$from}_TO_{$to}


Should be:

dpdir=DP_FROM_${from}_TO_${to}


I would also add:

to=$(echo $to | tr '[a-z]' '[A-Z]')
from=$(echo $from | tr '[a-z]' '[A-Z]')

Then you...