What is a transportable tablespace in Oracle?

Transportable tablespaces and transportable tables transport data that resides in user-defined tablespaces. Use the transportable tablespaces feature to move a set of tablespaces between databases. When transporting data, Oracle Database computes the lowest compatibility level at which the target database must run.

How do you do a transportable tablespace?

  1. Step 1: determine if platforms are supported and endianness:
  2. Step 2: pick a self-contained set of tablespaces:
  3. Step 3: generate a transportable tablespace set:
  4. Step 4: transport the tablespace set:
  5. Step 5: import the tablespace set:

How do I know if my tablespace is transportable?

For a tablespace to be transportable it must be totally self contained. This can be checked using the DBMS_TTS. TRANSPORT_SET_CHECK procedure. The TS_LIST parameter accepts a comma separated list of tablespace names and the INCL_CONSTRAINTS parameter indicates if constraints should be included in the check.

What is Rman transportable tablespace?

RMAN can do that since 10gR2. Transportable Tablespace is a beautiful feature: the performance of physical copy and the flexibility of logical export/import. There’s an alternative to that: restore the tablespace with TSPITR (tablespace point-in-time recovery) into a temporary instance and transport from there.

What is temporary tablespace?

Temporary tablespaces are used for storing temporary data, as would be created when SQL statements perform sort operations. An Oracle database gets a temporary tablespace when the database is created. You would create another temporary tablespace if you were creating a temporary tablespace group.

What is transportable tablespace in Oracle 12c?

Transportable tablespaces are usually the fastest fast way to move user and application data between databases, because tablespace data files are moved en masse from the source database to the target.

Do you think temporary tablespaces are useful?

Temporary tablespaces are used to manage space for database sort and joining operations and for storing global temporary tables. For joining two large tables or sorting a bigger result set, Oracle cannot do in memory by using SORT_AREA_SIZE in PGA (Programmable Global Area).

What is cross platform transportable tablespace?

Transportable Tablespace is used to move a large amount of data between databases where the tablespace is copied from source database to the target database. From the version 10g, a Tablespace can be Transported between databases on Different Platforms. …

Transportable Tablespaces. Transportable tablespaces were introduced in Oracle 8i to allow whole tablespaces to be copied between databases in the time it takes to copy the datafiles. In Oracle 8i one of the restrictions was that the block size of both databases must be the same.

Does Oracle 10g support cross platform tablespace?

Oracle 10g Onwards it allows cross OS platform tablespace movement. Prior to 10g It allows only with the same OS platform. Even if your source and target platforms are compatible or same, you won’t be able to transport the tablespace from source platform to target platform directly.

How to transport tablespace from source to target platform?

Even if your source and target platforms are compatible or same, you won’t be able to transport the tablespace from source platform to target platform directly. Before you start transporting or copying the datafile, you need to check the endian format of the data files in the source and target platform.

What are the uses of cross-platform transportable tablespaces?

Typical uses of cross-platform transportable tablespaces include: Publishing structured data as transportable tablespaces for distribution to customers, who can convert the tablespaces for integration into their existing databases regardless of platform

How do I move a set of tablespaces between databases?

Use the transportable tablespaces feature to move a set of tablespaces between databases. You can transport data across platforms. There are general limitations on transporting data. There are also limitations that are specific to full transportable export/import, transportable tablespaces, or transportable tables.

Is the transportable tablespace method cross-platform?

The transportable tablespace method provides broad cross-platform support with some limitations. If you are migrating from a big-endian platform to Exadata Cloud Service (little-endian), extra processing is required to perform a conversion. Ideally, the source and target database character sets should be the same (AL32UTF8).

How do I perform a transportable tablespace migration using data pump?

To perform a basic migration using the transportable tablespace method, you perform these tasks: Select a self-contained set of tablespaces. On the source database, place the set of tablespaces into read-only mode. On the source database host, execute Data Pump Export to unload the metadata associated with the tablespace set.

By Useful tips