Quote Originally Posted by davey23uk
yeah, do some investigation and provide some analysis
We have table called ABC_TEXT with one columns as "MSG" and the data type was LONG I converted the LONG column to CLOB as given below.
Alter table ABC_TEXT modify msg clob;
Number of row were equal after modification i.e. "4500000" appox.
When I am exporting this table it took 3.25 Hours. That is my problem and export command is given below

exp system@abcvora1 tables=abc_TExT Direct=y file=C:\ABS.bak

kindly advice.