本文详细介绍Oracle中包含复制环境的数据库迁移
PL/SQL 过程已成功完成。
SQL> CREATE MATERIALIZED VIEW
2 YANGTK.T REFRESH FAST WITH PRIMARY KEY
3 AS SELECT * FROM YANGTK.T@RAC1.US.ORACLE.COM;实体化视图已创建。
SQL> CREATE MATERIALIZED VIEW
2 YANGTK.T1 REFRESH FAST WITH PRIMARY KEY
3 AS SELECT * FROM YANGTK.T1@RAC1.US.ORACLE.COM;实体化视图已创建。
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPOBJECT(GNAME => 'REP_GROUP', SNAME => 'YANGTK',
3 ONAME => 'T', TYPE => 'SNAPSHOT', MIN_COMMUNICATION => TRUE);
4 END;
5 /PL/SQL 过程已成功完成。
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPOBJECT(GNAME =>
'REP_GROUP', SNAME => 'YANGTK',
3 ONAME => 'T1', TYPE => 'SNAPSHOT', MIN_COMMUNICATION => TRUE);
4 END;
5 /PL/SQL 过程已成功完成。
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPOBJECT(GNAME =>
'REP_GROUP', SNAME => 'YANGTK',
3 ONAME => 'IND_T1_FID', TYPE => 'INDEX',
MIN_COMMUNICATION => TRUE);
4 END;
5 /PL/SQL 过程已成功完成。
SQL> BEGIN
2 DBMS_REFRESH.ADD(NAME => 'YANGTK.REP_REFRESH',
3 LIST => 'YANGTK.T', LAX => TRUE);
4 END;
5 /
责编：豆豆技术应用
正在加载评论...