Managing Database Resources - OCP: Oracle Database 12c Administrator Certified Professional - page 475

In the previous target-side endian conversion example, we copied the tablespace data
file and converted it into the /oracle/oradata/LNEB directory. Make sure that you have a
DIRECTORY created for the target database and that you have copied the export metadata
file referenced by DUMPFILE into that location. Now we'll import the data files:
IMPDP DUMPFILE=expdat.dmp DIRECTORY=imp_dir
TRANSPORT_DATAFILES=/oracle/oradata/LNEB/user_data01.dbf
If the schema owner on the source does not exist on the target, you must
either create the schema owner on the target or use the REMAP_SCHEMA import
clause to specify a new schema owner. You must use a valid DIRECTORY
object in your Data Pump import command.
Once you have verified that the import completed successfully, it would be a good time
to verify that the source tablespaces are in read-write mode.
In Exercise 10.1, you will see how to export a transportable tablespace set.
e xeRCiSe 10.1
exporting a Transportable Tablespace Set
To export a transportable tablespace set, do the following:
1. Check source and destination compatibility.
2. Select the tablespaces for the transportable tablespace set and verify that the set is
self-contained.
3. Generate the transportable tablespace set.
Using Enterprise Manager to Transport a Tablespace
In this section, we will show you how to transport a tablespace using Enterprise Manager.
From the Enterprise Manager database home page, click the Schema menu; then click the
Database Export/Import menu item and then Transport Tablespaces, as shown in Figure 10.5.
From the Transport Tablespaces page, select the Generate A Transportable Tablespace
Set option, provide the host credentials, and then click the Continue button, as shown in
Figure 10.6.
Now, in the screen shown in Figure 10.7, add the tablespaces required in the transport-
able tablespace set, and choose Self or Full under Containment Type. For self-contained,
determine if you need to include constraints. You can also check containment at this time.
Once you have checked containment, you will be given the opportunity to select the des-
tination database platform and character set, as shown in Figure 10.8.