当前位置: 首页 >
read-only
-
使用DBLINK跨库查询遇到ORA-16000 database open for read-only access错误
Jul272016开发人员在备库使用DB LINK跨库查询时遇到ORA-16000: database open for read-only access错误。 SQL> SELECT A.ERP单号 AS REP_NO, 2 A.SKU AS SKU, 3 A.在途数量 AS QTY, 4 LOTATT08 AS GB_LVL 5 FROM VIEW_EDI_ERP_INVONLINE@WMS A 6 LEFT JOIN DOC_ASN_DETAILS@WMS B 7 ON A.WMS ...
阅读全文抢沙发
-
ORA-04045,ORA-16000 database open for read-only access错误
Jul202016开发人员在备库查询时遇到ORA-16000错误。 SQL> SELECT /* broad-program-product-schedule-mapper.xml | selectGoodsSalesBrdUntPrdPMinOrdSList | han.ji.yul */ 2 M.BRD_PGM_SCHD_ID, 3 M.BRD_BGN_DTM, 4 (SELECT P.BRD_PGM_NM FROM MED_BRD_PGM_M P WHERE P.BRD_PGM_ID = M.BRD_PGM_ID) AS BRD_P ...
阅读全文