Exporting data [message #2580] |
Mon, 29 July 2002 07:02 |
Gerald Wigmore
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
I'm trying to export 400,000 records (only 15 char long) to a text file.
Select count(*) from my_file shows that there are 400,000 records in the source table, but when I select all using TOAD I only get 170,000 (?). This is despite receiving a confirmation that 400,000 records were exported.
I've also tried spooling the data to a text file via SQL+ but get even less data written to the file.
When I finally got 0 records returned I got up & kicked the coffee machine!
What could be going awry? Is there an environment variable I should be setting to ensure that this amount of data is exported?
|
|
|
Re: Exporting data [message #2581 is a reply to message #2580] |
Mon, 29 July 2002 07:53 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
I beleive, you are try to dump the records into text-file.
"Export" is a different terminilogy. using export, you cannot dump into a text file.
since you have a large volume of data, i may actually look into using UTL_FILE package, to read the table, and write the data into a text file.
Spooling would not be that efficient for huge volumes of data.
|
|
|