INSERT INTO a@ora156
SELECT seq_sysalert_id.NEXTVAL,
'15098727782' AS MSISDN,
'0' AS MSTYPE,
'sfafs' AS MSMESSAGE,
'0' AS MSFLAG
FROM DUAL;
抛出错误码为ORA-02069 ,错误解释如下:ORA-02069 global_names parameter must be set to TRUE for this operation
Cause: A remote mapping of the statement is required but cannot be achieved because GLOBAL_NAMES should be set to TRUE for it to be achieved.
Action: Issue ALTER SESSION SET GLOBAL_NAMES = TRUE if possible
实际引发错误的原因并非如此,执行以上语句没有作用,而是因为插入的表是远程数据库的表,
而序列不是远程数据库的序列,这时需要将序列后面也添加远程标识,修改为如下即可:
INSERT INTO a@ora156
SELECT seq_sysalert_id.NEXTVAL@ora156,
'15098727782' AS MSISDN,
'0' AS MSTYPE,
'sfafs' AS MSMESSAGE,
'0' AS MSFLAG
FROM DUAL;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25057232/viewspace-749757/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25057232/viewspace-749757/