如何在Oracle 11G中删除Databselink [英] How Do I Drop Databselink In Oracle 11G

问题描述

我创建了一个名为sapsmc的模式，它具有所有特权，然后我创建了1个数据库链接。现在我想删除该数据库链接，但我无法删除它收到此错误。



SQL错误：ORA-00604：在递归SQL级别1发生错误

ORA-20101：对不起，不能删除任何对象来自实时SAPGateWay数据库的许可。

ORA-06512：第5行

00604. 00000 - 在递归SQL级别％s时发生错误

*原因：处理递归SQL语句时发生错误

（适用于内部字典表的语句）。

*操作：如果下一个错误中描述的情况在堆栈上

可以更正，否则请联系Oracle支持。





然后我试过从SYS用户删除，这样做我得到以下错误。

I have created one schema with the name of sapsmc which has all the privilages, then i have created 1 database link. Now i want to drop that database link,but i can not able to drop it getting this error.

"SQL Error: ORA-00604: error occurred at recursive SQL level 1
ORA-20101: Sorry, Cannot drop any object without permission from live SAPGateWay database.
ORA-06512: at line 5
00604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack
can be corrected, do so; otherwise contact Oracle Support.


Then i tried to delete from SYS user, while doing this i got below error.

SQL Error: ORA-02024: database link not found
02024. 00000 -  "database link not found"
*Cause:    Database link to be dropped is not found in dictionary
*Action:   Correct the database link name

请帮助我，我非常感谢您的努力。

Please help me i really appreciate your efforts.

推荐答案

你好Jay，

使用以下链接以用户SYS的形式删除oracle 11g中的数据库链接。

oracle 11g中作为用户sys的数据库链接

< br $>
问候

Smart003

Hi Jay,
use the following link to drop that database link in oracle 11g as user SYS.
dropdatabase link in oracle 11g as user sys

regards
Smart003

这篇关于如何在Oracle 11G中删除Databselink的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！