Any suggestions on how to extract 6 million records from an oracle10g ?

Posted by R K on Stack Overflow See other posts from Stack Overflow or by R K
Published on 2010-04-08T05:59:40Z Indexed on 2010/04/13 8:33 UTC
Read the original article Hit count: 631

Filed under:

oracle10g

|

plsql

|

cursor

I just want to give you a little background

Need to write a PL-SQL which will extract 6 million record joining different tables and create a file of that.
Need more suggestions, specifically on how to fetch these many records. As fetching these million of records on a single go can be a highly resource intensive. So question is how to fetch these many records ?

Any pl-sql will be highly appreciated.

© Stack Overflow or respective owner

Related posts about oracle10g

How to set _optimizer_search_limit and _optimizer_max_permutations in Oracle10g.

as seen on Server Fault - Search for 'Server Fault'
I am working on a product that must support both MSSQL and Oracle (10g and 11g). I have some very complex queries that seem to run without issue on MSSQL 2005/2008, but very, very slow with Oracle. The CPU on the oracle server skyrockets for long periods of time, and it seems like the optimizer… >>> More
Any suggestions on how to extract 6 million records from an oracle10g ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I just want to give you a little background Need to write a PL-SQL which will extract 6 million record joining different tables and create a file of that. Need more suggestions, specifically on how to fetch these many records. As fetching these million of records on a single go can be a highly resource… >>> More
How to write a optimized code to fetch 6 million records from Oracle10G database and write them on a

as seen on Stack Overflow - Search for 'Stack Overflow'
What to use in oracle 10G to extract 6 million records and create a flat file of it ? >>> More
how to know the names of other users in oracle10g?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys,i want to know how can we know the other users of oracle 10g on the same system. Is there any querry for that? thank you!!! >>> More
Where is the C precompiler for Oracle10g located?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am looking for a newer version of the Pro*C/C++ to upgrade my procui.exe 9.0.1.1.1. I downloaded the 10g client disk and when install I have the following options: instant client administrator runtime custom I dont seem to able to find the actual program other than just getting some… >>> More

Related posts about plsql

Iterating over files in PLSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Using a PLSQL script, is it possible to iterate over binary files in a folder and insert them as a BLOB in Oracle 10g? Any examples would be appreciated. >>> More
plsql show query

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have a small problem using oracle pl sql. I have a sql file with some cursor, etc, and the treatement fail but with no details. I have an idea about the problem (a function with parameters) but I would like to see the parameter for each call, to be able to debug, to see exactly with wich… >>> More
Get 2 recoeds from PLSQL Cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys... my Question is short, I create a cursor to get some values from my table I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, cause I want to make a calculation over the current record and the next record. in traditional… >>> More
Get two records from PLSQL cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
My question is short. I create a cursor to get some values from my table. I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, because I want to make a calculation over the current record and the next record. In traditional programming… >>> More
PLSQL: How to go about it

as seen on Stack Overflow - Search for 'Stack Overflow'
I searched for this topic on SO but I did not found any recommendations and so am asking it as I am new to PLSQL and want to understand it: What is best way to get started with PLSQL ? What are best online resources or books available out there for understand PLSQL which you would recommend ? Do… >>> More