Home Oracle How to store all SQL commands / Output (spooling) in oracle?
How to store all SQL commands / Output (spooling) in oracle? PDF Print E-mail
Written by Siva   
Tuesday, 23 November 2010 00:12

 

Use SPOOL followed by path and filename.

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jun 8 09:12:36 2005

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

 

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

 

SQL> set pagesize 1024

SQL>

SQL> spool c:\sql\capture_all.txt

SQL>

SQL> Spool off

 
 

Advertisement

Featured Links:
HREmail.com
Looking for job? Try HREmail.com
Want to have CMS based Websites?
Try siliconwebcreators.com to CMS based websites.
VM Solutions Inc
For best VM solutions..
Digital Procedure Inc.
Looking for Oracle /SAP /Weblogic Consulting services? visit digitalprocedure.com