当前位置： 首页 >
DB LINK
-
ORA-02019 connection description for remote database not found错误
Jul282016近期有一个项目要上线，开发人员在测试生产数据库的用户是否满足需求时，遇到了ORA-02019错误。 SQL> select * 2 from (select m.brd_pgm_schd_id || d.brd_pgm_schd_seq as adv_id, 3 m.brd_bgn_dtm as ymd, 4 m.brd_cl_dtm as eymd, 5 (case 6 when m.use_yn = 'Y' then 7 1 8 ...
阅读全文抢沙发
-
使用DBLINK跨库查询遇到ORA-01861,ORA-02063错误
Jul212016开发人员在备库使用DB LINK跨库查询时遇到ORA-01861和ORA-02063错误。 SQL> with RST_WMS AS 2 -- T_WH_NO REP_NO REP_NUM WMS_NO F_WH_NO SY_RESOURCE SKU YQ_QTY QTY GB_LVL 3 (SELECT a.ERP单号 as REP_NO, 4 a.ERP行号 as REP_NUM, 5 a.WMS单号 as WH_NO, 6 a.WMS行号 as WMS_NUM, ...
阅读全文