Export File Size 2G limit

We are looking into the possibility of exporting upwards of 40G of data from one of our databases. The biggest table is 30G, therefore we can't export by table due to the unix 2G file size limitation. I was thinking about the possibility, however of exporting to a named pipe, starting a dd on that named pipe that is piped to a compress that in turn is piped to a C program to monitor the size of the input and spit out the data to multiple files when the limit of 2G is reached. If anyone has experience with this, I would appreciate some feedback. Ideally I would like to get at some existing C code to do this for us if possible. Received on Wed Nov 13 1996 - 00:00:00 CET