change character set from US7ASCII (9i database ) to new 10g database (UTF8
787186Jul 23 2010 — edited Jul 26 2010My 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.