Oracle Archives - Page 8 of 30

How to Identify and Remove the duplicate rows in a Table?

In case if we want to identify duplicates rows of a table and want to remove them from a table. Below are the command which will identify and remove the…

asrblogger October 15, 2023No Comments

Interview Questions Oracle

Basic Concepts of Index

Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join indexes, function-based indexes, reverse key indexes and text indexes are all just variations on the…

asrblogger October 15, 2023No Comments

Oracle

Oracle Database Block Corruption

Block-Corruption-RecoveryDownload What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. Data Block corruptions are one of the common source of database…

asrblogger October 15, 2023No Comments

Oracle

Things to know before Upgrading Oracle 12c DB !!

Why there is a need to upgrade Oracle 12c Database? The most important reason to upgrade 12c is to enjoy continued access to Oracle support. Premier Support for Oracle Database…

asrblogger October 15, 2023No Comments

Interview Questions Oracle

Export/Import Interview Questions-II

What is use of INDEXFILE option in imp? Will write DDLs of the objects in the dumpfile into the specified file. What is use of IGNORE option in imp? Will…

asrblogger October 15, 2023No Comments

Interview Questions Oracle

Export/Import Interview questions-I

What is use of CONSISTENT option in exp? When you export a table, you are guaranteed that the contents of that table will be consistent with the time that the…

asrblogger October 15, 2023No Comments

Core DBA Oracle

ORA-65011: Pluggable database does not exist.

Below is the error while I was upgrading my test environment. SQL> alter pluggable database application CODDY begin upgrade '1.3' to '1.4'; alter pluggable database application CODDY begin upgrade '1.3'…

asrblogger October 14, 2023No Comments

Interview Questions Oracle

What is redo log thread?

In Oracle Database, a redo log thread refers to a specific instance of redo log processing within the database. Redo logs are crucial components of a database system, responsible for…

asrblogger October 11, 2023No Comments

Oracle

“ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired”

Scenario 1: If the jobs are running too frequently, it is possible the queries are not releasing the lock and resulting in the error: “ORA-00054: resource busy and acquire with…

asrblogger October 10, 2023No Comments

Oracle

Full Table Scan (FTS) in Oracle

A full table scan reads all rows from a table, and then filters out those rows that do not meet the selection criteria. Just because during accessing large number of…