Although it's a bad practice, Oracle allows the columns to be named arbitrarily using the double-quote syntax. With this, the names can include keywords, lowercase or unicode characters.However, as Replicate does not double-quote the names in the SQL applied to the target, such columns are not supported in replicated tables.
A similar problem occurs when replicating to non-Oracle targets - some of the valid names in Oracle are keywords in other database systems and thus can fail APPLY of changes, too.
...
| No Format | ||
|---|---|---|
| ||
set *.APPLY_COLUMN_NAMES_MAP coumn1=newcolumn1[,column2=newcolumn2[,...]] |
Example:
| No Format | ||
|---|---|---|
| ||
set *.APPLY_COLUMN_NAMES_MAP COMMENT=COMMENT_COLUMN |
...