Results for database link


1 to 20 of 62475 results. Prev  Next
Results per page:   20  | 40 | 60


Database Administrator's Guide, 11g Release 1 (11.1)

Database Administrator's Guide - Contents

ContentsResolution Database Link Restrictions Distributed Database Administration Site Autonomy Distributed … Mechanism Database Link Name Resolution Name Resolution When the Global Database Name Is Complete Name … Specifying Link Types Creating Private Database

Database SQL Language Reference, 11g Release 1 (11.1)

Database SQL Language Reference - Contents

ContentsCONTEXT CREATE CONTROLFILE CREATE DATABASE CREATE DATABASE LINK CREATE DIMENSION CREATE DIRECTORY … CONTEXT DROP DATABASE DROP DATABASE LINK DROP DIMENSION DROP DIRECTORY DROP DISKGROUP DROP FLASHBACK … Conventions What's New in the SQL Language Reference? Oracle Database

Database SQL Language Reference, 11g Release 1 (11.1)

DROP DATABASE LINK

DROP DATABASE LINKPurpose Use the DROP DATABASE LINK statement to remove a database link from the database. See Also … : CREATE DATABASE LINK for information on creating database links Prerequisites A private databaselink must be in

Database Administrator's Guide, 11g Release 1 (11.1)

Transaction Processing in a Distributed System

Database Link Name ResolutionA global object name is an object specified using a database link. The essential components of a … database link with a name that matches the database name specified in the global object name. For … searches for a database link called orders.us.acme.com. The database

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Database Link RestrictionsYou cannot perform the following operations using database links: Grant privileges on remote … referential integrity Grant roles to users in a remote database Obtain nondefault roles on a remote … database. For example, if jane connects to the local database and executes a stored procedure that … uses a fixed

Database SQL Language Reference, 11g Release 1 (11.1)

CREATE DATABASE LINK

CREATE DATABASE LINKPurpose Use the CREATE DATABASE LINK statement to create a database link. A database link is a … Heterogeneous Services. After you have created a database link, you can use it in SQL statements to … DROP DATABASE LINK

Database Administrator's Guide, 11g Release 1 (11.1)

Manually Committing an In-Doubt Transaction: Example

Obtaining Database Role and Database Link Informationlocal account for the database link connection that corresponds to the in-doubt transaction. out Your … node is a client of other servers. Lists the name of the database link that connects to the remote … node. Lists the owner of the database link for the in-doubt transaction. In this

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Database Links

Procedure for Dropping a Public Database LinkConnect to the local database as a user with the DROP PUBLIC DATABASE LINK privilege. For example … selected. Drop the desired link using the DROP PUBLIC DATABASE LINK statement. For example, enter: DROP PUBLIC DATABASE LINK sales.us.oracle.com;

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Database Links

Procedure for Dropping a Private Database Link… Drop the desired link using the DROP DATABASE LINK statement. For example, enter: DROP DATABASE LINK sales.us.oracle.com; … Connect to the local database using SQL*Plus. For example, enter: CONNECT scott@local_db Query

Database Administrator's Guide, 11g Release 1 (11.1)

Managing a Distributed Database: Examples

Example 2: Creating a Public Fixed User Shared Database LinkThe following example connects to the local database as dana and creates a public link to the sales … database (using its net service name sldb ). The link allows a connection to the remote database as … scott and authenticates this user as scott: CONNECT dana@local CREATE SHARED PUBLIC DATABASE

Database Administrator's Guide, 11g Release 1 (11.1)

Managing a Distributed Database: Examples

Example 5: Creating a Public Current User Database Linklink to the sales database (using its net service name sldb ). The following statement creates a public … current user database link: CONNECT bart@local CREATE PUBLIC DATABASE LINK sales.division3.acme.com … user. The consequences of this database link

Database Administrator's Guide, 11g Release 1 (11.1)

Managing a Distributed Database: Examples

Example 4: Creating a Public Connected User Shared Database LinkThe following example connects to the local database as neil and creates a shared, public link to … /password of crazy/horse. The following statement creates a public, connected user, shared database link … : CONNECT neil@local CREATE SHARED PUBLIC DATABASE LINK sales.division3.acme.com

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Database Links

Limiting the Number of Active Database Link Connectionsno distributed transactions are allowed. See Also: Oracle Database Reference for more information about the OPEN_LINKS initialization parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Managing a Distributed Database: Examples

Example 3: Creating a Public Connected User Database LinkThe following example connects to the local database as larry and creates a public link to the … database with the net service name sldb: CONNECT larry@local CREATE PUBLIC DATABASE LINK redwood USING … 'sldb'; Any user connected to the local database can use the redwood database

Database Administrator's Guide, 11g Release 1 (11.1)

Managing a Distributed Database: Examples

Example 1: Creating a Public Fixed User Database Linkdatabase link to database sales for scott. The database is accessed through its net service name sldb … : CONNECT jane@local CREATE PUBLIC DATABASE LINK sales.division3.acme.com CONNECT TO scott IDENTIFIED … use the sales.division3.acme.com database link

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Database Links

Specifying Link UsersA database link defines a communication path from one database to another. When an application uses … a database link to access a remote database, Oracle Database establishes a database session in the … database link,

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Database Links

Specifying Link TypesWhen you create a database link, you must decide who will have access to it. The following sections … describe how to create the three basic types of links: Creating Private Database Links Creating Public Database Links Creating Global Database Links

Database Concepts, 11g Release 1 (11.1)

Glossary

database linkA named schema object that describes a path from one database to another. Database links are … implicitly used when a reference is made to a global object name in a distributed database.

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Database LinksThe central concept in distributed database systems is a database link. A database link is a … Database Links Creation of Database Links: Examples Schema Objects and Database Links Database Link Restrictions … connection

Database Administrator's Guide, 11g Release 1 (11.1)

Viewing Information About Database Links

Determining Which Link Connections Are OpenYou may find it useful to determine which database link connections are currently open in your … . The following views show the database link connections that are currently open in your current … , with one exception: Column Which Views? Description DB_LINK All The name of the database link





Was this page helpful?

Integrated Cloud Applications & Platform Services