I need to page extremely large result sets through to a java client. if my select statement returns say millions of rows, how can i get teh first set back to the gui without blowing up the client with out of memory errors...
TOAD seems to do this by pagin the results on the server - maybe using snapshots? can i access the snapshot directly (in 9.2) or is there some other magic i should explore?
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…