This forum is currently locked. You can't register or post questions at this time. (read more)

Characterset Migration

All posts relating to Oracle database administration.

Moderator: Tim...

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

Vimal.

Monto
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'

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

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 7 guests

cron