Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Droping database link

512269Jun 26 2006 — edited Jun 29 2006

Hi,

I am getting problem in deleting a private database link .It was created long back in 2002 and now we have to delete it for security reasons.The dba_db_links saying that the link owner is pmuser.The link doesnot appended with domain name when i use select db_link from user_db_links;
DB_link
----------
pmlink

When i login to pmuser and try to delete using

drop database link pmlink ;

ORA-02024: database link not found

Please help me out.I read all discussions and tried to do but no use.

Anand

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2006

Added on Jun 26 2006

#general-database-discussions

21 comments

951 views