Quote Originally Posted by tamilselvan
Run the export command with suitable value for RECORDLENGTH parameter.

The max value is 64KB.

Also, increase buffer size.

Tamil
Thanks for the tips, that were really helpful I exported with the same table with following syntax and export took 36mins.
WAY-1
Exp system@INTORA1 TABLES= (COL.ABC_TEXT) DIRECT=Y RECODELENTH=65335 FILE=C:\ABC_TEXT.dmp

WAY-2
Exp system@INTORA1 TABLES= (COL.ABC_TEXT) FILE=C:\ABC_TEXT.dmp BUFFER=37748736

Following is a note from Oracle Doc:
"The Buffer parameter applies only to conventional path export. It has no effect on a direct path Export. For direct path exports use RECORDLENTH parameter to specify the size of the buffer that Export uses for writing to the export file."

Both the above ways took 36 mins to complete. Just want to confirm which of the above is correct or both are correct.

First can you throw some light when you mentioned "Increase BUFFER SIZE"

Second How can I make Import process faster for above table.

You reply on above is highly appreciated.