Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

write data from table to file

catastropheDec 3 2009 — edited Dec 8 2009
Hi,
I cross with memory problem. I have table with 750 000 000 record in it. It has one field. I tried to query it on TOAD and then save the result as file.
First i tested for 1000000 record. I got result in 5 minute and I saved result as .dat file.
SELECT * FROM TABLE WHERE rownum < 1000000

But then I tried
SELECT * FROM TABLE

I wanted to get resul on TOAD grid and then save as fiile. But I got out of memory error from TOAD. I think it is wrong way.

TABLE
Field
6081796|20/08/2009 00:00:00|13181
6081796|20/08/2009 00:00:00|13181
6081796|20/08/2009 00:00:00|13181
6081796|20/08/2009 00:00:00|13181


So I want to write data from table to file.
AS
Filename.(dat,txt)
6081796|20/08/2009 00:00:00|13181
6081796|20/08/2009 00:00:00|13181
6081796|20/08/2009 00:00:00|13181
6081796|20/08/2009 00:00:00|13181

How can I do this?
I really need your help.


Thanks in advance,
Ziya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2010
Added on Dec 3 2009
8 comments
1,461 views