Oracle Database Discussions

I'm having trouble dropping a database link. In SQLPlus I get:

SQL> SELECT db_link FROM USER_DB_LINKS where db_link like 'PROD%';

DB_LINK
-----------------------------------------------------------------
PROD.CBS.STATE.OR.US
PROD.CBS.STATE.OR.US
PROD_DB.CBS.STATE.OR.US
PROD_RI.CBS.STATE.OR.US

SQL> drop database link PROD_RI.CBS.STATE.OR.US;
drop database link PROD_RI.CBS.STATE.OR.US
*
ERROR at line 1:
ORA-02084: database name is missing a component

This is the method identified in the 10g manual: http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10739/ds_admin.htm#sthref3729

When I try to drop the same link using OEM, I get the message:

ORA-02024: database link not found

In the case of OEM, I'm logging on as a different user then the owner of the link. In the case of SQLPlus, I get the same error whether or not I'm logged in as the owner of the db link, or myself.

Thanks,
Chuck