In this post, we will discuss the oracle drop index, how to Drop the index in Oracle, Drop Oracle Index if exists, and How to drop unique index in oracle How to Drop the index in Oracle You can drop an index in oracle using the DROP INDEX command. It removes the named index. General …
How to Drop the index in Oracle Read More »
In this page, we discuss about row migration and row chaining in oracle What is row migration We will migrate a row when an update to that row would cause it to not fit on the block anymore (with all of the other data that exists there currently). Migration means that the entire row will …
We are explaining here the Types of backup in oracle database Different Types of backup in oracle database What is online backup: An online backup or also known as an open backup is a backup in which all read-write data files and control files have not been checkpointed with respect to the same SCN. For example, …
Here in this section, We are giving the Introduction to Oracle database backup What is Oracle Database backup? A backup is a snapshot of a data file, tablespace, or database at a certain time. This copy can include important parts of a database such as the control file, redo logs and datafiles A backup protects …
We will discuss the difference between the Oracle database and Oracle instance in this post What is Oracle Database Oracle database is comprised of a set of operating system files containing data entered by users or applications and structural information about the database itself called database metadata. Information is stored persistently in these files. A …
Hot backup database cloning is more suitable for databases that are running 24/7 types of databases and is done using the hot backup. For hot database cloning, the database has to be in archivelog mode and there is no need to shut down the database. The high-level steps for How to clone the database using …
How to clone the database using Manual Hot backup Read More »
