ORACLE

This article contains information about PL/SQL Data Types and Variables and Literals. Oracle PL/SQL Data Types Data types indicate how data is stored in memory. …

This article contains informations about Oracle Blockchain Tables and benefits. You will also find information about creating oracle blockchain tables and insert into data to …

Sometimes we may need to take a datafile offline and online in oracle. In this article we will take a look at these operations and …

If a database created as Physical Standby is converted to a Logical Standby database while the Broker configuration is enabled, you may receive an error …

Sometimes, we may not want to reflect the operations performed on the Primary database to the Logical Standby database. It can be ensured that DML …

To delete archive logs automatically on standby you should set LOG_AUTO_DEL_RETENTION_TARGET  parameter. The Foreign Archive Logs in Logical Standby Database is automatically deleted by SQL …

Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance out of our query . …

Logical Standby Database does not support replication of all data types, tables, commands and PL / SQL Packages. Therefore, before converting a Physical Standby database …

What is a logical standby database? Apart from Physical and Snapshot Standby Database, it is another type of Standby Database. It is an active database …

After the STANDBY Database is installed and the necessary configurations were made, when INSTANCEs wanted to be START, one of the INSTANCEs opened and the …