OraFAQ Forum: Data Guard » Alter table and Data guard

Home » Server Options » Data Guard » Alter table and Data guard (Oracle 10.2.0.1.0 - Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Alter table and Data guard [message #379676]

Wed, 07 January 2009 10:48

danyromimd
Messages: 73
Registered: August 2008

Member

Hi all!
I've got a doubt. If I make al alter table or add an index or any such thing in the primary database does data guard propagate it to the Standby database?

Thanks in advance!

Daniela.

Report message to a moderator

Re: Alter table and Data guard [message #379677 is a reply to message #379676]

Wed, 07 January 2009 10:52

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Yes, it will.

PS: You can easily test it by opening your standby in READ ONLY mode to check if the ALTER was propagated.

Report message to a moderator

Re: Alter table and Data guard [message #379678 is a reply to message #379676]

Wed, 07 January 2009 10:59

danyromimd
Messages: 73
Registered: August 2008

Member

Thanks a lot!!!

Daniela.

Report message to a moderator

Previous Topic:	Recover Standby database
Next Topic:	Long transactions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 07 02:41:07 CST 2026