我在做流复制的表转换测试,
源表t11,目的表t11_19
表结构一致.
配置应该没有问题
SQL> SELECT RULE_NAME,
2 TRANSFORM_TYPE,
3 FROM_SCHEMA_NAME,
4 TO_SCHEMA_NAME,
5 FROM_TABLE_NAME,
6 TO_TABLE_NAME
7 from DBA_STREAMS_TRANSFORMATIONS@stream19;
RULE_NAME TRANSFORM_TYPE FROM_SCHEMA_NAME TO_SCHEMA_NAME FROM_TABLE_NAME TO_TABLE_NAME
------------------------------ -------------------------- ------------------------------ ------------------------------ ------------------------------
T11_1934 DECLARATIVE TRANSFORMATION TEST TEST T11 T11_19
capture,propagation和apply均无报错.但数据就是同步不过去.想问一下,如何查看问题出在哪?
我又试了另外一用方法:
CREATE OR REPLACE PROCEDURE rename_table_t11(in_any in sys.anydata) IS
lcr SYS.LCR$_ROW_RECORD;
rc PLS_INTEGER;
BEGIN
IF lcr.get_object_owner() = 'TEST' AND lcr.get_object_name() = 'T11' THEN
lcr.set_object_name('T11_19');
LCR.EXECUTE(TRUE);
END IF;
END;
/
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER
(object_name => 'TEST.T11',
object_type => 'TABLE',
operation_name => 'INSERT',
error_handler => FALSE,
user_procedure => 'STRMADMIN.RENAME_TABLE_T11',
apply_database_link=> NULL);
END;
/
也是同样不能进行复制.问题在哪?
源表t11,目的表t11_19
表结构一致.
配置应该没有问题
SQL> SELECT RULE_NAME,
2 TRANSFORM_TYPE,
3 FROM_SCHEMA_NAME,
4 TO_SCHEMA_NAME,
5 FROM_TABLE_NAME,
6 TO_TABLE_NAME
7 from DBA_STREAMS_TRANSFORMATIONS@stream19;
RULE_NAME TRANSFORM_TYPE FROM_SCHEMA_NAME TO_SCHEMA_NAME FROM_TABLE_NAME TO_TABLE_NAME
------------------------------ -------------------------- ------------------------------ ------------------------------ ------------------------------
T11_1934 DECLARATIVE TRANSFORMATION TEST TEST T11 T11_19
capture,propagation和apply均无报错.但数据就是同步不过去.想问一下,如何查看问题出在哪?
我又试了另外一用方法:
CREATE OR REPLACE PROCEDURE rename_table_t11(in_any in sys.anydata) IS
lcr SYS.LCR$_ROW_RECORD;
rc PLS_INTEGER;
BEGIN
IF lcr.get_object_owner() = 'TEST' AND lcr.get_object_name() = 'T11' THEN
lcr.set_object_name('T11_19');
LCR.EXECUTE(TRUE);
END IF;
END;
/
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER
(object_name => 'TEST.T11',
object_type => 'TABLE',
operation_name => 'INSERT',
error_handler => FALSE,
user_procedure => 'STRMADMIN.RENAME_TABLE_T11',
apply_database_link=> NULL);
END;
/
也是同样不能进行复制.问题在哪?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9375/viewspace-555157/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9375/viewspace-555157/