Oracle Database Kikuyus Replacement Character set

Ideas:

1. The database that creates a Utf-8 instance is used as the build environment for the database.

2. Using the PL SQL tool, the creation statement of the database is exported, executed in the Utf-8 database, and the skeleton structure of the Utf-8 Kikuyus is generated.

3. Create Dblink to replicate table data

   For example

   INSERT INTO Ess_report select * from [email protected];

Problem:

When copying the table data, for the Clob field cannot be copied, the workaround, you can skip the Clob field, the other fields of data first copied, and then with the UPDATE statement through the Dblink to do updates, you can complete the update.

Oracle Database Kikuyus Replacement Character set