Introduction Using Data Pump export and import is quite straightforward. Letting ZDM do it all for you (export, copy, import, and clean up) makes it possible to test your migration multiple times for no additional effort, and then when you are ready for the real migration, you are sure that exactly the same steps are…
Tag: Data Pump
Import your Data directly from Object Storage in Oracle Database 21.3 and 19.12
Introduction To directly export and import data to and from Object Storage, you need the DBMS_CLOUD PL/SQL package, which was initially introduced in Oracle Autonomous Database. DBMS_CLOUD was made available for non-Autonomous Oracle Databases with version 21c and later backported to 19.9. However, direct import and export from and to Object Storage using the Data…
Part 3/5: Zero Downtime Migration (ZDM) – Logical Offline Migration using Data Pump
Introduction ZDM version 21c supports logical migrations using Oracle GoldenGate as described in Part 2 or using the classical Data Pump export and import. This blog post provides a step by step instruction how to accordingly configure ZDM for Data Pump export and import with the minimal parameters required. Using Data Pump export and import…
Part 1/5: Zero Downtime Migration (ZDM) – Introduction & Installation
Introduction Oracle Zero Downtime Migration (ZDM) is a free-to-use software solution that allows you to automate your Oracle database migrations to Oracle Cloud. Initially, ZDM supported Data Guard-based migrations following the principles of Oracle Maximum Availability Architecture (MAA). To support Standard Edition migrations, ZDM uses RMAN backup and restore instead. The new ZDM version 21c…
Use your Web Browser to import Data Pump dump files into Oracle Autonomous Database
Introduction This is a step by step instruction of the minimum steps needed to import your Data Pump dump files into Oracle Autonomous Database. Without installing anything! Before you export your data, have a look at best practices and what to consider when you migrate to Autonomous Database. Step 0: Upload you Dump Files into…
Why do I get “ORA-12899 value too large for column” when migrating to Autonomous Database?
You’ll get this message if Your source database uses a single-byte character set (e.g. WE8ISO8859P1), and Your column width is defined using BYTE length semantic, and You have some column values that do not fit when using a multi-byte character set (e.g. UTF8) as Autonomous Database does If you are not familiar with these terms,…
What should I consider when migrating to Autonomous Database using Data Pump?
Oracle Data Pump enables you to move data and metadata from one database to another, providing an extensive range of benefits. The followings are tips and best practices to consider: 1. Run the Cloud Premigration Advisor Tool (CPAT) First of all, check the database schemas you want to export from the source database using the Cloud…
Part 5/10: Migration Methods using Data Pump
In this part we will introduce the following migration methods using Oracle Data Pump export and import utilities: Data Pump Conventional Export and Import. Data Pump Full Transportable. Data Pump Transportable Tablespace. Data Pump Convert Full Transportable. Data Pump Oracle Data Pump technology enables you to move data and metadata from one database to another.…
Automate Data Pump Export in Autonomous Database for Archiving incl. Cross-region Copy
Oracle Autonomous Database eliminates the human labor associated with database tuning, security, backups, patching, upgrade, and other routine management tasks traditionally had to be performed manually. Other tasks like restore and recovery, migration, cloning, and moving data are done on demand (manually), but differently and more conveniently than on-premise. Data Pump is a very useful utility to extract…