How to do bulk Data Extraction in single time [message #275320] |
Fri, 19 October 2007 08:03  |
sarnan
Messages: 1 Registered: October 2007 Location: India
|
Junior Member |
|
|
Hi,
I am trying to execute the script which is going to retrieve the near abt 18 crores of records from old version. Here I am using spool command to store the records.
But after 65000 records are retrieved spool document can't store remaining because of over limit of file size.
Do I need to use collections like after 65000 records are retrieved,Program needs to exit?
or
Can we make it to write data into another file after 65000 records are retrieved?.
Can we do this? pls give me advise.
Thanks in advance
|
|
|
|
Re: How to do bulk Data Extraction in single time [message #275345 is a reply to message #275322] |
Fri, 19 October 2007 10:14  |
ora_balan
Messages: 21 Registered: January 2007 Location: Mumbai, India
|
Junior Member |
|
|
If this is part of any migration activity, then I would highly recommend an Export from your old database rather than spooling.
If you still want the output of all data in a file (180 million records), try using bulk fetch in PL/SQL and it's UTL File operation built-ins.
I've seen bulk fetches in PL/SQL work much better for such a volume of data.
|
|
|