Characterset Migration

All posts relating to Oracle database administration.

Moderator: Tim...

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...

Vimal.
valiantvimal
Member
 
Posts: 20
Joined: Tue Jul 03, 2012 5:28 am

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'
Monto
Senior Member
 
Posts: 193
Joined: Sat Jan 16, 2010 1:55 pm

Re: Characterset Migration

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

Hi.

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.

http://www.oracle-base.com/articles/8i/export-clob.php

Thy could be manually imported,

http://www.oracle-base.com/articles/8i/import-clob.php

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

Cheers

Tim...
Tim...
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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests