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. PL / SQL has several …
Read More »
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. PL / SQL has several …
Read More »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 it. Blockchain is a technology …
Read More »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 examine recovering data file after …
Read More »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 as follows. ORA-16674: standby database …
Read More »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 operations performed in Primary are …
Read More »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 Apply after the time specified …
Read More »Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance out of our query . We should always add adequate …
Read More »Logical Standby Database does not support replication of all data types, tables, commands and PL / SQL Packages. Therefore, before converting a Physical Standby database to Logical Standby, a series …
Read More »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 that can be read-write in …
Read More »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 other did not open with …
Read More »