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…
Introduction ZDM version 21c supports logical migrations using Oracle GoldenGate. This makes it possible to migrate to Oracle Autonomous Database with zero downtime. This blog post provides a step by step instruction how to accordingly configure ZDM with the minimal parameters required. Data Pump will be used to create the initial load and GoldenGate extract…
Introduction Partitioned Tables allow you to subdivide tables into smaller pieces (partitions) that can be managed and accessed at a finer level of granularity. The nice thing is that it is entirely transparent to your SQL SELECT statements and to the application. External (Partitioned) Tables enable you to access data on external storage as if…
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…
Introduction Oracle GoldenGate is a software product that allows you to replicate, filter, and transform data from one database to another in real-time. It can be used to migrate databases with (near) zero downtime. As logical replication, source and target databases could be of different versions, platforms, and character sets. Even many non-Oracle databases are supported.…
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…
Scripts, batch jobs, and application code need to provide a database username and password to connect to the database. Using wallets risk is reduced because such passwords are no longer exposed in plain text, and password management policies are more easily enforced without changing application code whenever user names or passwords change. Connect using the connect…
Security is a primary concern for enterprise customers and one of the most discussed topics when it comes to move to the cloud. The same questions are being raised again and again: Is the cloud secure? Is my data safe their? Does it meet my compliance requirements? Before starting with the technical security features that…
End of February 2020 Private Endpoints in Autonomous Database on Shared Exadata Infrastructure were announced. This blog post shows an example architecture and a high-level step by step instruction for creating the necessary OCI resources to implement Private Endpoints to access the Autonomous Database from private network only. All values used here are an example and you are…
