Home » SQL & PL/SQL » SQL & PL/SQL » Exporting data
Exporting data [message #2580] Mon, 29 July 2002 07:02 Go to next message
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 Go to previous message
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.
Previous Topic: Pl. help
Next Topic: Query for a Forum
Goto Forum:
  


Current Time: Fri Mar 29 04:25:55 CDT 2024