Results for database link


1 to 60 of 62480 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

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 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

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,

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,


Was this page helpful?