You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for database link


1 to 60 of 62480 results. Previous page Prev  Next next page
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

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

Database Links

Global Database Names in Database LinksTo understand how a database link works, you must first understand what a global database name is … . Each database in a distributed database is uniquely identified by its global database name. The … database forms a global database name by prefixing

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

Database Links

Names for Database LinksTypically, a database link has the same name as the global database name of the remote database … the database link is also called sales.us.oracle.com. When you set the initialization parameter … GLOBAL_NAMES to TRUE, the database ensures that the name of the database

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

Database Links

Types of Database LinksOracle Database lets you create private, public, and global database links. These basic link types … USER_DB_LINKS Creates link in a specific schema of the local database. Only the owner of a private database link … or PL/SQL subprograms in the schema can use this link

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

Database Links

Creation of Database Links: ExamplesCreate database links using the CREATE DATABASE LINK statement. The table gives examples of SQL … database: SQL Statement Connects To Database Connects As Link Type CREATE DATABASE LINK … connected user CREATE DATABASE LINK

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

Database Links

Connected User Database Linkslink is that a user referencing the link connects to the remote database as the same user, and … jobs. The ability to use a connected user database link depends on several factors, chief among them … , then the ability to use a connected user link also depends on whether the remote database

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

Database Links

Schema Objects and Database LinksAfter you have created a database link, you can execute SQL statements that access objects on the … remote database. For example, to access remote object emp using database link foo, you can issue … : SELECT * FROM emp@foo; You must also be authorized in the remote database to access

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

Database Links

What Are Database Links?A database link is a pointer that defines a one-way communication path from an Oracle Database … server to another database server. The link pointer is actually defined as an entry in a data dictionary … table. To access the link, you must be connected to the local database

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

Database Links

Synonyms for Schema ObjectsOracle Database lets you create synonyms so that you can hide the database link name from the user … . A synonym allows access to a table on a remote database using the same syntax that you would use to … access a table on a local database. For example, assume you issue the following query against a

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

Database Links

Why Use Database Links?, a local user can access a link to a remote database without having to be a user on the remote … of database link users \"Viewing Information About Database Links\" for an explanation of how to hide passwords from non-administrative users … The great advantage of database links is that

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

Database Links

Fixed User Database LinksA benefit of a fixed user link is that it connects a user in a primary database to a remote … can create a public database link in joe 's schema that specifies the fixed user scott with … password tiger. If jane uses the fixed user link in a query, then jane is the user on the local database

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

Database Links

What Are Shared Database Links?A shared database link is a link between a local server process and the remote database. The linkdatabase is connected to a remote database through a database link, either database can run in dedicated … Shared server

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

Database Links

Current User Database Linksto retrieve data from the hq database. The procedure uses a current user database link, which … current user database link is not accessed from within a stored object, then the current user is … procedure, view, or trigger that accesses a database link, the current user

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

Database Links

Naming of Schema Objects Using Database Links, index, view, synonym, procedure, package, or a database link. global_database_name is the name that … FALSE, in which case any name is acceptable. For example, using a database link to database … .acme.com. For example, you can call the link foo. Then, you can access the remote database

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

Database Links

Users of Database LinksWhen creating the link, you determine which user should connect to the remote database to access … database links: User Type Description Sample Link Creation Syntax Connected user A local user accessing a … database link in which no fixed username and password have been specified. If

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

Database Links

Schema Object Name Resolutionissue the following statements using database link hq.acme.com to access objects in the scott and jane … database forms object names hierarchically. For example, the database guarantees that each schema within a … database has a unique name, and that within a schema each object has a unique name. As

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

Syntax for Schema Objects and Parts in SQL Statements

References to Database Linksa SQL statement that contains a database link, you can specify the database link name in one of … these forms: The complete database link name as stored in the data dictionary, including the database … , domain, and optional connect_descriptor components. The partial

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

Using Shared Database Links

