Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

change character set from US7ASCII (9i database ) to new 10g database (UTF8

787186Jul 23 2010 — edited Jul 26 2010
My current database is on 9i with characterset as US7ASCII , we are planning to upgrade it to 10g by creating new 10g database and doing export/import.

My question is can i create new 10g database with characterset as UTF8 ,and then do export/import from 9i (US7ASCII) to 10g (UTF8).

b) Will export/import convert all data , or i have to run CSSCAN on 9i .

Can someone povide me steps.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2010
Added on Jul 23 2010
6 comments
2,045 views