首页 > Linux操作系统 > Linux操作系统 > goldengate(12)
goldengate(12)-goldengate在数据库对象与列上使用非字母字符的支持与不支持
1.Supported characters(支持以下非字母字符在对象与列上,但是不包括主键列)
Supported non-alphanumeric characters in object names and non-key column names
non-key column names,它有一些注释:
The type of key that is being used by GoldenGate depends on the definition of a given table and whether there are any overrides
by means of a KEYCOLS clause. GoldenGate will use a primary key, if available, or a unique key/index (selection is dependent
on the database). In the absence of those definitions, all columns of the table are used, but a KEYCOLS clause overrides all existing
key types. For columns that are being used by GoldenGate as a key, the characters in the names must be valid for inclusion
in a WHERE clause. This list is all-inclusive; a given database platform. may or may not support all listed characters.
Character Description
~ Tilde (波浪线)
< > Greater-than and less-than symbols(大于小于符号)
/ Forward slash(前斜杠)
\ Backward slash(后斜杠)
! Exclamation point(感叹号)
@ At symbol(@符号)
# Pound symbol(井符号)
$ Dollar symbol(美元符号)
% Percent symbol(百分符号号)
^ Carot symbol(跳脱符号)
( ) Open and close parentheses(括符号)
_ Underscore(下横线)
- Dash(破折号)
+ Plus sign(加符号)
= Equal symbol(等于符号)
| Pipe(管线)
[ ] Begin and end brackets(中括号)
{ } Begin and end curly brackets (braces)(大括号)
2. Non-supported characters(下面的非字母字符不支持在对象与列上)
GoldenGate does not support the following characters in object or column names:
Character Description
& Ampersand (and符号)
* Asterisk (星号)
? Question mark(问号)
: Colon (冒号)
; Semi-colon(分号)
, Comma(逗号)
‘ ’ Single quotes(单引号)
“ ” Double quotes(双引号)
‘ Accent mark (Diacritical mark)(重音符号)
. Period(点好)
Space (空格)
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/21266384/viewspace-756330/ ,如需转载,请注明出处,否则将追究法律责任。