问题：
物化视图问题:
物化视图复制的设置
主站点：db001.d-link
物化视图站点：db002.d-link
主机名：dbmis
复制用户：dev001
检查初始化参数
SQL> connect sys/change_on_install@db001.d-link as sysdba ;
已连接。
SQL> show parameter global_names ;
NAME TYPE VALUE
------------------------------------ ----------- -------------------------
global_names boolean TRUE
SQL> show parameter job;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 20
SQL> select * from global_name ;
GLOBAL_NAME
------------------------------------------------------------------------------
DB001.d-link
SQL>
SQL> connect sys/change_on_install@db002.d-link as sysdba ;
已连接。
SQL> show parameter global_names ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean TRUE
SQL> show parameter job;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 10
SQL> select * from global_name ;
GLOBAL_NAME
-----------------------------------------
DB002.d-link
SQL>
检查全局数据库名称
SQL> connect dev001/whoami@db002.d-link ;
已连接。
SQL> select * from dev001.test001@db001 ;
A B
---------- ----------
1 wui
2 zyun
SQL>
SQL> connect sys/change_on_install@db002.d-link as sysdba ;
已连接。
SQL> select owner,db_link from all_db_links ;
OWNER DB_LINK
-------------------- --------------------
SYS DB001.d-link
PUBLIC DB001.d-link
SQL> connect sys/change_on_install@db001.d-link as sysdba ;
已连接。
SQL> select owner,db_link from all_db_links ;
OWNER DB_LINK
-------------------- --------------------
SYS DB002.d-link
PUBLIC DB002.d-link
SQL> |
