Oracle-L: RE: shareplex core dumps

From: Cunningham, Gerald <Gerald.Cunningham_at_usi.net>
Date: Thu, 07 Nov 2002 10:15:15 -0800
Message-ID: <F001.004FE11C.20021107101515@fatcity.com>

Sounds like a bug.

If SharePlex gets an error applying SQL to the target, the table should get marked out-of-sync and Shareplex should go on it's merry way.

Call Shareplex Support - they are usually very responsive.

Jerry

-----Original Message-----
Sent: Thursday, November 07, 2002 11:35 AM To: Multiple recipients of list ORACLE-L

Hi all,

We are having a shareplex issue and I am hoping someone here with shareplex knowledge can help me out. I don't know much about shareplex. Basically we are replicating to a target table which is partitioned by date. And partitions that are 3 days old will be set to read-only because there are not suppose to be anything new. But occasionally, some record with timestamp older than 3 days creep up, so of course shareplex couldn't put the record into the target partition because it's read-only.

Now the problem is shareplex core dumps when this happens. I am very surprised that we couldn't have a rule that tells shareplex if you can't replicate then either discard the record or put it elsewhere. Core dump seems to be a extreme reaction to this. unfortunately this is hosted and ran by a hosting company and I have no shareplex here to test or verify.

Any help is appreciated.

Thanks

Richard

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ji, Richard
INET: Richard.Ji_at_MobileSpring.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Cunningham, Gerald
INET: Gerald.Cunningham_at_usi.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

RE: shareplex core dumps - help