Workspace Manager in Oracle 19c
Workspace Manager in Oracle 19c Introduction: Workspace Manager, a feature of Oracle Database, enables application developers and DBAs to manage current, proposed and historical versions of data in the same…
Read MoreConfiguring Physical Standby Database Using Data Guard
Configuring Physical Standby Database Using Data Guard Primary Database - Dhee Standby Database - Dheedr STEP 1: Check the Primary DB is in archive log mode or not.If it is…
Read MoreCreating Physical Standby using RMAN Backup
Creating Physical Standby using RMAN Backup: A physical standby database is an exact, block-for-block copy of a primary database. A physical standby is maintained as an exact copy through a process…
Read MoreORA 02049: Distributed Transaction Timeout waiting for lock
ORA 02049: Distributed Transaction Timeout waiting for lock This error occurs when a session is trying to modify a table’s row in a remote database through a database link that…
Read MoreRecovering Datafile Without Rman Backup
It is possible to recover datafile when accidentally removed or deleted and when there is no backup at all , We can recover the datafile without any issues ,now i…
Read MoreACFS FILE SYSTEM IN OCI
ACFS FILE SYSTEM IN OCI Oracle ASM Cluster File System (ACFS) is a general purpose cluster file system implemented as part of ASM. It can be used to store almost…
Read MoreOracle NID Utility
Oracle NID Utility – Changing the Database Name This utility allows the user to change the DBID or the database name NID utility was introduced in Oracle 10g. Giving…
Read MoreMoving Table from one tablespace to another tablespace
The alter table move command moves rows down into un-used space and adjusts the HWM but does not adjust the segments extents, and the table size remains the same. …
Read MoreRMAN – Backup Based Clone
RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server…
Read MoreRecycle Bin in Oracle
Oracle database has the recycle bin which is a data dictionary table and contains information about dropped objects. Until we don’t use the purge option, all dropped tables and…
Read More