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


Database Administrator's Guide, 12c Release 1 (12.1)

Database Administrator's Guide - Contents

ContentsName as a Loopback Database Link 31.2.6 Names for Database Links 31.2.7 Types of Database Links … 31.2.8 Users of Database Links 31.2.8.1 Overview of Database Link Users 31.2.8.2 Connected User … for Schema Objects 31.2.10.4 Schema Object Name Resolution 31.2.11 Database

Database SQL Language Reference, 12c Release 1 (12.1)

Database SQL Language Reference - Contents

ContentsAuditing) ALTER CLUSTER ALTER DATABASE ALTER DATABASE LINK ALTER DIMENSION ALTER DISKGROUP ALTER … CREATE CONTROLFILE CREATE DATABASE CREATE DATABASE LINK CREATE DIMENSION CREATE DIRECTORY CREATE … CONTEXT DROP DATABASE DROP DATABASE LINK

Database SQL Language Reference, 12c Release 1 (12.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 … performance view ALTER DATABASE LINK

Database SQL Language Reference, 12c Release 1 (12.1)

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 SQL Language Reference, 12c Release 1 (12.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, 12c Release 1 (12.1)

Distributed Database Concepts

31.2.11 Database Link RestrictionsSYSTEM: CONNECT SYSTEM@sales1 You then issue the following statements using database link … jane.accounts@hq.example.com WHERE acc_name = 'BOWER'; 31.2.11 Database Link Restrictions Several restrictions … See Also: Oracle Database Object-Relational Developer's Guide for information about database

Database Administrator's Guide, 12c Release 1 (12.1)

Distributed Database Concepts

31.4.7 Database Link Name Resolutiondatabase link with a name that matches the database name specified in the global object name. … Whenever a SQL statement includes a reference to a global object name, the database searches for a

Database Security Guide, 12c Release 1 (12.1)

Database Security Guide - Contents

ContentsAffects Passwords Used in Database Link Connections Ensuring Against Password Security Threats by … Documents Conventions Changes in This Release for Oracle Database Security Guide Changes in Oracle … Database Security 12c Release 1 (12.1.0.2) New Features SHA-2 Support for 12C Password Version … Algorithm Changes

Database Administrator's Guide, 12c Release 1 (12.1)

Transporting Data

Task 1   Create a Database Link from the Target Database to the Source DatabaseCreate a database link from the target database to the source database by completing the following … \" Connecting to the Database with SQL*Plus \" for instructions. Create the database link: CREATE PUBLIC … DATABASE LINK sourcedb USING

Database Administrator's Guide, 12c Release 1 (12.1)

Transporting Data

Task 1   Create a Database Link from the Target Database to the Source DatabaseCreate a database link from the target database to the source database by completing the following … the Database with SQL*Plus \" for instructions. Create the database link: CREATE PUBLIC DATABASE LINK … . During the import operation,

Database Administrator's Guide, 12c Release 1 (12.1)

Managing a Distributed Database

32.8.3 Example 3: Creating a Public Connected User Database LinkAn example illustrates creating a public connected user database link. The 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

Database Administrator's Guide, 12c Release 1 (12.1)

Managing a Distributed Database

32.4.3 Limiting the Number of Active Database Link Connections32.4.2.1 Dropping a Private Database Link Use the DROP DATABASE LINK statement to drop a private … database link. Connect to the local database using SQL*Plus. For example, enter: CONNECT scott … selected. Drop the desired link using the DROP DATABASE

Database Administrator's Guide, 12c Release 1 (12.1)

Managing a Distributed Database

32.8.5 Example 5: Creating a Public Current User Database LinkAn example illustrates creating a public current user database link. The following example connects … to the local database as the connected user and creates a public link to the sales database (using … its net service name sldb ). The following statement creates a public current user database

Database Administrator's Guide, 12c Release 1 (12.1)

Distributed Database Concepts

31.2.5 Global Name as a Loopback Database LinkYou can use the global name of a database as a loopback database link without explicitly creating a … database link. When the database link in a SQL statement matches the global name of the current … database, the database link

Database Concepts, 12c Release 1 (12.1)

Glossary

database linkA schema object in one database that enables users to access objects in a different database.

Database PL/SQL Language Reference, 12c Release 1 (12.1)

Database PL/SQL Language Reference - Contents

Contentsfor Oracle Database PL/SQL Language Reference Changes in Oracle Database 12 c Release 1 (12.1 … Subprograms More Data Types Have Same Maximum Size in SQL and PL/SQL DATABASE Triggers on PDBs … Fundamentals Character Sets Database Character Set National Character Set Lexical Units Delimiters … Pseudocolumn System

Database Administrator's Guide, 12c Release 1 (12.1)

Managing a Distributed Database

32.8.4 Example 4: Creating a Public Connected User Shared Database LinkAn example illustrates creating a public connected user shared database link. The following example … connects to the local database as neil and creates a shared, public link to the sales database … following statement creates a public, connected user, shared database link:

Database Administrator's Guide, 12c Release 1 (12.1)

Managing a Distributed Database

32.8.2 Example 2: Creating a Public Fixed User Shared Database LinkAn example illustrates creating a public fixed user shared database link. The 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

Function Declaration and Definition

Function Declaration and Definitiontable function over a database link. The reason is that the return type of a pipelined table function is … Oracle Database SQL Language Reference PIPELINED Use only with a table function, to specify that it … a SQL user-defined type, which can be used only in a single database (as explained in Oracle … Database

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Packages

Appropriate Public Itemsrefers to a package public variable, you cannot invoke the subprogram through a database link.