Monday, March 6, 2023

Transportable Tablespaces for Oracle Database Migration to Oracle Cloud

 More and more Oracle databases are being lifted from on-prem and migrated over to Oracle cloud. This trend is picking up great pace as benefits of cloud are evident.

Oracle cloud gives you unlimited capacity, automated data security, and superior resilience, while consolidating resources and removing silos to streamline usage. Whether you are moving transactional, analytic, structured, or unstructured data, Oracle Cloud has the migration tools. 

Transportable table space option offers migration of database between different endian formats. In this method data files are copied from source database in read-only mode and converted to target format and plugged to target database. Migration also requires metadata also be imported to target database, this is achieved by taking export of metadata using expdp and importing in target database.

Following are the limitations for this method:

  • Source and target database should be in same version
  • Tablespaces in source database are required to be in READ-ONLY mode.
  • Objects of one schema required to be contained in one table space, if this is not the case then objects need to be moved to same table-space before migration.

Many, but not all, platforms are supported for cross-platform tablespace transport. You can query the V$TRANSPORTABLE_PLATFORM view to see the platforms that are supported, and to determine their platform IDs and their endian format (byte ordering). For example, the following query displays the currently supported platforms:



Oracle docs say that if the source platform and the target platform are of different endianness, then an additional step must be done on either the source or target platform to convert the tablespace being transported to the target format. If they are of the same endianness, then no conversion is necessary and tablespaces can be transported as if they were on the same platform.

This method might not be suitable for all use cases but for edge cases, this can be considered.

No comments: