Thread: Download data to files
11-17-04, 18:58 #1Registered User
- Join Date
- Jun 2004
Unanswered: Download data to files
I have a table that contains about 330 millions of recods .. the problem is that I need ( for a client requierement!) to download those records to a files, each file must contain 10 millions of records .. currently I have a ProC program that do this, declare a cursor, execute a query, open the cursor and write each record to a file ... this procedure is too much slow ! .. The question is .. How can I do this more efficiently? and fastly ! ..
Thanks a lot!
11-17-04, 19:23 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>procedure is too much slow
Without actual facts, any guess is as good as another.
Where is the time being spent?
Where's the bottleneck?
Enable SQL_TRACE to see where Oracle is spending its time.
Why Pro*C when SQL*PLUS can do the job?You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.