DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Tuesday, July 5, 2016

Steps to drop a private database link

Steps to drop a private database link

Below is a step to drop a private database link.

As sys user create the following procedure under the schema from which database link has to be dropped

CREATE PROCEDURE schema.drop_db_link AS
EXECUTE IMMEDIATE 'drop database link db_link_name';
END drop_db_link;


Now execute the procedure

exec schema.drop_db_link;

Now the database link of the schema is dropped.

You can check using the below query

select owner,db_link,to_char(created,'dd-mon-yyyy:hh24:mm:ss') from dba_db_links 
where owner='&schema_name';

Now drop the procedure

drop procedure schema.drop_db_link;

Hope this helps ...

No comments: