Home » SQL & PL/SQL » SQL & PL/SQL » How to do bulk Data Extraction in single time
How to do bulk Data Extraction in single time [message #275320] Fri, 19 October 2007 08:03 Go to next message
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 #275322 is a reply to message #275320] Fri, 19 October 2007 08:18 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Quote:

I am trying to execute the script which is going to retrieve the near abt 18 crores of records from old version
Use millions instead of crores, while posting. Anyway for others, crore = 10 millions.

One thing I didn't understand. What are you going to do with the huge file?

By
Vamsi
Re: How to do bulk Data Extraction in single time [message #275345 is a reply to message #275322] Fri, 19 October 2007 10:14 Go to previous message
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.
Previous Topic: How to take control from exception section to the body...
Next Topic: Error while refreshing materialized View through DBMS_MVIEW
Goto Forum:
  


Current Time: Sat Feb 08 08:00:08 CST 2025