当然,昵称又引用源表。
Of course, the nicknames in turn refer to the source tables.
有时候,源表中的一行不具有有效的坐标值。
Sometimes, a row in the source table does not have valid coordinate values.
merge语句遵循目标表或源表上的约束。
Merge statements follow the constraints on target or source tables.
更改是通过在源表中创建的触发器完成跟踪的。
Changes are tracked through triggers that are created on the source table.
正如上面提到的,必须假设源表包含纬度和经度值。
As mentioned above, you must assume that the source table contains latitude and longitude values.
源表和目标表使用的XML数据格式必须相同。
XML data formats used by the source and target tables must be the same.
检查错误表就能够方便地查明源表行以及出问题的坐标。
Inspection of the error table conveniently reveals the source row as well as the problematic coordinate.
她选择需要复制的源表并选择Copy,如图25所示。
She selects the source tables to be copied and selects Copy, as shown in Figure 25.
昵称是在联邦数据库内创建的,用于标识数据源表和视图。
Nicknames are created in the federated database to identify data source tables and views.
源表的变更将以xml格式或是其它数据格式发布到消息队列。
Changes from source tables are published in XML format or other data formats to a message queue.
在从源表及目标表读取数据的过程中,LBAC读取访问规则被执行。
LBAC read access rules are enforced while reading from both source and target tables.
对源表的更改或事件从日志中进行捕获,并转换为xml格式的消息。
Changes to source tables, or events, are captured from the log and converted to messages in an XML format.
端到端延时是指从源表发生更新到此更新应用到目标表所经历的时间。
End-to-end latency is the time it takes from the point in time when an update occurs at a source table until that update is applied to the target.
图2总结了本文中代码示例所使用的表结构,假设源表代表水井的位置。
Figure 2 summarizes this for the example I use for the code samples throughout this article, assuming a source table that represents well locations.
Refresh (Snapshot) 把源表的快照复制到目标表。
Refresh (Snapshot) replicates a snapshot of the source table to the target table.
ccd表通过关联的跟踪机制暴露数据,以便准确地描绘源表的事务历史。
CCD tables expose data with an associated tracking mechanism to accurately portray a transactional history of the source table.
第一行标识出要包括在查询结果集中的sql列以及查询中所引用的源表。
The first line identifies the SQL columns to be included in the query result set and the source tables referenced in the query.
但是,用来对表进行初始化的批量复制在一个事务中处理来自源表的所有行。
The bulk copy used to initialize the table, however, processes all rows from the source table in a single transaction.
如果目标表跨多个数据库分区分布,则源表也必须使用相同的分布方法分布。
If the target table is distributed across database partitions, the source table must also be distributed using the same distribution method.
这些表将包含对源表的所有更改,因此小心地留出足够空间以容纳这些更改。
These tables will contain all changes that are made to the source tables, so be careful to allow for enough space to hold the changes.
取决于您的数据库,您可能想要不同的页面大小,它与您的源表页面大小一致。
Depending on your database you may want to have a different page size that matches the page size of your base source tables.
Address和citystatezip列作为源表中其他属性列的示例。
Columns Address and CityStateZip are shown as examples of additional attribute columns in the source table.
ADMIN_MOVE_TABLE将源表中定义的触发器和视图移动到目标表。
ADMIN_MOVE_TABLE moves triggers and views defined on the source table to the target table.
如果需要复制源表中列或行的子集,就使用Sourcechanges控件。
Use the source changes controls if you want to replicate a subset of the source table columns or rows.
对于添加了空间列的源表,命令是相同的,只是表名(可能还有索引名)不一样。
For the single, integrated table, the command is the same except for the table (and optionally the index) name.
源表和目标表使用的表空间的特征(表空间类型、页面大小、范围大小)必须匹配。
Characteristics (table space type, page size, extent size) of the table Spaces used by the source and target tables must match.
源表必须是非分区表,或者是只拥有一个分区且没有已附加或已分离的分区的分区表。
The source table must be a nonpartitioned table or a partitioned table that has only one partition and no attached or detached partitions.
注对于添加了空间列的源表,根本不需要这个触发器;一旦删除了一行,它就消失了。
NOTE in the case of a single, integrated table, this trigger is not needed at all; once a row is deleted, that's it.
这意味着点表中每一行的键值(在这个示例中,由两个列值组成)必须也在源表中存在。
This means that every row in the point table must have a key value (consisting, in this case, of two column values) that must also exist in the source table.
应用推荐