| Characterset Migration [message #182403] |
Fri, 14 July 2006 10:46 |
manish mendiratta
Messages: 110
Registered: May 2002
|
Senior Member |
|
|
Hi Folks,
I have testdb on 10g (10.2.0) which i created using characterset US7ASCII. Now i wish to migrate to AL32UTF8.
I created a table with CLOB.
I ran csscan utility on full database which said the CLOB column of this table is convertible as some other tables under SYS schema(not related to Data dictionary) which have CLOB column.
Now when i ran the script to alter the database characterset it threw me an error in alert log file giving me the tablename.column which had CLOB to remove the data. So i had to take an export all the tables which had CLOB column and removed the data and ran ALTER DATABASE CHARACETERSET and successfully migrated.
Now my question is, this was my test database. I have huge tables with million of records with CLOB as data. Do i have to export all the tables with CLOB and remove them and then migrate ?
This will increase my downtime considerably. Am i missing something here or this is the only way?
Please help me in this.
Thanks in advance.
Manish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
