[Ramesh A]

http://saricasigorta.com/59869.php

[kumar jaybee]

http://www.chania-fms.gr/site/wp-content/plugins/akismet/yahoo.html?ce=xb.jdg&wrg=gyh.mhsg&eec=uvee">http://www.chania-fms.gr/site/wp-content/plugins/akismet/yahoo.html?ce=xb.jdg&wrg=gyh.mhsg&eec=uvee

[Ramesh A]

http://elise-guinaudeau.fr/973885.php

[gurunath g]

Hi,

 

We have a requirement to retrieve journal data for all sources which is about 2 to 3 millions records.Right now, I have a rdf report, from where i'm writing data to csv file in some temp folder in applications. It errors out for large volume of data  with Out of process memory error. Oracle has suggested to increase the PGA size for huge transactions. which we can not increase since its already 6GB.

 

if you have any idea instead of writing to csv file from temp table. please suggest and how do you open a file with 400MB in apps.

 

Thanks.

[S dhanemkula]

Hi Gurunath,

I am not sure if this your audit need, as I did vent thro these audits.
Please check with your file recipient, if they are ok to have the data broken financial period
(Year or Quarter  or Period). Even if this is large, check with them to see if you can break the data based on the source and category.

Break your query to extract data in small chunks, by passing appropriate parameters.

Thanks,
Sunil

--
You received this message because you are subscribed to the Google Groups "OracleERP" group.
To post to this group, send email to orac...@googlegroups.com.
To unsubscribe from this group, send email to oracleerp+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/oracleerp?hl=en.

[gurunath g]

Hi Sunil,

I spoke to them about breaking data into different files, which they dont want and i'm providing period as one of the parameter.but still we have large volume of data. users use this very rare, if they have any issues.

 

Thanks,

Guru.

[S dhanemkula]

Hi Guru,

If that is not acceptable solution, please try extracting the data with tab spaces and name the file with an extenstion of .dat (which is nothing but,you are exporting to a txt file).
Use pl/sql routine to do this.

Once the extract is completed, please .zip it and send it over.

Regards,
Sunil

[gurunath g]

Okay Sunil. Thanks.