OraFAQ Forum: Client Tools

Home » SQL & PL/SQL » Client Tools » spool (Oracle 9i)

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

spool [message #459826]

Tue, 08 June 2010 07:49

ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad

Senior Member

Hi Experts,
I have a table with 1860348 records,
I generated a text file using spool
but only 1000345 records were loaded and remaing records are missed.
Please help me on this issue.
It is very urgent to me
Please help me..........

Report message to a moderator

Re: spool [message #459828 is a reply to message #459826]

Tue, 08 June 2010 07:51

ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad

Senior Member

I have used the following set commands, and i genarated pipe delimited data.

set serveroutput on
set newpage 0
set space 0
set pagesize 0
set echo off
set feedback off
set wrap off
set recsep off
set heading off
set termout off
set time off
set timing off
set linesize 1900

Report message to a moderator

Re: spool [message #459829 is a reply to message #459826]

Tue, 08 June 2010 07:51

Michel Cadot
Messages: 66945
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

In your version spool file is limited to 2GB.
Use "set trimspool on", it may help.

Regards
Michel

Report message to a moderator

Previous Topic:	Migration from postgresql to oracle
Next Topic:	Installation of Toad 10.1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 10 12:58:01 CDT 2020