Creating Shared Database LinksTo create a shared database link, use the keyword SHARE D in the CREATE DATABASE LINK statement … : CREATE SHARED DATABASE LINK dblink_name [CONNECT TO username IDENTIFIED BY password]|[CONNECT TO … server processes from clients that masquerade as a database link

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

Managing Database Links

Managing Database LinksThis section contains the following topics: Closing Database Links Dropping Database Links Limiting the Number of Active Database Link Connections

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

Syntax for Schema Objects and Parts in SQL Statements

Creating Database LinksYou create a database link with the statement CREATE DATABASE LINK. The statement lets you specify … this information about the database link: The name of the database link The database connect string … stores this information in the

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

Distributed Database Administration

Authentication Through Database Links: CREATE PUBLIC DATABASE LINK foo USING 'sales'; You create authenticated links by specifying the … CONNECT TO clause, AUTHENTICATED BY clause, or both clauses together in the database link creation … statement. For example, you can issue: CREATE DATABASE LINK sales CONNECT TO scott

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

Managing Database Links

Dropping Database LinksYou can drop a database link just as you can drop a table or view. If the link is private, then it … must be in your schema. If the link is public, then you must have the DROP PUBLIC DATABASE LINK … system privilege. The statement syntax is as follows, where dblink is the name of the

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

Distributed Database Administration

Auditing Database Linksand accesses a remote database through a database link, the local actions are audited in the local … actions of the username--in this case, scott on the hq database--embedded in the link if the desired … use of a database link, although access to remote objects can be

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

Creating Database Links

Creating Public Database LinksTo create a public database link, use the keyword PUBLIC (where link_name is the global database … name or an arbitrary link name): CREATE PUBLIC DATABASE LINK link_name...; Following are examples of … public database links: SQL Statement Result CREATE PUBLIC DATABASE

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

Creating Database Links

Creating Private Database LinksTo create a private database link, specify the following (where link_name is the global database … name or an arbitrary link name): CREATE DATABASE LINK link_name...; Following are examples of private … database links: SQL Statement Result CREATE DATABASE

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

Using Shared Database Links

Using Shared Database LinksEvery application that references a remote server using a standard database link establishes a … connection between the local database and the remote database. Many users running applications … simultaneously can cause a high number of connections between the local and remote databases. Shared database

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

Managing Database Links

Closing Database LinksIf you access a database link in a session, then the link remains open until you close the session … same public link in a local database, then 20 database link connections are open. If 20 users open … sessions and each user accesses a private link,

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

Creating Database Links

Using Connection Qualifiers to Specify Service Names Within Link NamesCreating a Connected User Database Link To create a connected user database link, omit the CONNECT … TO clause. The following syntax creates a connected user database link, where dblink is the name of … the link and net_service_name is an optional connect string: CREATE

Streams Concepts and Administration, 11g Release 1 (11.1)

Managing Oracle Streams Implicit Capture

Specifying Whether Downstream Capture Uses a Database LinkYou specify whether an existing downstream capture process uses a database link to the source … database link, or you set the use_database_link parameter to FALSE to specify that the downstream … capture process does not use a database link. If you want a capture process that is not

Streams Concepts and Administration, 11g Release 1 (11.1)

Monitoring Oracle Streams Queues and Propagations

Displaying the Queues and Database Link for Each Propagationpropagation name The source queue name The database link used by the propagation The destination queue … SOURCE_QUEUE_NAME HEADING 'Source|Queue|Name' FORMAT A17 COLUMN DESTINATION_DBLINK HEADING 'Database|Link' FORMAT … database. The query in this section displays the following information about each

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

Managing a Distributed Database: Examples

Managing a Distributed Database: ExamplesPublic Fixed User Database Link Example 2: Creating a Public Fixed User Shared Database Link Example 3 … : Creating a Public Connected User Database Link Example 4: Creating a Public Connected User Shared … Database Link Example 5: Creating a Public

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

Distributed Database Administration

Database Role Schema Enterprise Usersshared schema. Note: You cannot access a current user database link in a shared schema. For example … GRANT select ON emp; CREATE PUBLIC DATABASE LINK sales_link CONNECT AS CURRENT_USER USING 'sales … create the following: A global user in a centralized directory A user in every database that the global

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

Creating Database Links

Creating Fixed User Database LinksTo create a fixed user database link, you embed the credentials (in this case, a username and … password) required to access the remote database in the definition of the link: CREATE DATABASE LINK … : SQL Statement Result CREATE PUBLIC DATABASE LINK

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

Distributed Database Administration

Authentication Without PasswordsWhen using a connected user or current user database link, you can use an external authentication … connected user link to connect as herself to a remote database, the local server passes the security ticket to the remote database. … passed from server to server and can be authenticated by a database

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

Creating Database Links

Obtaining Privileges Necessary for Creating Database LinksA database link is a pointer in the local database that lets you access objects on a remote … database. To create a private database link, you must have been granted the proper privileges. The … following table illustrates which privileges are required on which database

Database Advanced Replication, 11g Release 1 (11.1)

Database Advanced Replication - Contents

ContentsSynchronous Replication Incomplete Database Link Specifications Incorrect Replication Catalog Views … Mechanisms Master Site Roles/Users Database Links and Replication Replication Objects Alternatives to … Materialized View Site Create Database Links Assign Privileges Schedule Purge at Master Site … Materialized

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

Using Shared Database Links

Creating Shared Links to Dedicated Serversthe definition of the service name. Figure 30-1 A Shared Database Link to Dedicated Server Processes … Description of \"Figure 30-1 A Shared Database Link to Dedicated Server Processes\"

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

Using Shared Database Links

Determining Whether to Use Shared Database Linksdatabase link is expected to be much larger than the number of server processes in the local database … . The following table illustrates three possible configurations involving database links: Link Type … database link, and 100 users simultaneously require a connection,

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

Using Shared Database Links

Creating Shared Links to Shared Serversconfigured as shared servers. Figure 30-2 Shared Database Link to Shared Server Description of … \"Figure 30-2 Shared Database Link to Shared Server\" See Also: Oracle Database Net Services

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

Creating Database Links

Creating Connected User and Current User Database Linkslink. The credentials used to connect to the remote database can change depending on the user that … references the database link and the operation performed by the application. Note: For many … achieve this result is to create a procedure that contains a fixed user or current user database link

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

Using PL/SQL Subprograms

Using Database Links with IR SubprogramsYou can create a database link to use invoker's rights: CREATE DATABASE LINK link_name CONNECT TO … CURRENT_USER USING connect_string; A current-user link lets you connect to a remote database as … database link. If global user HR invokes the subprogram,