r      using '(DESCRIPTION =        (ADDRESS_LIST =        (ADDRESS = (PROTOCOL

= TCP)(HOST = 172.16.10.252)(PORT = 1521))        )        (CONNECT_DATA =

    (SERVICE_NAME = orcl)  )       )'  ;

数据库链接已创建。

SQL> create materialized view mv_yixun refresh fast start with sysdate next sysd

ate+1/24*60  as select * from t_use@conn_yixun;

create materialized view mv_yixun refresh fast start with sysdate next sysdate+1

/24*60  as select * from t_use@conn_yixun

                         *

第 1 行出现错误:

ORA-04052: 在查找远程对象

NEWSPAPER.T_USE@CONN_YIXUN.REGRESS.RDBMS.DEV.US.ORACLE.COM 时出错

ORA-00604: 递归 SQL 级别 1 出现错误

ORA-01017: invalid username/password; logon denied

ORA-02063: 紧接着line (起自 CONN_YIXUN)

er"      using '(DESCRIPTION =        (ADDRESS_LIST =        (ADDRESS = (PROTOCO

L = TCP)(HOST = 172.16.10.252)(PORT = 1521))        )        (CONNECT_DATA =

      (SERVICE_NAME = orcl)  )       )'  ;

数据库链接已创建。

SQL> create materialized view mv_yixun_click refresh fast start with sysdate nex

t sysdate+1/24*60  as select * from t_use@conn_yixun;

实体化视图已创建。