1，NOTE: Only those database objects that are physically located in the tablespace(s) being transported will be copied to the destination system. Other objects, such as users, pl/sql objects, sequences, views etc., located in the SYSTEM tablespace will not be transported. You will need to pre-create the users and copy such objects to the destination system, possibly using data pump.
Metadata Residing in the SYSTEM or SYSAUX Tablespaces
Database metadata includes views, synonyms, type definitions, database links,
PL/SQL packages, roles, Java classes, privileges, sequences, and other objects.
Running a full database, metadata-only import creates database metadata that is not
automatically created in the target database by the transport process. This will be
accomplished with two separate import processes, as detailed in the following
steps.
SYSTEM-Owned Objects Residing in the SYSTEM or SYSAUX Tablespaces
Some applications create tables and indexes owned by the SYSTEM user that are
required for proper application functionality. To properly identify these objects
requires application-specific knowledge. You must move these objects to the target
database manually with Data Pump, or manually re-create the objects after
performing the platform migration.
User-Owned Tables Residing in the SYSTEM or SYSAUX Tablespaces
Run the following script (provided in the Appendix) to identify user objects that
reside in SYSTEM or SYSAUX:
Handle Objects in the SYSTEM or SYSAUX Tablespaces
Because XTTS does not move objects that reside in the SYSTEM or SYSAUX
tablespaces of the source database, the following conditions warrant special
consideration when transporting a whole database:
NOTE: Only those database objects that are physically located in the tablespace(s) being transported will be copied to the destination system. Other objects, such as users, pl/sql objects, sequences, views etc., located in the SYSTEM tablespace will not be transported. You will need to pre-create the users and copy such objects to the destination system, possibly using data pump.
The following may help:
Oracle Database 12c: Full Transportable Export/Import
and/or
MAA paper Platform Migration Using Transportable Tablespaces: Oracle Database.
