八.至此配置完成
1)模拟小数据量测试:
insert into t(id, name) values('1', 'aa'); insert into t(id, name) values('2', 'cc'); |
2)模拟大数据量测试:OK
CREATE OR REPLACE procedure insert_into_t as i number; m NUMBER; n NUMBER; BEGIN n:=0; FOR i IN 1..10000 LOOP m:=i; INSERT INTO t(id, name)VALUES (m, 'cc' || m ); n:=n+1; IF n=1000 THEN COMMIT; n:=0; END IF; END LOOP; COMMIT; END; / |
加表测试
创建表test(id number);
ALTER TABLE test ADD(CONSTRAINT pk_test_id PRIMARY KEY(ID)); |
停止主体定义站点复制
execute dbms_repcat.suspend_master_activity('master_yiliao'); |
在复制组里加入test复制对象:
execute dbms_repcat.create_master_repobject(sname => 'fsws_yiliao', name => 'test', type => 'TABLE', use_existing_object => true, gname => 'master_yiliao', copy_rows => true); |
对复制对象产生复制支持:
execute dbms_repcat.drop_master_repobject(sname => 'fsws_yiliao', name => 'test', type => 'TABLE'); |
重启主体定义站点复制
execute dbms_repcat.resume_master_activity('master_yiliao', true); |
相关阅读:
【福利】填问卷 送2019精选测试大礼包+接口测试实战课程!