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.