Hi All Gurus,
Recently we changed Datatype from LONG to CLOB in our database tables. However when we are doing a export/Import of Schema it is long long time to complete .I do not understand as per
Oracle's documentation Oracle recommends change the datatype from LONG to CLOB.However EXP/IMP of those tables with CLOB takes for ever. Any Idea how to make it fast.
We are on Oracle 9.2.0.6.0
Any help on above is highly appreciated.
Regards