sys.sp_changearticlecolumndatatype

Description

Changes the article column data type mapping for an Oracle publication. This stored procedure is executed at the Distributor on any database.

Syntax

sp_changearticlecolumndatatype

Permissions

is used to override the default data type mappings between supported Publisher types (Oracle and SQL Server). To view these default data type mappings, execute sp_getdefaultdatatypemapping. is only supported for Oracle Publishers. Executing this stored procedure against a SQL Server publication results in an error. must be executed for each article column mapping that must be changed. Only members of the fixed server role or fixed database role can execute. Change Publication and Article Properties Data Type Mapping for Oracle Publishers Replication stored procedures (Transact-SQL)