如何建立可更新的物化视图
环境 RAC和单实例建立可更新的物化视图 SQL> select * from gv$version; INST_ID BANNER ---------- ---------------------------------------------------------------- 2 Oracle Database 10g Enterprise Edition Release 10。 2。0。4。0 - 64bi 2 PL/SQL Release 10。2。0。4。0 - Production 2 CORE 10。2。0。4。0 Production 2 T...全部
环境 RAC和单实例建立可更新的物化视图 SQL> select * from gv$version; INST_ID BANNER ---------- ---------------------------------------------------------------- 2 Oracle Database 10g Enterprise Edition Release 10。
2。0。4。0 - 64bi 2 PL/SQL Release 10。2。0。4。0 - Production 2 CORE 10。2。0。4。0 Production 2 TNS for IBM/AIX RISC System/6000: Version 10。
2。0。4。0 - Productio 2 NLSRTL Version 10。2。0。4。0 - Production 1 Oracle Database 10g Enterprise Edition Release 10。
2。0。4。0 - 64bi 1 PL/SQL Release 10。2。0。4。0 - Production 1 CORE 10。2。0。4。0 Production 1 TNS for IBM/AIX RISC System/6000: Version 10。
2。0。4。0 - Productio 1 NLSRTL Version 10。2。0。4。0 - Production SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10。
2。0。4。0 - Prod PL/SQL Release 10。2。0。4。0 - Production CORE 10。2。0。4。0 Production TNS for Linux: Version 10。
2。0。4。0 - Production NLSRTL Version 10。2。0。4。0 - Production 1。配置复制管理用户repadmin(所有节点) create user repadmin identified by repadmin; execute dbms_defer_sys。
register_propagator('repadmin'); grant execute any procedure to repadmin; execute dbms_repcat_admin。
grant_admin_any_repgroup('repadmin'); execute dbms_repcat_admin。grant_admin_any_schema(username => '"REPADMIN"'); grant comment any table to repadmin; grant lock any table to repadmin; grant select any dictionary to repadmin; 2。
启用global_name(所有节点) alter system set global_names=true scope=spfile; alter system set db_domain='lab。
com' scope=spfile; alter database rename global_name to gc。lab。com; alter database rename global_name to orcl。
lab。com; select * from global_name; 3。建立dblink(所有节点) ORCL上 CREATE PUBLIC DATABASE LINK "GC。LAB。
COM" CONNECT TO SYSTEM IDENTIFIED BY USING 'GC'; GC上 CREATE PUBLIC DATABASE LINK "ORCL。LAB。
COM" CONNECT TO SYSTEM IDENTIFIED BY USING 'orcl1'; 通过select * from global_name@dblinkname来测试 创建私有database link,用于拉起和停止节点repgroup的状态 repadmin下 ORCL CREATE DATABASE LINK "GC。
LAB。COM" CONNECT TO REPADMIN IDENTIFIED BY ; GC CREATE DATABASE LINK "ORCL。LAB。COM" CONNECT TO REPADMIN IDENTIFIED BY ; 通过select * from global_name@dblinkname来测试 4。
源表上建立materialized view log(ORCL) CREATE MATERIALIZED VIEW LOG ON TEST。BA_ALCCLS NOCACHE LOGGING NOPARALLEL WITH PRIMARY KEY;
完成 丢弃。
收起