Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Using Database Links


root@venu1> su - oracle
oracle@venu1> cat /etc/oratab
oracle@venu1> export ORACLE_SID=venu
oracle@venu1> sqlplus / as sysdba
SQL> startup
root@venu1> ssh venu2
root@venu2> su - oracle
oracle@venu2> sqlplus / as sysdba
SQL> startup
oracel@venu1> cd $ORACLE_HOME/network/admin
oracle@venu1 admin> ls
oracle@venu1 admin> lsnrctl start listener
oracle@venu1 admin> lsnrctl status listener
oracle@venu2 admin> ls
oracle@venu2 admin> tnsping to_venu
oracle@venu2> export ORACLE_SID=crms
oracle@venu2> sqlplus / as sysdba
SQL> grant connect,resource to u1 identified by u1;
SQL> conn u1/u1
u1> create database link dblink connect to scott identified by tiger using 'to_venu';
u1> conn / as sysdba
SQL> grant create database link to u1;
SQL> conn u1/u1
u1> create database link dblink connect to scott identified by tiger using 'to_venu';
u1> desc user_db_links;
u1> select * from user_db_links;
u1> select * from tab@dblibk;
u1> select * from dept@dblink;
u1> insert into salgrade@dblink select * from salgrade@dblink;
u1> select * from emp@dblink where septno=10;
u1> create synonym dept for dept@dblink;
u1> conn / as sysdba
SQL> grant create synonym to u1;
SQL> conn u1/u1
u1> select * from tab;
u1> create synonym dept for dept@dblink;
u1> select * from tab;

By default, database link is private. If we want to create a public database link we need to specify 'public' while creating a database link.

Related Posts Plugin for WordPress, Blogger...

Flag Counter