Login  Register

Re: xtts

Posted by ErmanArslansOracleBlog on Mar 04, 2024; 11:15am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/xtts-tp12334p12351.html

short answer -> use data pump.
Ref: Oracle Support

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 ->

Ref:
Oracle Database 12c: Full Transportable Export/Import
https://www.oracle.com/assets/full-transportable-wp-12c-1973971.pdf
and/or
MAA paper Platform Migration Using Transportable Tablespaces: Oracle Database.
https://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-platformmigrationtts-129269.pdf