GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Using discard alongside exception table

edited Oct 4, 2013 4:28AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
GG: (11.2.1.0.1 & 11.2.1.0.10)OS: RHEL & OEL DB: Replicating between Oracle 10.2.0.4 & Oracle 11.2.0.3
Hi all

We'd like to use both a discard file as well as populating a generic (i.e. one for all replicated tables) exception table whenever REPLICAT has an sql apply problem.

I noticed Doc ID 1137367.1 has something similar but it looks like there is a specific exception table for each table in the replicat?

I have attempted to update the replicat PRM but it abends with 

2013-09-30 09:26:58  ERROR   OGG-00204  Oracle GoldenGate Delivery for Oracle, r99bdmig.prm:  Missing Primary Map Statement for EXCEPTIONSONLY Map specification.
2013-09-30 09:26:58  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, r99bdmig.prm:  PROCESS ABENDING.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center