Tag: Migration

SYSDATE vs. CURRENT_DATE in Oracle Database

Introduction SYSDATE is a SQL function that returns the current date and time set for the operating system of the database server. CURRENT_DATE returns the current date in the session time zone. The same story applies to SYSTIMESTAMP and CURRENT_TIMESTAMP. When database and application servers are set to the same time zone, both functions will return the…

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…

Use an Existing RMAN Backup with Zero Downtime Migration

Introduction From the very first version, Oracle Zero Downtime Migration (ZDM) supports physical online, and offline migrations using RMAN and Data Guard. However, every migration job was creating a new RMAN backup from the source database to be used to create the target database. Starting with ZDM version 21.2, you can skip the full backup…

AWS RDS for Oracle to Autonomous Database using Zero Downtime Migration

Introduction Zero Downtime Migration (ZDM) provides great automation capabilities to migrate your Oracle Database to Oracle Cloud. After supporting Linux-based platforms, the new version 21.2 also supports cross-platform and even cross-cloud migrations. With this enhancement, now it’s possible to migrate an AWS RDS for Oracle to Oracle Autonomous Database using the offline logical migration method…

How to Import your Data into Oracle Autonomous Database – APEX Service

Introduction As you probably already know, Oracle APEX enables you to build applications with minimal coding. APEX is already available in all Oracle Autonomous Database workload types: transaction processing, data warehouse, and JSON. You get a fully-managed database where you can even more focus on your application development. Additionally, Oracle provides an Autonomous Database specifically…

Why you should run your Oracle Database on Oracle Cloud

Introduction As IT environments are growing and becoming more complex, the need for standardization, cost reduction, and greater agility is raising more than ever. Cloud solutions provide customers with features and capabilities to exactly achieve these goals and satisfy their business demands. When it comes to moving Oracle databases to the cloud, you might ask…