[URGENT] Help with a Bteq Script!!!

Tools
Enthusiast

[URGENT] Help with a Bteq Script!!!

Hi Friends,

I have table with some 32,000,000 records and i want them to export that data on to text file.

I dont have fastexport installed on my UNIX machine.So the only option i have is to use BTEQ EXPORT option.I want to know is it possible to accomodate such a huge table on to a txt file using the BTEQ script.If yes,can you just show me a sample script.This is what i have trying so far

.set reclimit 32000000
.set format on
.set width 250
.export report file = datafile.out
sel * from table;
.set format off
.export reset
.logoff

I also tried with the LARGEDATAMODE Option

.set largedatamode on
.set reclimit 32000000
.set format on
.set width 250
.export indicdata file = datafile.out
sel * from table;
.set format off
.export reset
.logoff

Regards,
Saravana