Answer Detail: RE: DML operations on standby database

GeekInterview.com > Interview Questions > Oracle > Database Administration

Print |

Question: DML operations on standby database

Answer: Can you perform DML operations when the standby database is in read only in Standby Database?

September 09, 2009 17:42:15	#4
cmanne	Member Since: January 2006 Total Comments: 49
RE: DML operations on standby database
In a nutshell, One can do SELECTS only on a Physical/Logical Standby database. The basic principle behind Oracle Standby database is to provide protection against media failures. So no DMLs are allowed on the standby database and the most important things is that Standby databases can always be opened in READ-ONLY mode which won't allow DMLs.

Back To Question