Migration using transportable tablespaces
Hi,I'm testing migration using transportable tablespaces Oracle database 10gr2
In the white paper I read,
rem Create metadata required for XTTS
rem Run Data Pump on the target system to import database metadata necessary for the transportable import.
rem The database metadata import is run in network mode and pulls directly from the source database.
$ impdp system/password DIRECTORY=ttsdir LOGFILE=dp_userimp.log NETWORK_LINK=ttslink FULL=y INCLUDE=USER,ROLE,ROLE_GRANT,PROFILE
and after impdp
rem Drop user tablespaces
rem Drop the placeholder tablespaces in the target database that were created when the target database was initially created by DBCA. If the default permanent tablespace is one of the tablespaces that will be dropped from the target database because it will be transported, then first change the database default permanent tablespace.
In the white paper I read,
rem Create metadata required for XTTS
rem Run Data Pump on the target system to import database metadata necessary for the transportable import.
rem The database metadata import is run in network mode and pulls directly from the source database.
$ impdp system/password DIRECTORY=ttsdir LOGFILE=dp_userimp.log NETWORK_LINK=ttslink FULL=y INCLUDE=USER,ROLE,ROLE_GRANT,PROFILE
and after impdp
rem Drop user tablespaces
rem Drop the placeholder tablespaces in the target database that were created when the target database was initially created by DBCA. If the default permanent tablespace is one of the tablespaces that will be dropped from the target database because it will be transported, then first change the database default permanent tablespace.
0