goldengate(17)--测试goldengate DDL 复制
示例:
1.DDL复制视图
源端操作:
create
create view gis_test.v_t4 as select * from gis_test.t4;
目标端DDL复制成功
create or replace view gis_test.v_t4 as
select "ID","NAME" from gis_test.t4
/* GOLDENGATE_DDL_REPLICATION */;
源端操作:
drop
drop view gis_test.v_t4;
目的端也是drop掉了.
2. DDL 复制同义词
create synonym gis_test.syn_t5 for gis_test.t4;
目的端成功DDL复制同义词
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21266384/viewspace-756918/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21266384/viewspace-756918/