Oracle使用代理模式创建db链接 [英] Oracle create db link using a proxy schema

问题描述

所以我想在oracle创建数据库链接，我的用户名是jefferson，我想连接槽opms所以我被告知这样做。

So I want to create a database link in oracle, my username is jefferson and I want to connect trough opms so I was told to do this.

create  database link  tmpp connect to jefferson[opms] identified by nothing using $something ;

由于某些原因，当我尝试使用[]语法时，它只是告诉我识别缺失。为什么这不工作，我被告知这样做，但我找不到任何帮助官方文档中的[]使用或正确的语法。

For some reason when I try to use [] syntax it just tells me indentified is missing. Why is this not working, I was told to do it this way but I can't find any help in the official documentation for [] usage or the correct syntax.

推荐答案

您可以像这样创建固定用户数据库链接，但是您需要将整个代理用户标识符包含在双报价因为它现在是一个带引号的标识符，该案例必须匹配DBA_USERS用户名，默认大写：

You can create a fixed-user database link like this, but you need to enclose the entire proxy user identifier in double-quotes; and because it's now a quoted identifier the case has to match the DBA_USERS username, which is uppercase by default:

create database link tmpp connect to "JEFFERSON[OPMS]" identified by nothing using ... ;

如MOS文档1477939.1中所述，您无法创建连接用户数据库链接't试图做）;和标识符的30个字符限制，因此，两个用户名加上方括号的总长度必须为30个字符或更少（这在您的示例中也很好）。

As noted in MOS document 1477939.1 you can't create a connected-user database link (which you aren't trying to do); and the 30-character limit on identifiers applies, so the total length of both usernames plus the square brackets has to be 30 characters or less (which is also fine in your example).

但是，如此相关问题中所述，此功能目前在11.2.0.4及更高版本中已损坏，因为错误19191702。

However, as discussed in this related question, this functionality is currently broken in 11.2.0.4 and above because of bug 19191702.

这篇关于Oracle使用代理模式创建db链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！