Oracle Data Accesses other Oracle databases.

Oracle Data Accesses other Oracle databases.

Create a database link in the local oracle database
Drop database link mydblink;
Create database link mydblink connect to zszq identified by "zszq" using '192. 168.0.175: 192/orcl ';

SQL> DROP DATABASE LINK MYDBLINK;

The database link has been deleted.

SQL> create database link mydblink connect to zszq identified by "zszq" using '192. 168.0.175: 192/orcl ';

The database link has been created.

SQL>
Table accessing the remote database
Select * from table name @ mydblink
Example
Select * from table name @ mydblink
Select OP, OP_NAME FROM INV_MESSAGE @ mydblink

SQL> select OP, OP_NAME FROM INV_MESSAGE @ mydblink WHERE ROWNUM <3;

OP OP_NAME
----------------------------------------------------------------------
JZ01 qianna
FH01 Fang Hong

SQL>

Million-level data processing

Timestamp and partition processing. By default, only data in specific regions is displayed, not all.

 

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.