How to open Spool file in Windows?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to open Spool file in Windows?

  1. #1
    Join Date
    Jul 2012
    Posts
    14

    How to open Spool file in Windows?

    Hi All,
    Please observe the following query

    SQL> spool dil.txt
    SQL> select name from v$datafile;

    NAME
    ------------------------------------------------------------------------------

    D:\APP\DNALLURI\DILPROD\SYSTEM01.DBF
    D:\APP\DNALLURI\DILPROD\SYSAUX01.DBF
    D:\APP\DNALLURI\DILPROD\UNDOTBS01.DBF
    D:\APP\DNALLURI\DILPROD\USERS01.DBF

    SQL> spool off;
    SQL> !cat dil.txt
    SP2-0734: unknown command beginning "!cat dil.t..." - rest of line ignored.
    SQL> @dil.txt
    SP2-0734: unknown command beginning "SQL> selec..." - rest of line ignored.
    SP2-0042: unknown command "NAME" - rest of line ignored.
    SP2-0734: unknown command beginning "D:\APP\DNA..." - rest of line ignored.
    SP2-0734: unknown command beginning "D:\APP\DNA..." - rest of line ignored.
    SP2-0734: unknown command beginning "D:\APP\DNA..." - rest of line ignored.
    SP2-0734: unknown command beginning "D:\APP\DNA..." - rest of line ignored.
    SP2-0044: For a list of known commands enter HELP
    and to leave enter EXIT.
    SP2-0734: unknown command beginning "SQL> spool..." - rest of line ignored.
    SQL> ./dil.txt
    SP2-0042: unknown command "./dil.txt" - rest of line ignored.

    Please let me know how can i execute the spool file in Windows?

    Thanks in Advance

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Exit sqlplus and just edit, view, notepad or whatever you want to do to you dil.txt file - this is just a file at O/S level.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Dec 2002
    Posts
    60
    or use TYPE instead of cat in windows.

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