Use the @TOKEN
function to retrieve token data that is stored in the user token area of the Oracle GoldenGate record header. You can map token data to a target column by using @TOKEN
in the source expression of a COLMAP
clause. As an alternative, you can use @TOKEN
within a SQLEXEC
statement, an Oracle GoldenGate macro, or a user exit.
To define token data, use the TOKENS
clause of the TABLE
parameter in the Extract parameter file. For more information about using tokens, see Administering Oracle GoldenGate.
Syntax
@TOKEN ('token')
Example
In the following example, 10 tokens are mapped to target columns.
MAP ora.oratest, TARGET ora.rpt, COLMAP ( host = @token ('tk_host'), gg_group = @token ('tk_group'), osuser = @token ('tk_osuser'), domain = @token ('tk_domain'), ba_ind = @token ('tk_ba_ind'), commit_ts = @token ('tk_commit_ts'), pos = @token ('tk_pos'), rba = @token ('tk_rba'), tablename = @token ('tk_table'), optype = @token ('tk_optype') );