Export Oracle Database 12c Data with Full Transportable Export/Import Method

Oracle Database 12c Full Transportable Export Import

Prerequisites

Ensure source database is version 11.2.0.3 or later. Check endianness compatibility. Prepare a directory for Data Pump and set user-defined tablespaces to READ ONLY. Create TTS export and import parameter files.

Export Process Using Data Pump

Use the expdp command with the full transportable export method. Generate a list of tablespaces and a script to verify their block sizes. Transfer the dump file and datafiles using a secure copy utility.

Import Process on Target Database

On the Oracle Database 12c target, use the impdp command with the TRANSPORT_DATAFILES option. After successful import, set tablespaces to READ WRITE.

Additional Considerations

Use the db_nK_cache_size parameter for non-default block size support. Utilize the Full Transportable Export/Import feature in both file-based and nonfile-based modes.

Frequently Asked Questions

What are the prerequisites for the source database when using Oracle Database 12c full transportable export/import?

The source database must be Oracle Database 11g, specifically release version 11.2.0.3 or later, and it must be running on a Linux host.

What steps are required to prepare the source database for a Data Pump full transportable export?

The user-defined tablespaces must be placed in READ ONLY mode, and the Data Pump export (expdp) must be initiated with the parameters FULL=y, TRANSPORTABLE=always, and VERSION=12.

Can Data Pump full transportable export/import handle differences in character sets between the source and destination databases?

Character set and national character set differences may cause issues during the transport, so both the on-premises database and the Oracle Cloud Infrastructure Database service database must have compatible database character sets.

What options are available to prevent a full backup/restore/incremental-roll-forward if the tablespaces are taken read-write during impdp?

Leveraging storage snapshot technologies to restore the files to their state before Data Pump ran is an option for preventing a full backup/restore/incremental-roll-forward.

Can the Data Pump Full Transportable method be used to migrate a database to Oracle Cloud?

Yes, the Data Pump Full Transportable method can be used to copy an entire database from an on-premises host to a Database service database deployment in Oracle Cloud Infrastructure.

Common Use Cases

• 
  Migrating an entire database from an older version to Oracle Database 12c to leverage new features and improve performance
• 
  Consolidating multiple databases into a single Oracle Database 12c instance for streamlined management and maintenance
• 
  Moving a database to a new server environment with minimal downtime using the full transportable export/import feature
• 
  Upgrading and migrating databases to Oracle Cloud infrastructure to enhance scalability and availability
• 
  Performing cross-platform data migration with the ability to move data from non-Oracle databases to Oracle Database 12c

Discover Sourcetable: A Streamlined Alternative to Oracle 12c

Looking for a simpler solution than Oracle Database 12c full transportable export/import? Sourcetable provides a powerful, user-friendly spreadsheet interface for real-time data queries and management.

With Sourcetable, you can effortlessly integrate multiple data sources into a single spreadsheet view. This eliminates the complexity associated with traditional database exports and imports.

Gain real-time insights and manipulate your data with ease, a level of accessibility that traditional databases like Oracle 12c can't match.

Choose Sourcetable for a seamless data handling experience that requires no advanced database knowledge, making it an ideal alternative for users seeking straightforward data interaction.