SPOOLing from SQPLUS within UNIX script 1

[MCubitt]

I am writing a script on AIX to SQLPLUS with /nolog and to run a script.

Within AIX I specifiy the location and file of the script by /unix/format/path.

How do I SPOOL (within the SQL script) to /the/same/place ? /this/is/an/illegal/filename


SP2-0333: Illegal spool file name: "/home/oracle/IFSTtoIFSD/IFSD.log
# Start log file" (bad character: ' ')
SP2-0306: Invalid option.


Unix script:
set ORACLE_SID=IFSD; export ORACLE_SID
sqlplus /nolog @/home/oracle/IFSTtoIFSD/shutdownIFSD.sql


The SQL script is:
spool /home/oracle/IFSTtoIFSD/IFSD.log
connect internal
select * from v$database;
spool off;
exit

 

[sybaseguru]

What do you need all that. On UNIX just try

sqlplus /nolog @/home/oracle/IFSTtoIFSD/shutdownIFSD.sql
 > output.log

Gives you the flexibility to write a proper shell file as well

 

[MCubitt]

That did it. . thanks!