Oracle Utilities - OCP: Oracle Database 12c Administrator Certified Professional - page 594

e xeRCiSe 13.1 (continued)
. . imported "HR"."REGIONS" 5.523 KB 4 rows
…
C:\Temp>
Chapter 14, “Managing Security in a CDB and PDBs,” goes into greater
detail about users, roles, and privileges in CDBs and PDBs.
Connecting to the PDB and Confirming Data Pump Import Success
As a follow-up to Exercise 13.1, connect to the PDB and verify the contents of the HR
schema by selecting the names of the tables in the HR schema. You can compare row counts
to the source non-CDB, and you can also compare the export and import log file number of
rows exported and imported for each table. Here we'll log on to the PDB as the HR user and
verify content. Please note that your table names and row counts may differ from the previ-
ous example.
SQL> CONNECT hr/hr@LNE6
Connected.
SQL> SELECT table_name FROM user_tables;
TABLE_NAME
----------------------------------------
JOB_HISTORY
EMPLOYEES
JOBS
LOCATIONS
REGIONS
DEPARTMENTS
EMPLOYEES_HIST
COUNTRIES
8 rows selected.
SQL>
SQL> SELECT COUNT(1) FROM COUNTRIES;