I need create a copy of an Oracle 12.2 instance (Oracle Restart) running on an Linux VM. The new instance needs a charset conversion from WE8ISO8859P1 to UTF8

I started by creating a clone of the VM that is now up and running.

I was thinking about following these steps:

  1. expdp FULL=YES from the cloned machine to a safe storage location
  2. destroy the database from the clone using DBCA
  3. create a new database on the clone using DBCA setting UTF-8 as charset
  4. impdp FULL=YES from the previous exported datapump

I have some doubts about the impdp FULL=YES... will this work or will it overwite some configuration on SYS or other Oracle maintained schemas with some values that still refers to WE8ISO8859P1 charset?

Will this work or should I exclude all the Oracle maintained schemas from the impdp?

  • Watch out, your varchar2 columns may not be wide enough to hold a string converted from we8iso8859p1 to UTF-8. – Gerard H. Pille Mar 19 at 20:59
  • Sure, the character length semantic is a topic I do know very well ad I already modified on the source database on both objects definition and PL/SQL code variable declaration – Massimo Pasquini Mar 20 at 10:08
  • OK, couldn't tell from your profile what your experience was. Hope you are in good health, better than your avatar. – Gerard H. Pille Mar 20 at 10:59

On export the documentation states:

A full export does not, by default, export system schemas that contain Oracle-managed data 
and metadata. Examples of system schemas that are not exported by default include 

If you want to be absolutely sure I would switch to a schema-mode import instead. You can still use the full export. That way you specify what schemas you want to import.

Regards, Daniel

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.