well dont have to use plsql search for flat on asktom.oracle.com
use perl
or spool from sqlplus concatenating the columns together.
use utl_file to write to an os file concatting the columns together.
However 11 million records isnt very much at all, imp shouldnt take too long to do that, few minutes i reckon




Reply With Quote