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”. […]
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 […]
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 […]
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, […]
In this post, you use the ADMIN user schema. You store the Auth Token created in the previous post along with the username, as a credential under an ADMIN schema. Connect to ADMIN user using SQL Developer. Use the create_credential procedure of the DBMS_CLOUD package to store the object store credentials in your ADMIN schema. Set the […]
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. […]
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 […]
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 […]
In this post, you will create a storage bucket using Oracle Cloud Infrastructure (OCI) Object Storage. 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 the Hamburger menu and select “Object Storage” or alternatively, click on “Object Storage” on […]
In this post, you will connect to the ADWC database instance using SQL Developer. As ADWConly accepts secure connections to the database, you need to download a wallet file containing your credentials first. The wallet is downloaded from the ADWC service console. On the Instances page, find your database and click “Service Console” in the actions […]