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:
- expdp FULL=YES from the cloned machine to a safe storage location
- destroy the database from the clone using DBCA
- create a new database on the clone using DBCA setting UTF-8 as charset
- 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?