5 Migrating Oracle Database
Use the transportable tablespaces feature to copy a set of tablespaces from one Oracle Database to another.
- Checking Character Set Compatibility
To check character set compatibility, run these commands on both the source and destination databases. - Transporting Tablespaces Between Databases
You can transport a tablespace or a set of tablespaces between databases. - Task 1: Pick a Self-Contained Set of Tablespaces
See how to determine if the tablespaces you want to use are self-contained, or have dependencies. - Task 2: Generate a Transportable Tablespace Set
After ensuring that you have a self-contained set of tablespaces that you want to transport, generate a transportable tablespace set. - Task 3: Transport the Export Dump File
Transport the dump file to the directory pointed to by theDATA_PUMP_DIRdirectory object, or to any other directory of your choosing. - Task 4: Transport the Tablespace Set
Transport the data files of the tablespaces to a directory that is accessible to the target database. - Task 5: (Optional) Restore Tablespaces to Read/Write Mode
Make the transported tablespaces read/write again at the source database. - Task 6: Import the Tablespace Set
To complete the transportable tablespaces operation, import the tablespace set. - Postmigration Tasks
Complete these tasks to prepare the target Oracle Database for use.