RE: alter table shrink space and Golden Gate ?
Date: Fri, 31 Jan 2014 14:50:44 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD30DDA6512_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
In this case its shrinking tables and indexes on both source and target. Yes we use DDL replication.
From: Maaz Anjum [mailto:maazanjum_at_gmail.com]
Sent: Thursday, January 30, 2014 8:08 PM
To: CRISLER, JON A
Cc: ORACLE-L
Subject: Re: alter table shrink space and Golden Gate ?
Are you talking about shrinking the tablespace on the source, target, or both? Are you using DDL replication?
On Thu, Jan 30, 2014 at 6:33 PM, CRISLER, JON A <JC1706_at_att.com<mailto:JC1706_at_att.com>> wrote: In this particular case its 11.2.1.0.5 but we have various versions of 11.2 of GG out there... I am thinking that one way to avoid any issue is to run it against the GG user where any data changes are ignored.
From: Maaz Anjum [mailto:maazanjum_at_gmail.com<mailto:maazanjum_at_gmail.com>]
Sent: Thursday, January 30, 2014 6:29 PM
To: CRISLER, JON A
Cc: ORACLE-L
Subject: Re: alter table shrink space and Golden Gate ?
Could you be a little more specific on the version of GoldenGate between source and target?
On Thu, Jan 30, 2014 at 5:04 PM, CRISLER, JON A <JC1706_at_att.com<mailto:JC1706_at_att.com>> wrote: I am wondering if "alter table shrink space" has any negative impact on Golden Gate replication , or there are any gotchas - concerns beyond the standard docs on shrink space ?
--
A life yet to be lived...
--
A life yet to be lived...
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 31 2014 - 15:50:44 CET