I want to know if there is a way to export tables (or the result from a Select statement) from Oracle to a text file in fast way (a table of millions of records).
I tried in the past UTL_FILE functions and PRO*C/C++ routines that writes each row after opening a cursor.
SQL Plus spool option I think it´s no good idea because I need that this file generation got to be made in automatic way (called from a Oracle Form or PL/SQL Block or PRO*C/C++)
Is there a export option for this ? or maybe a better way to make this porcess ?