automatic .lst with SPOOL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: automatic .lst with SPOOL

  1. #1
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334

    Angry automatic .lst with SPOOL

    Ugh!
    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!
    Jodie

  2. #2
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    Actually... this only happens when it's spooling to a variable.

    For example.
    Code:
    $> export TMP=jodie.txt    
    $> sqlplus "/as sysdba"
    SQL> spool $TMP
    SQL> select count(*) from dba_tables;
    
      COUNT(*)
    ----------
           535
    
    SQL> spool off
    SQL> exit
    $> ls
    jodie.txt.lst
    It did NOT behave this way in 8i. Again.. Ugh!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width