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.
...
No Format | ||
---|---|---|
| ||
set *.APPLY_COLUMN_NAMES_MAP coumn1=newcolumn1[,column2=newcolumn2[,...]] |
Example:
No Format | ||
---|---|---|
| ||
set *.APPLY_COLUMN_NAMES_MAP COMMENT=COMMENT_COLUMN |
...
After restart, APPLY process log will show column mapping details as follow.
No Format |
---|
0132015/0512/03 05:34:37 INFO> Column translate: [COMMENT]=>[COMMENT_COLUMN] |