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
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:
The following is an example where -details
is included:
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