Database Reference
In-Depth Information
e xeRCiSe 13.1 (continued)
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
. . exported "HR"."EMPLOYEES_HIST" 75.38 MB 1115982 rows
. . exported "HR"."COUNTRIES" 6.437 KB 25 rows
. . exported "HR"."DEPARTMENTS" 7.101 KB 27 rows
. . exported "HR"."EMPLOYEES" 17.07 KB 107 rows
. . exported "HR"."EMPLOYEES_HIST_NEW" 32.18 KB 321 rows
. . exported "HR"."JOBS" 7.085 KB 19 rows
. . exported "HR"."JOB_HISTORY" 7.171 KB 10 rows
. . exported "HR"."LOCATIONS" 8.414 KB 23 rows
. . exported "HR"."REGIONS" 5.523 KB 4 rows
5. Complete the Data Pump import process. In the previous command we exported the
full database; here we will import part of the database into a PDB. Remember, the
PDB doesn't know about the DATA_PUMP_DIR so you must have created a database
directory in the PDB and reference the directory by name on the command line when
running the import. Also, source database roles may not exist in the target, so review
any errors and take action if necessary.
C:\Temp>impdp LNE6_ADMIN/system06@LNE6 DIRECTORY=dpump_dir DUMPFILE=ncdb_
expdat.dmp SCHEMAS=hr LOGFILE=dpump_dir:import.log
Import: Release 12.1.0.1.0 - Production on Sun Dec 8 20:01:35 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "HR"."EMPLOYEES_HIST" 75.38 MB 1115982 rows
. . imported "HR"."COUNTRIES" 6.437 KB 25 rows
. . imported "HR"."DEPARTMENTS" 7.101 KB 27 rows
. . imported "HR"."EMPLOYEES" 17.07 KB 107 rows
. . imported "HR"."JOBS" 7.085 KB 19 rows
. . imported "HR"."JOB_HISTORY" 7.171 KB 10 rows
. . imported "HR"."LOCATIONS" 8.414 KB 23 rows
Search WWH ::




Custom Search