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 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 from on-premises 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.…

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…