-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|