Printing the column mappings added to a publication (printusercolmapping) v7
For SMR only: The printusercolmapping
command prints column data type mapping between the publication and subscription database.
Synopsis
-printusercolmapping <pubname> -repsvrfile <pubsvrfile> [-subname <subname>] [-details]
Parameters
pubname
The name of the publication whose column mappings are displaying.
pubsvrfile
The file containing the publication server login information.
subname
The name of the subscription whose column mappings are displaying. Providing the name allows for the column mappings to be filtered according to the subscription name.
details
Provides additional details about implicit column mappings and internal mapping representation of the column mapping. Implicit column mappings are'nt provided by the user. They are added by default depending on source and target database and their versions. For example, JSON is'nt supported on Oracle database versions 21 and earlier. Memory mapping is referred to as internal mapping in Replication Server.
Examples
The following is an example where -details
isn't included:
$ java -jar edb-repcli.jar -printusercolmapping emp_pub -repsvrfile ~/pubsvrfile.prop Printing user column mapping details... Publication name:Subscription name:User expressions emp_pub:emp_sub:uuidasprimarykey.id=char;public.mapjson.details=varchar2(4000);.*no=numeric;mapjson1..*=clob
The following is an example where -details
is included:
java -jar edb-repcli.jar -printusercolmapping emp_pub -repsvrfile ~/pubsvrfile.prop -details Printing user column mapping details... Publication name:Subscription name:User expressions emp_pub:emp_sub:uuidasprimarykey.id=char;public.mapjson.details=varchar2(4000);.*no=numeric;mapjson1..*=clob Printing implicit column mapping details (Not provided by user)... Publication name:Subscription name:Database incompatible datatype-->Database compatible datatype emp_pub:emp_sub1:json-->varchar Note: Please provide custom column mapping with -customcolmap argument to override implicit mapping. Printing internal column mapping representation... Publication name:Subscription name:Table name:Column name:Source datatype-->Target datatype emp_pub:emp_sub:public.test123:deptbuildno:integer-->number emp_pub:emp_sub:public.test123:deptno:numeric-->number emp_pub:emp_sub1:public.mapjson1:details:json-->varchar emp_pub:emp_sub1:public.mapjson:details:json-->varchar
Note
User provided column data type mappings override implicit column data type mappings when they are present in the same column.
- On this page
- Synopsis
- Parameters
- Examples