How to Create Transportable Tablespaces Where the Source and Destination are ASM-Based
Last updated on NOVEMBER 09, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 18.104.22.168 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 28-May-2010***
The purpose of this note is to describe the method to create transportable tablespaces(TTS) where the source and destination databases are ASM-based. This method uses standard utilities such as; DataPump and the database package dbms_file_transfer. The dbms_file_transfer package will be used to transfer the Datapump metadata and datafiles to the remote database server.
This note will illustrate a working example of creating and plugging in transportable tablespaces. In the example two servers, host1 and host2 are in different locations, with each one on an independent Hitachi storage array. Server host1 is the source database and will house database named db1. The server host2, which is deemed the target server and will subscribe to the transportable tables, will house the database called db2.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms