当前位置:主页 >raybet雷电竞官网

raybet雷电竞官网_一起听吧进入

发布时间:02月11日 阅读:676



一、创建远程数据库连接

create database lraybet雷电竞官网iraybet雷电竞官网nk MDM

connect to MDMidentified by mdm

using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =raybet雷电竞官网 (PROTOCOL = TCP)(Host = 172.17.11.1)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SID= MDM)))';

二、创建两个归天视图:

CREATE MATERIALIZED VIEW DEPARTMENT

TABLESPACE DAT_ICNFUSING INDEX

TABLESPACE IDX_ICNFREFRESH FORCE ON DEMAND

AS SELECT * FROM MDM.DEPARTMENT@MDM WHERE TREELEVEL = 1 AND STATUS = '0';

CREATE MATERIALIZED VIEW EMPLOYEE

TABLESPACE DAT_ICNFUSING INDEX

TABLEraybet雷电竞官网SPACE IDX_ICNFREFRESH FORCE ON DEMAND

AS SELECT * FROM MDM.EMPLOYEE@MDM WHERESTATUS = '0';

三、创建刷新组

execute DBMS_REFRESH.MAKE(NAME=>'MVTAGraybet雷电竞官网', LIST=>'DEPARTMENT,EMPLOYEE', NEXT_DATE=>SYSDATE, INTERVAL=>'/*24:HR*/ SYSDATE + 5/(60*24)');

commit;

四、删除刷新组

--execute dbms_refresh.destroy('MVTAG');

--commit;



上一篇:全天候网络竞技app下载_一起听吧进入
下一篇:牛竞技电牛竞技电竞_一起听吧进入