O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

User tokens

User tokens are GoldenGate environment variables that are captured and stored in the trail record for replication. They can be accessed via the @GETENV function which we have already touched upon the @GETENV function in the previous section, Using and Defining macros. You can use token data in column maps, stored procedures called by SQLEXEC, and of course macros.

A vast array of user tokens exists, too many to list in this book. You can use the TOKENS option of the Extract TABLE parameter to define a user token and associate it with GoldenGate environment data. For example:

TABLE SRC.CREDITCARD_ACCOUNTS, & TOKENS (TKN_OSUSER = @GETENV("GGENVIRONMENT","OSUSERNAME"), & TKN_DBNAME = @GETENV ("DBENVIRONMENT","DBNAME"), & TKN_HOSTNAME = ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required