automatic .lst with SPOOL
Did I miss something?
I just tried to run a script (originally created for 8i) on a 9i database and found out that when you say "SPOOL tmp.txt" it actually writes to tmp.txt.lst! Ugh! Is this a NEW feature??? If so, how do I turn it off?
Otherwise, I have to rewrite some of my scripts that are looking for .txt files!
Thanks for any help!
Actually... this only happens when it's spooling to a variable.
It did NOT behave this way in 8i. Again.. Ugh!
$> export TMP=jodie.txt
$> sqlplus "/as sysdba"
SQL> spool $TMP
SQL> select count(*) from dba_tables;
SQL> spool off
Click Here to Expand Forum to Full Width