--system/manager登陆
create user APPSQUERY
identified by "APPSQUERY"
default tablespace APPS_TS_TX_DATA
temporary tablespace TEMP1
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to APPSQUERY;
grant resource to APPSQUERY;
grant create session to APPSQUERY;
GRANT SELECT ANY TABLE TO APPSQUERY;
grant select any dictionary to APPSQUERY;
--MES
DROP database link ERP_MES_DBLINK.SDGT.COM;
create database link ERP_MES_DBLINK.SDGT.COM
connect to zg_inter identified by "zg_inter"
using ' (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XXX.XXX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZGMES)
)
)';