Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP)


A few days ago Oracle announced the general availability of the Autonomous Transaction Processing service on Oracle Cloud. This is the next member of the Autonomous Database family of products.

I’ve already written about provisioning the Autonomous Data Warehouse service and now I’ve used the Autonomous Transaction Processing service also.

I also wrote about loading data into the ADW service using the DBMS_CLOUD package and Data Pump.

The methods described here can also be used with the ATP service. I’ve added a few extra notes to these articles to explain a couple of minor differences.

If you’ve got access to Oracle Cloud you should give them a try. I really hope this is the DBaaS++ service I’ve been waiting for from Oracle.



Author: Tim...

DBA, Developer, Author, Trainer.