Steps to create db link in other schema
Below is a method to create
private database link in other schema
private database link in other schema
As sys user create the
following procedure under the schema for which database link has to created
following procedure under the schema for which database link has to created
CREATE PROCEDURE
schema.create_db_link AS
schema.create_db_link AS
BEGIN
EXECUTE IMMEDIATE ‘CREATE DATABASE LINK
database_link_name ‘
database_link_name ‘
||’CONNECT TO USER_name IDENTIFIED
BY password ‘
BY password ‘
||’USING ”tns_name_for
target_db”’;
target_db”’;
END create_db_link;
/
now execute the procedure as
below,
below,
exec schema.create_db_link;
the required database link is created under the schema.
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 we can drop the procedure.
drop procedure
schema.create_db_link;
schema.create_db_link;
Hope this helps …
Recommended Posts