Change in Database link – 11gR2

A little change in dblink from 11gR2 - SQL> conn anand/anand123 Connected. SQL> SQL> @db_link OWNER DB_LINK USERNAME HOST ------------------------------ ------------------------------ ------------------------------ ------------------------------ ANAND SCOTT_DBLINK SCOTT MATSTDBY SQL> select sysdate from dual@SCOTT_DBLINK; SYSDATE --------- 11-MAY-12 I login as sys and change scott schema's password - SQL> conn / as sysdba Connected. SQL> SQL> SQL> SQL> … Continue reading Change in Database link – 11gR2

Advertisement