Terminating an Autonomous Transaction Processing (ATP) Instance

In this post, we are going to terminate the ATPdatabase on OCI. We assume that you must have OCI account with valid credentials and compartments. Terminating your ATP instance Go to the Cloud Console you used during the provisioning exercise and open the Instances screen. Click the Instance Name (NEWATP) Click Actions and Select “Terminate”. […]

Read More

Import Data Dump File into Oracle Autonomous Data Warehouse Cloud (ADWC) Using Data Pump

In this post, you will learn how to import a dump file into the adwc_hr schema in the Oracle Autonomous Data Warehouse Cloud (ADWC) service instance using data pump (impdp). Login with ADWC instacne and invoke SQL*plus then create the user adwc_hr.

Run the import command.

After successfully completion of import. Now, we […]

Read More

Migrating On-Prem Database Schema to Autonomous Data Warehouse Cloud (ADWC) Using Data Pump

In this post, you will learn how to export the HR Schema from On-Prem Oracle Database to ADWC instance using Data Pump Export (expdp). Log in to On-Prem Machine with oracle user and create a directory to place the dump files generated by using data pump.

On the On-Prem Machine, invoke SQL*Plus and log […]

Read More

Stopping/Starting your Autonomous Data Warehouse Cloud (ADWC) instance

In this post, we are going to stop & start the ADWC database on OCI. We assume that you must have OCI account with valid credentials and compartments. Stopping your ADWC instance Go to the Cloud Console you used during the provisioning exercise and open the Instances screen. Click the Instance Name (SKANTADWC). Click Stop. […]

Read More

Monitoring your ADWC instance

In this post, you will use the service console to monitor your ADWC instance. As ADWC only accepts secure connections to the database, you need to download a wallet file containing your credentials first. The wallet is downloaded from the ADWCservice console. On the Instances page, find your database and click “Service Console” in the actions […]

Read More

Loading a Data from csv into ADWC

In this post, you will load data from a csv file into ADWC. Note: we already have table.csv for our testing. Now, we open the SQL Developer and connect with NEWADW connection which is already save in SQL Developer. SQL Developer ADWC Right-click “Tables,” and then click “Import Data.” Click “Browse” and locate the channels.csv […]

Read More

Exadata x7-2 with Cell Storage 18c

Continuing to raise the bar for enterprise-class database platforms, today Oracle announced the next-generation Oracle Exadata X7 with significant hardware and software enhancements in overall performance, storage capacity, network bandwidth, and automation. Exadata x7-2 delivers extreme performance and reliability to run the largest, most business-critical database workloads. Oracle Exadata is an Engineered System designed to be the […]

Read More