Results for database link


41 to 80 of 62480 results. Prev  Next
Results per page:  20 |  40  | 60


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,

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

Managing Global Names in a Distributed System

Changing a Global Database Name: Scenario--------- ----------- db_domain US.ACME.COM You then create a database link to a database called hq, using only a … partially-specified global name: CREATE DATABASE LINK hq USING 'sales'; The database expands the … global database name for this link

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

Viewing Information About Database Links

Determining Which Links Are in the Databaseuser who created the database link. If the link is public, then the user is listed as PUBLIC … . DB_LINK All The name of the database link. USERNAME All If the link definition includes a fixed user, then … name used to connect to the remote database. CREATED All Creation

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

Controlling Connections Established by Database Links

Controlling Connections Established by Database Linksthem. Note that when you issue a SELECT statement across a database link, a transaction lock is placed … session using the ALTER SESSION statement with the CLOSE DATABASE LINK clause. For example, assume … terminates the session in the remote database pointed to by the sales database

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

Troubleshooting an Oracle Streams Environment

Are More Actions Required for Downstream Capture Without a Database Link?When downstream capture is configured with a database link, the database link can be used to … . When downstream capture is configured without a database link, these actions must be performed … actions must be performed manually when you configure downstream capture without a database

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

Syntax for Schema Objects and Parts in SQL Statements

References to Objects in Remote Databasesname of the database link to that database. A database link is a schema object that causes Oracle to … To refer to objects in databases other than your local database, follow the object name with the … connect to a remote database to access an object there. This section

Database Application Express User's Guide, 11g Release 1 (11.1)

Managing Database Objects with Object Browser

Dropping a Database LinkTo drop a database link in Object Browser: On the Workspace home page, click SQL Workshop and then … Selection pane, select a database link. The Object Details View appears. Click Drop. … Object Browser. Object Browser appears. From the Object list, select Database Links. From the Object

Database Advanced Replication, 11g Release 1 (11.1)

Troubleshooting Replication Problems

Incomplete Database Link Specificationsproblem with how you have specified the destination for the transaction. When you create a scheduled link, you must provide the full database link name.

Database Application Express User's Guide, 11g Release 1 (11.1)

Managing Database Objects with Object Browser

Creating a Database LinkTo create a database link: On the Workspace home page, click SQL Workshop and then Object Browser … . Object Browser appears. Click Create. From the list of object types, select Database Link. Specify … the following information and click Next. Database Link Name Connect To Schema Password

Database Gateway for DRDA User's Guide, 11g Release 1 (11.1)

Developing Applications

4.4 Database Link BehaviorA connection to the gateway is established through a database link when it is first used in an … or user can access the same database link and get a distinct connection to the gateway and DRDA database. … Oracle database session. In this context, a connection refers to both the connection

Database Application Express User's Guide, 11g Release 1 (11.1)

Managing Database Objects with Object Browser

Browsing a Database LinkTo browse a database link: On the Workspace home page, click SQL Workshop and then Object Browser … , select a database link. The Object Details view appears. Summary of Available Views Click the tabs … at the top of the page to view different reports about the database link. Table 16-11

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

Managing Global Names in a Distributed System

Changing the Domain in a Global Database Namedatabase name or on the resolution of database link names. The following example shows the syntax for … Use the ALTER DATABASE statement to change the domain in a database global name. Note that after … the database is created, changing the initialization parameter DB_DOMAIN has no effect

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

Transaction Processing in a Distributed System

Name Resolution When No Global Database Name Is SpecifiedIf a global object name references an object in the local database and a database link name is not … statement does not specify a global database name using a database link connect string, the database does not search for database links. … specified

Database Application Express User's Guide, 11g Release 1 (11.1)

Database Application Express User's Guide - Contents

ContentsLink Browsing a Database Link Dropping a Database Link Managing Materialized Views Creating a … Application Viewing Underlying Database Objects Viewing the Database Object Dependencies Report Viewing … Database Objects in Object Browser Part II Application

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

Database PL/SQL Language Reference - Contents

ContentsConditional Compilation Examples Using Conditional Compilation to Specify Code for Database Versions Using … Records Into the Database Updating the Database with Record Values Restrictions on Record Inserts and … /SQL How the Database Does Implicit Rollbacks Ending Transactions Setting Transaction Properties (SET

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

Copying Files Using the Database Server

Third-Party File Transferthe previous example, you can perform a third-party file transfer if you have a database link from A … to either B or C, and that database has a database link to the other database. Database A does not … need a database link to both

Database SQL Developer User's Guide, 11g Release 1 (11.1)

Database SQL Developer User's Guide - Contents

ContentsDatabase Link 4.15 Create/Edit Index 4.16 Create/Edit Materialized View Log 4.17 Create PL/SQL Package … Menus for SQL Developer 1.3 Database Objects 1.3.1 Database Links (Public and Private) 1.3.2 … Database Connections 1.5 Entering and Modifying Data 1.6 Running and Debugging Functions and

Database Gateway for DRDA User's Guide, 11g Release 1 (11.1)

Database Gateway for DRDA User's Guide - Contents

ContentsLink 3.1.1 Creating Database Links 3.1.2 Dropping Database Links 3.1.3 Examining Available DatabaseLink Behavior 4.5 Oracle Database SQL Construct Processing 4.5.1 Compatible SQL Functions 4.5.2 … Measurements 1 Introduction 1.1 Introduction to the Oracle Database

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

Transaction Processing in a Distributed System

Example of Global Object Name Resolution: Complete Object Nameappropriate path to the remote database using both a private and public database link. For this … issued by scott at the local database: CONNECT scott@hq CREATE PUBLIC DATABASE LINK sales.division3 … following statements: CONNECT jward@hq CREATE DATABASE LINK

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

Transaction Processing in a Distributed System

Terminating the Search for Name ResolutionResponse Example Do not specify the CONNECT clause Uses a connected user database link CREATE … DATABASE LINK k1 USING 'prod' Do specify the CONNECT TO... IDENTIFIED BY clause Uses a fixed user … database link CREATE DATABASE LINK k2 CONNECT TO scott

Database Installation Guide for Linux, 11g Release 1 (11.1)

Database Installation Guide - Contents

ContentsAccessing Documentation Related Documentation Conventions What's New in Oracle Database 11g New Components … Available for Installation Changes in the Install Options Database Configuration Assistant Database … Components in Oracle Database 11 g Release 1 (11.1) 1 Overview of Oracle Database Installation


Was this page helpful?