Oracle global_names 删除问题
我正在使用数据库链接在另一个数据库上执行 DELETE 语句，但数据库链接名称不符合全局命名，并且此要求无法更改。 另外，我将 global_names 设置为 false，并且也无法更改。
但是，当我尝试使用这些链接时，我收到：
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)
当无法设置 global_names=true 时，替代操作是什么？
干杯，
让
I'm using a database link to execute a DELETE statement on another DB, but the DB link name doesn't conform to global naming, and this requirement cannot change.
Also I have global_names set to false, and cannot be changed either.
When I try to use these links however, I receive:
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)
What is the alternative action when setting global_names=true is not possible?
Cheers,
Jean
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
该参数可以在会话级别设置。您能否在会话中将 GLOBAL_NAMES 值设置为 TRUE，执行删除，然后将 if 设置回 FALSE？如果不是，您是否可以为此删除创建一个新连接并将该会话中的 GLOBAL_NAMES 值更新为 true？
That parameter can be set at the session level. Could you not set the GLOBAL_NAMES value equal to TRUE in your session, execute your delete, then set if back to FALSE? If not could you create a new connections just for this delete and update the GLOBAL_NAMES value in that session to be true?
问题在于您的环境中的
GLOBAL_NAMES参数设置为 TRUE。这要求数据库链接与远程数据库的GLOBAL_NAME具有相同的名称。这是一个更全面地描述情况的链接。
The problem is that the
GLOBAL_NAMESparameter is set to TRUE in your environment. That requires that the DB link have the same name as theGLOBAL_NAMEof the remote DB.Here's a link which describes the situation more fully.