Tuesday, April 16, 2013

Drop Database Link in another schema .

We can drop Database link in another schema by a simple procedure without knowing password of the user

SQL> conn / as sysdba
SQL> create or replace procedure schema.procedurename as
execute immediate  ‘drop database link  db_link_name’;
end procedurename;

SQL>exec Procedurename;

No comments:

Post a Comment