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 and export them? Your assistance is appreciated Tim...
In response to the second part of your question, if you don't want to export the whole table, you could export just the CLOB values like this.
Thy could be manually imported,
Or imported using SQL*Loader or external tables.
http://www.oracle-base.com/articles/10g ... loader.php
http://www.oracle-base.com/articles/10g ... b-data.php
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://oracle-base.com
My blog: http://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 10 guests