Characterset Migration

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 20
Joined: Tue Jul 03, 2012 5:28 am

Characterset Migration

Postby valiantvimal » Thu Dec 13, 2012 8:16 am

Hi Tim,
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...


Senior Member
Posts: 195
Joined: Sat Jan 16, 2010 1:55 pm

Re: Characterset Migration

Postby Monto » Thu Dec 13, 2012 2:30 pm

This should get you what you are looking for....

select owner,table_name ,column_name,data_type
from dba_tab_columns A
where data_type='CLOB'

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Characterset Migration

Postby Tim... » Thu Dec 13, 2012 8:14 pm


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. ... loader.php ... b-data.php


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 1 guest