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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
