The source table must be droppable.
源表必须可删除。
Step 3: Adding the source table to the data flow.
步骤3:将源表添加到数据流。
In the example, the source table is defined as follows.
在这个示例中,源表的定义如下。
Internally, ADMIN_MOVE_TABLE creates a copy of the source table.
从内部来讲,ADMIN_MOVE_TABLE创建了源表的一个副本。
The target table is protected, and the source table is unprotected.
目标表受保护,源表不受保护。
The source table is protected, and the target table is unprotected.
源表受保护,目标表不受保护。
Changes are tracked through triggers that are created on the source table.
更改是通过在源表中创建的触发器完成跟踪的。
Sometimes, a row in the source table does not have valid coordinate values.
有时候,源表中的一行不具有有效的坐标值。
If the source table is large, this may cause an overflow of the logical log.
如果源表很大,那么这可能导致逻辑日志的溢出。
LBAC read access rules are enforced while reading from source table, however.
然而,在从源表读取数据期间,LBAC读取访问规则被执行。
Refresh (Snapshot) replicates a snapshot of the source table to the target table.
Refresh (Snapshot) 把源表的快照复制到目标表。
On the Source Tables page, select the source table that you want to replicate from.
在Source Tables页面上,选择需要进行复制的源表。
ADMIN_MOVE_TABLE moves triggers and views defined on the source table to the target table.
ADMIN_MOVE_TABLE将源表中定义的触发器和视图移动到目标表。
The point table (wells_pts) has a foreign-key relationship with the source table (wells).
点表(wells_pts)和源表(wells)之间有外键关系。
As mentioned above, you must assume that the source table contains latitude and longitude values.
正如上面提到的,必须假设源表包含纬度和经度值。
The source table is either dropped or kept based on one of the ADMIN_MOVE_TABLE input parameters.
根据ADMIN_MOVE_TABLE输入参数之一,源表将被删除或保留。
Use the source changes controls if you want to replicate a subset of the source table columns or rows.
如果需要复制源表中列或行的子集,就使用Sourcechanges控件。
Columns Address and CityStateZip are shown as examples of additional attribute columns in the source table.
Address和citystatezip列作为源表中其他属性列的示例。
If the target table is a multidimensional clustering (MDC) table, the source table must also be an MDC table.
如果目标表是多维集群化(Multidimensional Clustering,mdc)表,则源表也必须是mdc表。
The bulk copy used to initialize the table, however, processes all rows from the source table in a single transaction.
但是,用来对表进行初始化的批量复制在一个事务中处理来自源表的所有行。
Uniqueness in the CCD table must be enforced — either by a primary key or unique index on the source table or CCD table.
ccd表中必须有惟一性约束——可以通过主键或者源表或ccd表上的惟一索引实现。
CCD tables expose data with an associated tracking mechanism to accurately portray a transactional history of the source table.
ccd表通过关联的跟踪机制暴露数据,以便准确地描绘源表的事务历史。
Sybase: If the source table has a column data type of LONG VARCHAR, the nickname is created with a data type of VARCHAR (32672).
Sybase:如果源表具有数据类型为LONGVARCHAR的列,就要用数据类型VARCHAR(32672)创建别名。
With the DECLARE cursor command, a cursor is defined that reads all data of the source table SALES using a trivial SELECT statement.
使用DECLARECURSOR命令定义一个游标,它使用select语句读取源表sales的所有数据。
After copying all rows in table SALES successfully to table SALES_TMP, the source table SALES can be dropped (drop table statement).
在把sales表中的所有行成功地复制到SALES _ tmp表之后,可以删除源表(DROPtable语句)。
The source table must be a nonpartitioned table or a partitioned table that has only one partition and no attached or detached partitions.
源表必须是非分区表,或者是只拥有一个分区且没有已附加或已分离的分区的分区表。
If the target table is distributed across database partitions, the source table must also be distributed using the same distribution method.
如果目标表跨多个数据库分区分布,则源表也必须使用相同的分布方法分布。
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.
端到端延时是指从源表发生更新到此更新应用到目标表所经历的时间。
When either of the coordinate columns in the source table is updated, a new point geometry must be constructed. The update trigger looks like this
当更新源表中的坐标列时,必须构造一个新的点几何值。
应用推荐