ora-02069
通过db-link对远程数据库的一张表进行insert操做，报2069错误
补充一下，插入的值中包括本地的一个sequence
----------------------------------------------------------------------------------------
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.
Did u do that already?
---------------------------------------------------------------------------------------
sequence 后加上dblink ,如
insert into tab@dblink select seq1.nextval@dblink, col1, col2 from tab2
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13165828/viewspace-606028/ ，如需转载，请注明出处，否则将追究法律责任。
