OraFAQ Forum: Client Tools

Home » SQL & PL/SQL » Client Tools » SPOOL

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

SPOOL [message #405331]

Wed, 27 May 2009 06:58

anwar786
Messages: 25
Registered: May 2009
Location: bangalore

Junior Member

what exactly is the use of spool?
how to create one?

Report message to a moderator

Re: SPOOL [message #405347 is a reply to message #405331]

Wed, 27 May 2009 07:19

Michel Cadot
Messages: 54206
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

Report message to a moderator

Re: SPOOL [message #411468 is a reply to message #405331]

Sat, 04 July 2009 02:27

Mohan10g
Messages: 119
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.

Report message to a moderator