ORA-08104: This Index Object Is Being Online Built Or Rebuilt

This post is about “ORA-08104”.  We are going t learn how to solve this issue. Steps are mention below:- While dropping an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair Problem: SQL> drop index eric_icmsprod.SOTRAN00_IDX1; drop index eric_icmsprod.SOTRAN00_IDX1 * ERROR at line 1: ORA-08104: this index object 94771 […]

Read More

Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials

Hi Readers Finally I’ve successfully passed 1Z0-337,  Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials. It was almost more than 2 months that I’ve been preparing for this. The Exam contains 60 questions related to Compute, Container, Networking and Ravello Services. To earn this certification you need to get 70% marks. This was the result of […]

Read More

Oracle Exadata 18c and Database Machine X7-2

Oracle Exadata Database Machine consists of Oracle Database servers, Exadata Storage Servers, and the network components to connect to your network. Oracle Exadata Database Machine is available as a full rack, half rack, quarter rack or eighth rack. The following table lists the components included for each type of Oracle Exadata Database Machine. Components of […]

Read More

Oracle 18c: How to load data in Oracle Autonomous Data Warehouse Cloud

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Loading Data into Autonomous Data Warehouse Cloud Database   Data […]

Read More

Open Wallet Automatically After Starting The Database

This article about Open Wallet Automatically After Starting The Database.  If encryption wallet is enabled, then every time we start the database, we have to open the wallet manually. So to avoid this, we can create one trigger which will open the wallet automatically, once you start the database. Below is the trigger: CREATE or replace […]

Read More

Oracle 18c: RMAN New Features

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez Before starting to read, if you want to access others Oracle RMAN Cloud Articles, you can go here: #6 Oracle Cloud (DBaaS): Migrating Databases to Oracle Cloud Using RMAN Backup #11 Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using […]

Read More

Oracle 18c: Data Warehousing New Features

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Data Warehousing will be the focus of […]

Read More

How To Find The Cluster Name In Oracle RAC

This article is short and simple. It explains the ways to find the cluster name in Oracle RAC. First few lines explain about the cluster. A cluster comprises multiple co-ordinated computers or servers that appear as if they are one server to end users and applications. Oracle RAC enables you to cluster Oracle databases. Oracle RAC uses […]

Read More