Monday, 8 December 2014

oracle database links

[oracle@oralinux ~]$ sqlplus "/as sysdba"

SQL*Plus: Release Production on Mon Dec 8 20:22:22 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;


SONY db is remote database service name, make sure listener services needs to run.
SQL> create database link dblink_sony connect to sony identified by sony using 'SONY';

Database link created.

verify the tables from sony database user and sony database
SQL> select * from dbacentre@dblink_sony;

oracle books
sql books


Popular Posts