Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

RAO - replicating "truncate table"

2 posts in Replication Agent Last posting was on 2007-09-04 04:54:17.0Z
mpeppler Posted on 2007-07-18 07:17:11.0Z
Sender: 3939.46767b80.1804289383@sybase.com
From: mpeppler@peppler.org
Newsgroups: sybase.public.rep-agent
Subject: RAO - replicating "truncate table"
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <469dbe77.4ead.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jul 2007 00:17:11 -0700
X-Trace: forums-1-dub 1184743031 10.22.241.41 (18 Jul 2007 00:17:11 -0700)
X-Original-Trace: 18 Jul 2007 00:17:11 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:894
Article PK: 862464

Hi,

Does anyone know if it is possible to replicate "truncate
table" from Oracle 9i, and if so how to configure the Oracle
and/or Rep Agent ?

Adding the "subscribe to truncate table" to the subscription
does not appear to do the trick...

Thanks,

Michael


Michael Peppler Posted on 2007-09-04 04:54:17.0Z
From: Michael Peppler <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: RAO - replicating "truncate table"
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2007.09.04.04.54.11.413735@peppler.org>
Newsgroups: sybase.public.rep-agent
References: <469dbe77.4ead.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 185-191.5-85.cust.bluewin.ch
X-Original-NNTP-Posting-Host: 185-191.5-85.cust.bluewin.ch
Date: 3 Sep 2007 21:54:17 -0700
X-Trace: forums-1-dub 1188881657 85.5.191.185 (3 Sep 2007 21:54:17 -0700)
X-Original-Trace: 3 Sep 2007 21:54:17 -0700, 185-191.5-85.cust.bluewin.ch
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:902
Article PK: 862454

FWIW - RAO 15 ESD 2 does indeed replicate the "truncate table" command.

I'm currently applying ESD 3 to help resolve a few bugs, and it appears to
be going pretty well.

Michael

On Wed, 18 Jul 2007 01:17:11 -0700, mpeppler wrote:

> Hi,
>
> Does anyone know if it is possible to replicate "truncate
> table" from Oracle 9i, and if so how to configure the Oracle
> and/or Rep Agent ?
>
> Adding the "subscribe to truncate table" to the subscription
> does not appear to do the trick...
>
> Thanks,
>
> Michael

--
Michael Peppler - Peppler Consulting SaRL
mpeppler@peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html