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 20 of 78369 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Administrator's Guide, 11g Release 2 (11.2)

Database Administrator's Guide - Contents

Contentsin Database Links Global Name as a Loopback Database Link Names for Database Links Types of … Schema Objects Schema Object Name Resolution Database Link Restrictions Distributed Database … Transactions Two-Phase Commit Mechanism Database Link

Database SQL Language Reference, 11g Release 2 (11.2)

Database SQL Language Reference - Contents

ContentsALTER DATABASE ALTER DATABASE LINK ALTER DIMENSION ALTER DISKGROUP ALTER FLASHBACK ARCHIVE ALTER … CREATE CONTEXT CREATE CONTROLFILE CREATE DATABASE CREATE DATABASE LINK CREATE DIMENSION CREATE DIRECTORY … DROP CLUSTER DROP CONTEXT DROP DATABASE DROP DATABASE

Database SQL Language Reference, 11g Release 2 (11.2)

ALTER DATABASE LINK

ALTER DATABASE LINKPurpose Use the ALTER DATABASE LINK statement to modify a fixed-user database link when the … the connection or authentication user associated with the database link. To change user, you must re … -create the database link. You cannot use this statement

Database Administrator's Guide, 11g Release 2 (11.2)

Distributed Database Concepts

Database Link Restrictionsdatabase. Jane cannot issue SET ROLE to obtain a nondefault role. Use a current user link without … You 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.

Database Administrator's Guide, 11g Release 2 (11.2)

Distributed Database Concepts

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

Database SQL Language Reference, 11g Release 2 (11.2)

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 SQL Language Reference, 11g Release 2 (11.2)

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 … V$DBLINK dynamic performance view ALTER DATABASE

Database Administrator's Guide, 11g Release 2 (11.2)

Managing a Distributed Database

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 2 (11.2)

Managing a Distributed Database

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.example.com

Database Administrator's Guide, 11g Release 2 (11.2)

Managing a Distributed Database

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 2 (11.2)

Managing a Distributed Database

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.example.com CONNECT TO scott … database can use the sales.division3.example.com database

Database Administrator's Guide, 11g Release 2 (11.2)

Managing a Distributed Database

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 2 (11.2)

Managing a Distributed Database

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 … user. The consequences of this database link are as

Database Data Warehousing Guide, 11g Release 2 (11.2)

Change Data Capture

Step 7   Staging Database Publisher: Create Database LinkThe staging database publisher creates a link from the staging database to the source database … . Again, because the GLOBAL_NAMES initialization parameter is set to TRUE, the database link name will be … source_db: CREATE DATABASE LINK source_db CONNECT

Database Data Warehousing Guide, 11g Release 2 (11.2)

Change Data Capture

Step 6   Source Database Publisher: Create Database LinkThe source database publisher creates a link from the source database to the staging database … . Because the GLOBAL_NAMES initialization parameter is set to TRUE, the database link name will be same as … : CREATE DATABASE LINK staging_db CONNECT TO

SQL Developer User's Guide, 11g Release 2 (11.2)

Dialog Boxes for Creating/Editing Objects

Create/Edit Database LinkThe following information applies to a database link, which is a database object in one database … Private). Public: If this option is checked, the database link is public (available to all users). If … this option is not checked, the database link is

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

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

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

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

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

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 Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

Importing a Full Database Using a Network Linkcan use the Data Pump Import utility with a database link to perform a full database import from a … these steps to use a network link with impdp: Ensure that the exporting user at the source database has … the EXP_FULL_DATABASE role. This user must be specified when you create the database