CREATE DATABASE LINK command
PURPOSE:
To create a database link. A database link is an object in the
local database that allows you to access objects on a remote
database or to mount a secondary database in read-only mode. The
remote database can be either an Oracle or a non-Oracle database.
SYNTAX:
CREATE [PUBLIC] DATABASE LINK dblink
[CONNECT TO user IDENTIFIED BY password]
[USING 'connect_string']
where:
PUBLIC
creates a public database link available to all users. If you omit
this option, the database link is private and is available only to
you.
dblink
is the complete or partial name of the database link. For
guidelines for naming database links, see the section Referring to
Objects in Remote Databases.
CONNECT TO user
IDENTIFIED BY password
is the username and password used to connect to the remote database.
If you omit this clause, the database link uses the username and
password of each user who uses the database link.
USING
specifies either:
* the database specification of a remote database
* the specification of a secondary database for a read-only
mount.
For information on specifying remote databases, see the SQL*Net
User's Guide for your specific SQL*Net protocol.
Read-only mounts are only available in Trusted Oracle and can only
be specified for public database links.
PREREQUISITES:
To create a private database link, you must have CREATE DATABASE
LINK system privilege. To create a public database link, you must
have CREATE PUBLIC DATABASE LINK system privilege. Also, you must
have CREATE SESSION privilege on a remote database. SQL*Net must be
installed on both the local and remote databases.
SEE:
CREATE SYNONYM, SELECT
分享到:
相关推荐
Case Study: Developing the Link-State Database 88 Case Study: OSPF Network Evolution and Convergence 95 Configuring Loopback Interfaces 96 Enabling OSPF 96 Verifying OSPF Operation 97 Summary 101 ...
CONNECT username/password@database_link ``` 其中,username是数据库用户名,password是对应的密码,database_link是数据库连接名。 2. **查询数据**: SQL Plus支持标准的SQL查询语句,如`SELECT`,用于从表...
- `CREATE DATABASE LINK foo CONNECT TO scott IDENTIFIED BY tiger USING 'as3';`:创建名为foo的数据库链接,连接至scott用户。 ### 12. 存储过程学习 - **创建存储过程**:使用`CREATE OR REPLACE PROCEDURE`...
create table 表名 (列说明列表); 为基表增加新列命令如下: ALTER TABLE 表名 ADD (列说明列表) 例:为test表增加一列Age,用来存放年龄 sql>alter table test add (Age number(3)); 修改基表列定义...
When you click on a table, it lists all <END><br>38,3a.zip An Inventory System, you can add, edit, sort, find, delete, print, change your password and create a backup of your database<END><br>39,A...
为了在不同的Oracle数据库之间进行数据交互,Oracle引入了数据库链接(Database Link)的概念。数据库链接允许一个Oracle数据库实例访问另一个数据库实例中的数据,使得跨数据库的查询和操作成为可能。此外,同义词...
- Connections > Database Link - context menu and labels not read - SQL Worksheet > tab names not read - SQL Worksheet > Results - not read - SQL Worksheet > Results > Export - reads incorrectly ...
CREATE DATABASE wordpress; GRANT ALL PRIVILEGES ON wordpress.* TO 'wpuser'@'localhost' IDENTIFIED BY 'yourpassword'; FLUSH PRIVILEGES; EXIT; ``` 这里`yourpassword`是你为WordPress数据库用户设置的密码。...
Hence, it becomes possible for the attacker to issue a command to all the nodes, that target a single node (for example, all nodes in the botnet might be commanded by the attacker to send a TCP SYN ...
使用SHOW DATABASES, SHOW TABLES, CREATE DATABASE, CREATE TABLE, DESCRIBE等命令来查看和管理数据库对象。 在VC环境中编程与MySQL交互,我们可以使用MYSQL结构体作为数据库连接句柄。初始化连接后,使用mysql_...
3. **创建数据库**:创建一个名为"mydb"的数据库,输入`create database mydb;`后回车。 4. **选择数据库**:使用`use mydb;`切换到刚创建的数据库。 5. **查看表**:输入`show tables;`以查看当前数据库中的表。...
- **Report Link Designer**:介绍了报告链接设计器的使用方法。 #### 十九、报告生成与依赖性 - **Reporting**:涵盖了报告生成的各种方法。 - **Toad Control Files**:提供了Toad控制文件的使用方法。 - **...
3. **创建数据库**:例如,创建名为“mydb”的数据库,输入`create database mydb;`。 4. **选择数据库**:使用`use mydb;`来切换至刚刚创建的数据库。 5. **显示表**:通过`show tables;`查看当前数据库中的表。 6....
create database mydb; ``` ##### **2.4 选择数据库** 选择刚刚创建的数据库 `mydb` 以便后续操作: ```sql use mydb; ``` ##### **2.5 显示表** 由于是新创建的数据库,因此当前表应该是空的。可以通过 `show ...
create database link test connect to XXX identified by XXX using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.248.54)(PORT=1521))) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=...
DAO.Database and DAO.Databases Members Section 12.9. DAO.Document and DAO.Documents Members Section 12.10. DAO.QueryDef and DAO.QueryDefs Members Section 12.11. DAO.Recordset and DAO.Recordsets...
djmeter.zip A control (with VB Source) that is an implementation of a progress bar<END><br>78,BtnGraphic.zip An OCX someone made that allows you to easily create command buttons on forms,...