This post is in continuation of my previous post. After you created promotion account, you will receive an confirmation email along with credentials from oracle. Login to Oracle Cloud 1.…
Read MoreThis post is to create Promotion (trial) account for Oracle public Cloud. 1. Open below link in Web Browser. Enter Valid Email Address https://myservices.us.oraclecloud.com/mycloud/signup?language=en&sourceType=:ow:o:h:feb:TESTA 2. Click on Next Button. Which…
Read MoreIn this post, We will share – What is Terraform, How to install it, and How to Create EC2 instance via Terraform. What is Terraform Terraform is a tool for…
Read MorePlease follow the below for database clone through RMAN using standby database. 1) Step 1: ——————- a) Cancel the recovery in CTL DR on dbprod01. b) Open the database in read only mode.…
Read MorePlease follow the below steps to update the timezone to 26 for 12.2 database. conn / as sysdba purge dba_recyclebin; EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO(‘upg_tzv’) ; alter session set “_with_subquery”=materialize; alter session set…
Read MorePlease run the below query and get the explain plan for which baselines created for an SQL ID. col sql_text for a60 wrap set verify off set pagesize 999 set…
Read More-- STEPS: -- -- Disable constraints -- Disable triggers -- Copy -- Enable constraints -- Enable triggers SET SERVEROUTPUT ON PROMPT Enter the table's name you want to copy DEFINE…
Read More