Home » SQL & PL/SQL » Client Tools » SPOOL
SPOOL [message #405331] Wed, 27 May 2009 06:58 Go to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
what exactly is the use of spool?
how to create one?
Re: SPOOL [message #405347 is a reply to message #405331] Wed, 27 May 2009 07:19 Go to previous messageGo to next message
Michel Cadot
Messages: 58933
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this a performances question?
A good link to start with:
http://otn.oracle.com/pls/db102/db102.federated_search

Regards
Michel
Re: SPOOL [message #411468 is a reply to message #405331] Sat, 04 July 2009 02:27 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


spool is something like capturing . for example


before running any sql statement or scripts you can spool it like


SQL> spool balaji.log
SQL>
SQL> delete from tablename where columnname='raja'
1 row deleted

SQL> delete from tablename where columnname='sita'

1 row delete

spool off


if you are running any long scripts (delete,insert,update) you can perform spool and and then run the scripts which will be useful for identifying any errors if occured.


To view your log check it in your oracle home directory.






Re: SPOOL [message #416199 is a reply to message #405331] Fri, 31 July 2009 02:34 Go to previous messageGo to next message
easymatica
Messages: 5
Registered: July 2009
Junior Member
anwar786 wrote on Wed, 27 May 2009 14:58
what exactly is the use of spool?
how to create one?


the purpose of spool is to redirect the output e.g. fo a file, so when you make "select * from...", the result is printed into a file
Re: SPOOL [message #416207 is a reply to message #416199] Fri, 31 July 2009 03:13 Go to previous message
Michel Cadot
Messages: 58933
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the purpose of spool is to redirect the output

"redirect" is not the word, it is more "duplicate".

Regards
Michel
Previous Topic: connection Failure ORA-12154: TNS:could not resolve service name ?
Next Topic: SQLDeveloper/TOAD
Goto Forum:
  


Current Time: Thu Aug 28 22:31:11 CDT 2014

Total time taken to generate the page: 0.06998 seconds