Database Link

Database Link

CREATE PUBLIC DATABASE LINK "TO_MPC_N.WORLD"
   CONNECT TO PLAN IDENTIFIED BY "Acelity2016"
   USING '  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = amxd1-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mpcdev_apps)
    )
  )
';
Recreated it again looks like db link has TO_MPC_N.WORLD updated DB link to TO_MPC_N.


resetting DB link password



SQL> alter public database link WHSEPROD.WORLD connect to WHSE_QUERY identified by whsepass;

Database link altered.



CREATE PUBLIC DATABASE LINK "TO_KABAP"
   CONNECT TO ATIME IDENTIFIED BY "ATIME"
   USING '  (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = amxd1-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = KABAQC_APPS)))
';


DROP PUBLIC DATABASE LINK TO_KABAP.WORLD;


DROP PUBLIC DATABASE LINK TO_KABAP;