Oracle data link创建

SELECT * FROM DBA_DB_LINKS;

drop public database link DL_AGG_TDM;

create public database link DL206_YSB connect to AGG_TDM identified by "T_agg_tdm_3e!Q" using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.4.6)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ora06AA)))';

create public database link DL_AGG_TDM connect to AGG_TDM identified by "T_agg_tdm_3e!Q" using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.4.6)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ora06AA)))';

create public database link DL203_YHB connect to Y_HB identified by "yhbjq_1@3$QwEr" using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.4.2)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ora02AA)))';

ora06

drop public database link DL203_JZT001;
drop public database link DL203_JZT001_DAT_TDM;
create public database link DL203_JZT001 connect to JZT001 identified by "jzt001" using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.4.2)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ora02AA)))';
create public database link DL203_JZT001_DAT_TDM connect to JZT001 identified by "jzt001" using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.4.2)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ora02AA)))';

drop public database link DL2011_T_ORDER;
create public database link DL2011_T_ORDER connect to T_ORDER identified by "Order2w!Q" using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.4.8)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ora11AA)))';

drop public database link DL203_YHB_READ;
create public database link DL203_YHB_READ connect to Y_HB identified by "yhbjq_1@3$QwEr" using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.4.2)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ora02AA)))';