Search This Blog

Wednesday, 10 December 2025

Create DB link in another db user

 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;

/


No comments:

manage long running sessions with "screen" on linux OS - handy utility for Oracle APPS DBA for cloning, patching etc

  n Oracle E-Business Suite (EBS), there is no standard   -S   flag for the primary cloning commands ( adpreclone.pl   or   adcfgclone.pl )....