使用sys用户创建其他用户下的dblink

--Create other user's dblink
--grant create database link to jy2;
create or replace procedure jy2.createlink 
is
begin
execute immediate 'create database link TO_11G_JY1 connect to jy1 identified by jy1 using ''WINORA''';
end;
/

--create database link using above procedure
exec jy2.createlink;

--Drop other user's dblink
create or replace procedure jy2.droplink 
is
begin
execute immediate 'drop database link TO_11G_JY1';
end;
/

--drop database link using above procedure
exec jy2.droplink;