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)))';