streams复制出错，高手请进！

显示全部楼层 · 2005-4-5 09:18:50

ＤＢ：oracle10.2.0.1
ＯＳ：redhat,64位
出错如下：
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(
schema_name=> 'mgmt',
streams_type => 'capture',
streams_name => 'capture_mgmt',
queue_name => 'strmadmin.captured_vipbill',
include_dml=> true,
include_ddl=> true,
inclusion_rule => true);
END;
ORA-32593: 流量中的数据库补充事件记录属性
ORA-06512: 在 "SYS.DBMS_STREAMS_ADM_UTL_INVOK", line 289
ORA-06512: 在 "SYS.DBMS_STREAMS_ADM", line 439
ORA-06512: 在 "SYS.DBMS_STREAMS_ADM", line 397
ORA-06512: 在 line 2
有没有人遇到过？

千问 · 2005-4-5 09:18:50

streams复制没用过，帮你顶一下！

千问 · 2005-4-5 09:18:50

最初由 dbablog 发布
[B]streams复制没用过，帮你顶一下！ [/B]
多谢这么ＰＰ的ＭＭ帮我顶．

千问 · 2005-4-5 09:18:50

http://www.zlsoft.com/techbbs/dispbbs.asp?boardid=3&id=24976

千问 · 2005-4-5 09:18:50

xzh2000
老大，不会吧，我等了n久了，还是不行啊

千问 · 2005-4-5 09:18:50

14:18:37 SQL> BEGIN
14:20:18 2DBMS_STREAMS_ADM.ADD_TABLE_RULES(
14:20:18 3table_name => 'demo.tt',
14:20:18 4streams_type => 'capture',
14:20:18 5streams_name => 'strm_capture',
14:20:18 6queue_name => 'demo.strm_queue',
14:20:18 7include_dml => true,
14:20:18 8include_ddl => true,
14:20:18 9include_tagged_lcr => false,
14:20:1810source_database => NULL,
14:20:1811inclusion_rule => true);
14:20:1812END;
14:20:1813/
BEGIN
*
ERROR at line 1:
ORA-32593: database supplemental logging attributes in flux
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 312
ORA-06512: at line 2

14:20:20 SQL>

千问 · 2005-4-5 09:18:50

select SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL,SUPPLEMENTAL_LOG_DATA_MIN from v$database;
你要执行以下操作:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;

千问 · 2005-4-5 09:18:50

谢谢， xzh2000 老大，我试试看。

千问 · 2005-4-5 09:18:50

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMN
S;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS
*
ERROR at line 1:
ORA-32593: database supplemental logging attributes in flux
我执行了，但是出来错误！

千问 · 2005-4-5 09:18:50

SQL> select SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL,SUPPLEMENTAL_LOG_
DATA_MIN from v$database;
SUP SUP SUPPLEME
--- --- --------
NONONO