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,…
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 Autonomous Database Schema Advisor First of all, check the database schemas you want to export from the source database using the Autonomous Database Schema…
In this part, we will summarize all topics in previous parts and introduce a decision tree to help you determine what migration methods are applicable depending on your system characteristics and requirements. Why Move to Oracle Cloud? By running your Oracle databases on Oracle Cloud you benefit from a high degree of automation, simplified management, implementing…
In previous parts, we discussed how to move Oracle databases from on-premise to Oracle Cloud. In this part, we will deal with migrating Oracle databases running on Amazon Web Services (AWS) to Oracle cloud. Why to move to the Oracle cloud? Have a look at part 1 highlighting the benefits of the Oracle cloud. Summarized in one…
In this part we will introduce the following migration tools and methods mostly suitable for moving a small amount of data, a limited number of objects, and data stored in flat files: SQL Developer Database Copy Utility SQL Developer Cart Utility SQL Developer Drag and Drop Option SQL Developer Export and Import Wizard SQL*Loader DBMS_CLOUD COPY_DATA…
In this part we will introduce the following migration methods using Multitenant Architecture: Unplug & Plug Remote Cloning Remote Hot Cloning PDB Refreshable Clone PDB Relocate Multitenant Architecture The multitenant architecture provides easy and powerful features to move databases across platforms, even with just one single SQL command. It’s almost magic! The multitenant option was…
In this part we will introduce the following migration methods using RMAN: RMAN Transportable Tablespace with Data Pump RMAN Convert Transportable Tablespace with Data Pump RMAN Cross-Platform Transportable Tablespace Backup Sets RMAN Cross-Platform Transportable PDB RMAN Cross-Platform Transportable PDB Inconsistent Backups RMAN Duplicate from an Active Database RMAN Backup & Restore RMAN Oracle Recovery Manager…
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.…
In this part, we will introduce the automation tools and Maximum Availability Architecture (MAA) migration methods. Automation Tools Automation is one of the major benefits of migrating workloads to the cloud. Oracle provides different database migration solutions to even automate the migration process to the cloud. MV2ADB (Move to Autonomous Database) MV2ADB is a command-line tool…
In this part, we will discuss the database characteristics and factors that affect choosing a migration method. Some of the migration methods apply only if specific characteristics of the source and destination database match or are compatible. Logical vs. Physical Migrations Logical migration means extracting the database objects and data from the source database and creating…
