This content has been marked as final. Show 2 replies
Please note the difference between v$dblink & dba_db_links is as follows:
V$DBLINK:This view describes all database links (links with IN_TRANSACTION = YES) opened by the session issuing the query on V$DBLINK
DBA_DB_LINKS:DBA_DB_LINKS describes all database links in the database. Its columns are the same as those in ALL_DB_LINKS.
You also can use user_db_links to list the database links created by normal user. And drop privileges are not required to drop the user created objects, because if you have privileges to create the object then you can drop that object without any additional privileges.