oracle scripting issue
Hello,
The script runs fine as below:
#!/bin/ksh
for i in `cat cataloglist1.dat`
do
set echo on
sqlplus RCAT_CMORET/rcat @rman_catalog.sql
done
However,when I use $i in sqlplus $i/pwd then it hangs
#!/bin/ksh
for i in `cat cataloglist1.dat`
do
set echo on
sqlplus $i/rcat @rman_catalog.sql
done
Please assist.I need to execute rman_catalog.sql in 124 user schemas which are listed in a file.How should I use the script?
Best regards,
Vishal