DATABASE LINK

Create a Database Link.

Syntax:

   CREATE [SHARED][PUBLIC] DATABASE LINK link_name
     [CONNECT TO CURRENT_USER]
        [USING 'connect_string']

   CREATE [SHARED][PUBLIC] DATABASE LINK link_name
      [CONNECT TO user IDENTIFIED BY password]
      [AUTHENTICATED BY user IDENTIFIED BY password]
         [USING 'connect_string']

CREATE Public Database Link SS64 

Connect To scott Identified By demo 

Using test;



SELECT count(*) from table@ss64;