Oracle select statement returning huge dataset

[bchk]

Hi,

I have a Oracle select statement that returns 3gb of data and it is slow because of the data transfer speed on the lan lines, is there any compression-on-the-fly sort of techniques I can use to reduce the actual data transferred?

I have already considered using oracle dump/gzip, but we try to avoid running scripts on the database machines.

Thanks for any input on this.

[gandolf989]

What are you trying to do? Are you bringing the data back to the application server to hold in the Java heap? Are you moving the data to another database? If you are moving it to another database you could look at replication. If you are bringing it back to the Java heap, then maybe you could store it as a blob and see if Java has any compression that you can use.