You are about to plug a multi-terabyte non-CDB into an existing multitenant container
database (CDB) as a pluggable database (PDB). – The characteristics of the non-CDB are
as follows: – Version: Oracle Database 12c Releases 1 64-bit – Character set:
WE8ISO8859P15 – National character set: AL16UTF16 – O/S: Oracle Linux 6 64-bit The
characteristics of the CDB are as follows: – Version: Oracle Database 12c Release 1 64-bit –
Character set: AL32UTF8 – O/S: Oracle Linux 6 64-bit Which technique should you use to
minimize down time while plugging this non-CDB into the CDB?
A.
Transportable tablespace
B.
Data Pump full export / import
C.
The DBMS_PDB package
D.
RMAN
E.
Transportable database
Your home is valueble for me. Thanks!…
http://www.bastcilkdoptb.com/
D
Sorry, it’s C
When you plug a new PDB, two situations may happen depending on the national character set of the new PDB:
The character set is the same as the national character set of the CDB. In this case, the plugging operation succeeds (as far as the national character set is concerned).
The character set is not the same as the national character set of the CDB. In this case, the new PDB can only be opened in restricted mode for administrative tasks and cannot be used for production. Unless you have a tool that can migrate the national character set of the new PDB to the character set of the CDB, the new PDB is unusable.
In Oracle Database 12c, all containers of a multitenant container database (CDB) must have the same database character set and the same national character set. That is, all pluggable databases (PDBs) in a CDB must have the same character set as the CDB’s root container. The character sets of the root container are considered the character sets of the whole CDB.
I agree that the charactersets are incompatible, so C is incorrect.
Transportable is not going to work, as this requires the charactersets to be the same – so A and E are wrong.
RMAN cannot be used for changing character sets, so D is wrong
Therefore, the fastest/only way to accomplish this would be with a datapump export/import?
Only possible answer, for me, is B
Below youll uncover the link to some web pages that we believe you must visit.