-
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
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
|