Home » SQL & PL/SQL » Client Tools » spool (Oracle 9i)
spool [message #459826] Tue, 08 June 2010 07:49 Go to next message
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..........
Re: spool [message #459828 is a reply to message #459826] Tue, 08 June 2010 07:51 Go to previous messageGo to next message
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
Re: spool [message #459829 is a reply to message #459826] Tue, 08 June 2010 07:51 Go to previous message
Michel Cadot
Messages: 66636
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
Previous Topic: Migration from postgresql to oracle
Next Topic: Installation of Toad 10.1
Goto Forum:
  


Current Time: Mon Oct 14 22:32:47 CDT 2019