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


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


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,

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

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