GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Using wildcard for MAP (MAP USR.T*, TARGET USR.*) with NOHANDLECOLLISIONS but need to run handlesoll

edited Nov 22, 2013 4:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
 Using wildcard for MAP (MAP USR.T*, TARGET USR.*) with NOHANDLECOLLISIONS. Needing to run HANDLECOLLISIONS on 1 table which falls under the tables in USR.T* .
Is this possible in the same parameter file?

The way I think it would be is to have a MAPEXCLUDE USR.TABLENAME for the table i want excluded from the MAP USR.T* and then after the MAP USR.T* I would put the MAP USR.TABLENAME ,TARGET USR.* , HANDLECOLLISIONS ;

Thanks for any help.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center