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.