Tuesday, October 13, 2009

oracle character set conversion exp/imp

Tuesday, October 13, 2009 Posted by Andre Broers
To convert a schema to another characterset i used the following:

C:schemasogg>imp / file=expdat.dmp full=y indexfile=schema.sql

this wil get the schema. Use the following vim commands to convert to CHAR instead of BYTE sizes:

:s/REM ... .* rows$//g1000
:s/CONNECT .*;$//g1000
:s/REM //g1000
:s/CHAR((d*))/CHAR(1 CHAR)/g1000
:s/CHAR2((d*))/CHAR2(1 CHAR)/g1000
:s/""/""/g1000