分布式数据库:dblink
Jun 07, 2016 pm 05:21 PMdblink是数据库对象、允许你访问远程表及执行远程程序、另外、dblink是单向连接、创建dblink时、oracle在数据字典记录其元数据.在
dblink是数据库对象、允许你访问远程表及执行远程程序、另外、dblink是单向连接、创建dblink时、Oracle在数据字典记录其元数据.
在db link时,,必须关心一下global_name.这个缺省下,是作为网络服务名对外提供服务的。但大部分我们是不用的。
global_names参数并不是用来控制global_name的,而是用来限制dblink的使用.global_names参数的作用,简单得说来就是:当global_names参数设置为TRUE时,使用dblink的名称必须与被连接库的GLOBAL_NAME一致。
dblink共有3类:用户级、数据库级、网络级
public的指定与否:
dblink远程数据库用户验证方法:
创建举例:

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How does Go language implement the addition, deletion, modification and query operations of the database?

Detailed tutorial on establishing a database connection using MySQLi in PHP

iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos

How does Hibernate implement polymorphic mapping?

An in-depth analysis of how HTML reads the database

Analysis of the basic principles of MySQL database management system

Tips and practices for handling Chinese garbled characters in databases with PHP

How does Go WebSocket integrate with databases?
