Category: Autonomous Database

Am I Autonomous or non-Autonomous, that is the Question

Introduction As more and more customers are moving their databases to Oracle Cloud, they have a mix of on-premises, Oracle Database Cloud Service, and Oracle Autonomous databases in their environments. DBAs and developers usually use SQL scripts to automate several tasks in the database. In some cases, they want to execute some tasks only on…

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…

Real-time Data Replication between Oracle Autonomous Databases using Oracle GoldenGate

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.…

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…

Send Email from APEX deployed in Oracle Autonomous Database

In the Oracle Cloud, you can provision an Autonomous Database in minutes and start developing your APEX application immediatelly. If you don’t have an Oracle Cloud Account, register for the Always Free resources. From APEX, you can use the APEX_MAIL package to send emails using Oracle Cloud Infrastructure Email Delivery service. Check how easy it is to configure!!! Step…