I use 11gR2 version Database. I tried to migrate the character set of this database. After csscan, in the logfile I could see lot of CLOB objects that need conversion. It means that I must export those objects before applying csalter and then import them back in to the DB after csalter process. Now the question arises. How can I find all those CLOB objects in the database altogether and export them? Your assistance is appreciated kindly...
For a single schema you can do it like this:
include=TABLE:"IN (SELECT distinct table_name from dba_lobs where owner='your_schema_name_here' )"
Not sure you can do that for all schemas easily though.