Oracle Database Discussions

Hey gurus

i want to drop a dtabase link and recreate it

but when i select it
as

select Object_name,owner from dba_objects where object_type='DATABASE LINK';
OBJECT_NAME OWNER
-------------------------------------------------------------------------------- ------------------------------
PROD1_LINK PROD1_OWNER
PROD2_LINK PROD2_OWNER


but when i'm trying to drop it

drop DATABASE LINK PROD2_OWNER.PROD2_LINK

ORA-02024: database link not found

or
drop DATABASE LINK PROD2_LINK
ORA-02024: database link not found

what's reason behind this

i want to recreate prod2_linik so that it should point to new database

please suggest

Thanks