Export large Oracle data as text files

To export some data from Oracle to a text file (flatfile), due to the large data table, the export fails when toad is used. In fact, the memory overflow occurs. It seems that Oracle's own life is still used

To export some data from Oracle to a text file (flatfile), due to the large data table, the export fails when toad is used. In fact, the memory overflow occurs. It seems that Oracle's own life is still used

To export some data from Oracle to a text file (flatfile), due to the large data table, the export fails when toad is used. In fact, the memory overflow occurs. It seems that we should use Oracle's own command to complete it.

First, prepare the exported directory. Assume It is/opt/tmp. This directory requires the Oracle account to be able to read and write.
Create or replace directory utlexportpath as '/opt/tmp ';

Then, you can use the following method to export the file in sqlplus:

Declare
Outfile utl_file.file_type;
Begin
Outfile: = utl_file.fopen ('UTLEXPORTPATH', 'Exp.txt', 'w ');
For rec in (select col1, col2 from sometable where your conditions)
Loop
Utl_file.put_line (outfile, rec. col1 | ',' | rec. col2 );
End loop;
Utl_file.fclose (f );
End;

Even the data on G can be exported very quickly.
Try it.