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”. […]
All posts by Mohit Sharma
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. C:\Users\skagupta>sqlplus admin@skantorcldb_high SQL*Plus: Release 18.0.0.0.0 Production on Thu Feb 21 18:14:16 2019 Version […]
Upload Data Dump File to Oracle Cloud Infrastructure (OCI) Object Storage
In this post, you will learn how to upload the export dump file to Oracle Cloud Infrastructure (OCI) Object Storage and generate a Pre-Authenticated URL for the export dump file. We assume that you must have OCI account with valid credentials and compartments. Launch the web browser and Log into your assigned OCI account. Expand […]
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. [oracle@oracle19c ~]$ mkdir -p /u01/app/oracle/admin/orcl19c/dpdump/for_adwc On the On-Prem Machine, […]