ITPub博客

首页 > Linux操作系统 > Linux操作系统 > goldengate(12)

goldengate(12)

原创 Linux操作系统 作者:www_xylove 时间:2013-03-17 13:08:15 0 删除 编辑

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/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: goldengate(11)
下一篇: goldengate(13)
请登录后发表评论 登录
全部评论

注册时间:2010-11-12

  • 博文量
    100
  • 访问量
    233034