We have around 20 big tables in our oracle 188.8.131.52 database which have a CLOB field. we want to upgrade to Oracle 11g, using a new installation of the 11g database and import the data from old database. the problem is that export/import takes so much time for the CLOB tables, that we dont have the time window for it. ( all other tables, even very large don't have this performance issue)
What is the best way of moving large tables with CLOB field between databases?