Click here to Skip to main content
15,891,136 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.

CSS
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.
Posted

1 solution

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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900