Thursday, July 26, 2012

Large Exports out of APEX

Having problems creating large export files out of APEX? Try these tips...

The question was APEX 4.0 would only create a 60mb .csv file...

Dan,

A lot of factors here. My best guess would be the webserver, but it depends on how it is hosted.

I know we would hang our CSV generation if we used interactive
reports due to size, but had a lot to do with our DB. It would create a
session that would run for quite a while and then get lost by the web
server.

We ended up doing a process that does a straight dump. My question would be, does the 60MB file correspond with a "time to generate". There may be something else going on.

About Me

I have been involved with the Oracle database since Oracle v4. I am well published and frequently speak at user group events around the world.
My popular courses include SQL Tuning topics and Advanced PL/SQL.
I am now involved with both APEX and OBIEE...
I have a portable computer lab and I also do many of my classes over the web.
My prices are VERY competitive...