| shantanu |
Posted: Mar 05, 2008 04:55:18 PM |
Total Post: 42
Joined: May, 2007
|
Hello Guys
I am trying to execute a couple of sql scripts located in /appl/acpt/...unix file system and trying to use spool to capture result of script in a file at /tmp/result.txt location. I used following syntax :
SQL> spool /tmp/result.txt
SQL> @/whole path of the script ending with .sql
Received an error saying file cannot be opened cannot be spooled something like that. What are possible causes? I executed script being in the script location.
|
|
|
 ramesh |
| Posted: Mar 05, 2008 11:05:16 PM |  |
|
Total Post: 40
Joined: Aug, 2007
|
Hi,
Go to the location path and give spool filename.lst or spool filename defaulty it takes filename with .lst and execute the script
after completion of script say spool off. at OS level it looks the file name with .lst check it.
|
|
|
|
|
| hjkj |
| Posted: Mar 06, 2008 08:18:49 AM | |
|
Total Post: 3
Joined: Mar, 2008
|
Hi
go to script location
connect to database from that location
and give spool filename(default it will be .lst)
and execute script
and go back and open the file
ex:
cd /home
sqlplus "/as sysdba"
spool file.lst
execute script
spool off
go back to home
open the file.pst
hope u understand well.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
