nerdexam
Oracle

1Z0-062 · Question #109

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…

The correct answer is D. The DBMS_PDB package. Generating a Pluggable Database Manifest File for the Non-CDB Execute the dbms_pdb.describe procedure to generate the manifest file. exec dbms_pdb.describe(pdb_descr_file=>'/u01/app/oracle/oradata/noncdb/noncdb.xml'); Shut down the noncdb instance to prepare to copy the data…

Moving Data

Question

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?

Options

  • ATransportable database
  • BTransportable tablespace
  • CData Pump full export / import
  • DThe DBMS_PDB package
  • ERMAN

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    16% (5)
  • C
    6% (2)
  • D
    72% (23)
  • E
    3% (1)

Explanation

  • Generating a Pluggable Database Manifest File for the Non-CDB Execute the dbms_pdb.describe procedure to generate the manifest file. exec dbms_pdb.describe(pdb_descr_file=>'/u01/app/oracle/oradata/noncdb/noncdb.xml'); Shut down the noncdb instance to prepare to copy the data files in the next section. shutdown immediate

Topics

#Non-CDB to PDB conversion#DBMS_PDB package#Downtime minimization#Multitenant architecture

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice