To test / create the db link in another db user schema
following procedure can be used.
create or replace procedure tst_user.dblink
is
begin
execute immediate 'create database link tstdb2devdb
connect to dev_user identified by *********
using ''devdb_tns''';
end;
/
