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

Summary
In this chapter, you learned about resumable space operations, transportable tablespaces,
transportable databases, and segment shrink operations.
You learned about resumable space allocations and how to configure, detect, and rem-
edy suspended transactions. You learned about transportable tablespaces and transportable
databases. With transportable tablespaces, you can convert a tablespace set to run on a dif-
ferent platform with a different endian-ness using the RMAN CONVERT clause. You cannot
transport an entire database to a different endian format, but you can convert it to run on a
different platform with the same endian-ness.
The segment shrink feature can be used to reclaim space both above and below the high-
water mark while a segment remains online and in use.
You learned the basics of tablespace management in the new Oracle 12c multitenant
architecture, understanding that the root default temporary tablespace can be utilized by
each PDB and that each PDB can have its own default temporary tablespace.
Exam Essentials
Understand how to configure resumable space allocation. Know that if the Oracle data-
base encounters a space problem during the execution of an operation, it can suspend the
operation and then later resume the operation.
Describe the concepts of transportable tablespaces and databases. Know how to copy
tablespaces from one database to another and how to transport tablespaces and databases
from one platform to another.
Understand how to shrink segments. Understand that segments can become fragmented
and that wasted space due to fragmentation can be defragmented.
Understand how to manage temporary and permanent tablespaces in a CDB and PDBs.
Know how to alter the database to use a different default temporary tablespace for an
entire CDB. Know how to alter a PDB to use a different default temporary tablespace.