Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

Virtual Book about 'database link'



Table of Contents: Virtual Book about 'database link'

This virtual book brings together the most relevant topics about 'database link'. The topics are grouped into these categories:
[Back to top]

Introductory Information about 'database link'

This category includes definitions, overviews, concepts, restrictions, frequently asked questions, and explanations of how things work. This is where you should start if you are not familiar with this subject area.

Results in this section come from these books:

[ Next book ]

Concepts

Database Links

Name Resolution for Database Links

Database Links

What Are Database Links?

Figure 30-3 Database Link

What Are Shared Database Links?

Why Use Database Links?

Global Database Names in Database Links

Names for Database Links

Types of Database Links

Users of Database Links

Connected User Database Links

Fixed User Database Links

Current User Database Links

Creation of Database Links: Examples

Schema Objects and Database Links

Naming of Schema Objects Using Database Links

Database Link Restrictions

Authentication Through Database Links

Auditing Database Links

Database Link Resolution

[ Previous book | Next book ]

Distributed Database Systems

Limiting the Number of Active Database Link Connections

What Are Database Links?

What Are Shared Database Links?

Why Use Database Links?

Database Link Restrictions

[Next book]

Glossary

database link - Glossary

database link - Glossary

database link - Glossary

global database link - Glossary

private database link - Glossary

public database link - Glossary


[Back to top]

Tasks Related to 'database link'

This category includes how-to information, both detailed procedures and general usage information and guidelines. The tasks are listed alphabetically, with shortcut links that jump to places within the list. For example, if you want to find Creating, look for a link labeled CRE.

Shortcuts to Tasks

AUD CLO CON CRE DET DIA DRO LIM MAN NAM OBT REF USI VIE

Auditing Database Links

Auditing Database Links

Closing a Database Link Example - USE_STORED_OUTLINES = { true | false | 'category_name' }

Closing Database Links

Configuring Shared Database Links

Controlling Connections Established by Database Links

Creating a Connected User Database Link

Creating a Current User Database Link

Creating a Public Connected User Database Link

Creating a Public Connected User Shared Database Link

Creating a Public Current User Database Link

Creating a Public Fixed User Database Link

Creating a Public Fixed User Shared Database Link

Creating Connected User and Current User Database Links

Creating Database Links

Creating Database Links

Creating Fixed User Database Links

Creating Global Database Links

Creating Private Database Links

Creating Public Database Links

Creating Shared Database Links

Creating Shared Database Links

Determining Whether to Use Shared Database Links

Diagnosing Problems with Database Links

Dropping a Database Link Example - dblink

Dropping Database Links

Limiting the Number of Active Database Link Connections

Managing Database Links

Naming of Schema Objects Using Database Links

Naming of Schema Objects Using Database Links

Obtaining Database Role and Database Link Information

Obtaining Privileges Necessary for Creating Database Links

Referring to Database Links

Using Database Links

Viewing Information About Database Links


[Back to top]

Examples of 'database link'

This category includes sample procedure and sample code, to illustrate how to perform tasks or use features.

Results in this section come from these books:

[ Next book ]

Concepts

Creation of Database Links: Examples

Figure 30-3 Database Link

[ Previous book | Next book ]

SQL Reference

Closing a Database Link Example - USE_STORED_OUTLINES = { true | false | 'category_name' }

Dropping a Database Link Example - dblink

PUBLIC Database Link Example - USING 'connect string'

[ Previous book | Next book ]

Distributed Database Systems

Creation of Database Links: Examples

Figure 1-3 Database Link

Figure 2-1 A Shared Database Link to Dedicated Server Processes

Figure 2-2 Shared Database Link to Multi-Threaded Server

[ Previous book | Next book ]

Replication

Figure 2-3 Each Arrow Represents a Database Link

Figure 3-10 Recommended Schema and Database Link Configuration

[ Previous book | Next book ]

SQL*Plus User's Guide and Reference

Example 3-23 Tracing Statements Using a Database Link


[Back to top]

Detailed Reference Information on 'database link'

This category includes syntax for associated statements, APIs, or commands.

Results in this section come from these books:

[ Next book ]

SQL Reference

CLOSE DATABASE LINK - ALTER SESSION

CREATE DATABASE LINK

Database Link Names

DROP DATABASE LINK


[Back to top]

Troubleshooting Information About 'database link'

This category includes information about debugging, preventing errors or handling them when they occur, frequently asked questions, and relevant error messages.

Results in this section come from these books:

[ Next book ]

Concepts

Database Link Restrictions

[ Previous book | Next book ]

Distributed Database Systems

Database Link Restrictions

Limiting the Number of Active Database Link Connections

[ Previous book | Next book ]

Enterprise Manager Messages Manual

VMQ-00047: Cannot access private database link.

[ Previous book | Next book ]

Error Messages

O2F-00332 A database link may not appear in the name of a user-defined type

ORA-01729 database link name expected

ORA-02011 duplicate database link name

ORA-02018 database link of same name has an open connection

ORA-02020 too many database links in use

ORA-02024 database link not found

ORA-02080 database link is in use

ORA-02081 database link is not open

ORA-02082 a loopback database link must have a connection qualifier

ORA-02085 database link string connects to string

ORA-04051 user string cannot use database link string.string

ORA-04054 database link string does not exist

ORA-12315 database link type is invalid for the ALTER DATABASE statement

ORA-12316 syntax error in database link's connect string

ORA-12324 cannot use the ROM: link type on a private database link

ORA-12345 user string lacks CREATE SESSION privilege in database link (linkname string)

ORA-12350 database link being dropped is still mounted

ORA-23396 database link "string" does not exist or has not been scheduled

ORA-23397 global name "string" does not match database link name "string"

ORA-23398 user name "string" at database link "string" does not match local user name "string"

ORA-24045 invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]

ORA-24777 use of non-migratable database link not allowed

ORA-25124 Database link name not allowed.

ORA-28027 privileged database links may be used by global users

ORA-28501 communication error on heterogeneous database link

ORA-28502 internal communication error on heterogeneous database link

ORA-28504 ROWID not found in ROWID cache for heterogeneous database link

ORA-28510 heterogeneous database link initialization failed

ORA-28514 heterogeneous database link initialization could not convert system date

ORA-28557 unknown string for database link to non-Oracle system

TNS-12677 Authentication service not supported by database link

TNS-12687 Database link failed: credentials expired

[ Previous book | Next book ]

Replication

Diagnosing Problems with Database Links


[Back to top]

Index Entries about 'database link'

The index entries show related terms, and identify the most important places where your subject is mentioned.
GL CR CL FI CO DR PR CU DA PU LI SH

Index Entries

closing database links (Distributed Database Systems)
connected user database links (Distributed Database Systems)
advantages and disadvantages (Distributed Database Systems)
creating (Distributed Database Systems)
definition (Distributed Database Systems)
example (Distributed Database Systems)
REMOTE_OS_AUTHENT initialization parameter (Distributed Database Systems)
CREATE DATABASE LINK statement (Distributed Database Systems)
CREATE PUBLIC DATABASE LINK system privilege (SQL Reference)
creating database links (Distributed Database Systems)
connected user (Distributed Database Systems)
current user (Distributed Database Systems)
example (Distributed Database Systems)
fixed user (Distributed Database Systems)
private (Distributed Database Systems)
public (Distributed Database Systems)
service names within link names (Distributed Database Systems)
specifying types (Distributed Database Systems)
current user database links (Distributed Database Systems)
advantages and disadvantages (Distributed Database Systems)
cannot access in shared schema (Distributed Database Systems)
creating (Distributed Database Systems)
definition (Distributed Database Systems)
example (Distributed Database Systems)
schema independence (Distributed Database Systems)
database links (SQL Reference)
     [entry #2] (Concepts)
     [entry #3] (Net8 Administrator's Guide)
     [entry #4] (Net8 Administrator's Guide)
advantages (Distributed Database Systems)
auditing (Distributed Database Systems)
authentication (Distributed Database Systems)
without passwords (Distributed Database Systems)
closing (SQL Reference)
connection qualifiers (Replication)
creating (SQL Reference)
     [subentry #2] (SQL Reference)
     [subentry #3] (Replication Management API Reference)
     [subentry #4] (Replication Management API Reference)
     [subentry #5] (Replication Management API Reference)
creating synonyms with (SQL Reference)
current user (SQL Reference)
defined (Concepts)
diagnosing problems with (Replication)
global database link (Net8 Administrator's Guide)
granting system privileges on (SQL Reference)
incomplete specifications (Replication)
job queues and (Administrator's Guide)
naming (SQL Reference)
partition-extended table names (Concepts)
private database (Net8 Administrator's Guide)
public (SQL Reference)
dropping (SQL Reference)
public database (Net8 Administrator's Guide)
replication (Replication)
resolution (Concepts)
roles on remote database (Concepts)
snapshot sites (Replication)
     [subentry #2] (Replication)
using in DELETE statement (Pro*COBOL Precompiler Programmer's Guide)
using in INSERT statement (Pro*COBOL Precompiler Programmer's Guide)
using in UPDATE statement (Pro*COBOL Precompiler Programmer's Guide)
DROP DATABASE LINK statement (SQL Reference)
DROP PUBLIC DATABASE LINK system privilege (SQL Reference)
dropping database links (Distributed Database Systems)
global database link qualifiers (Net8 Administrator's Guide)
global database links (Net8 Administrator's Guide)
     [entry #2] (Distributed Database Systems)
     [entry #3] (Net8 Administrator's Guide)
adding link qualifiers (Net8 Administrator's Guide)
creating (Distributed Database Systems)
registering with Oracle Names (Net8 Administrator's Guide)
listing database links (Distributed Database Systems)
     [entry #2] (Distributed Database Systems)
     [entry #3] (Distributed Database Systems)
private database links (Distributed Database Systems)
     [entry #2] (Net8 Administrator's Guide)
public database links (Net8 Administrator's Guide)
connected user (Distributed Database Systems)
dropping (SQL Reference)
fixed user (Distributed Database Systems)
public fixed user database links (Distributed Database Systems)

[Back to top]

Bibliography

The links on this page lead to many different books. This section lists PDF files that you can download and print, if you want to do further reading. This section also identifies the relevant chapters that you can print out, rather than printing the entire book.

PDF FileMajor Topics to Print
Advanced Security Administrator's Guide
  • Glossary
Concepts
  • Schemas and Schema Objects
  • Executing a Procedure
  • Distributed Database Concepts
  • Database Links
  • What Are Database Links?
  • Users of Database Links
  • Schema Objects and Database Links
  • Distributed Database Administration
  • Distributed Database Security
  • Transaction Processing in a Distributed System
Distributed Database Systems
  • Managing a Distributed Database
  • Creating Database Links
  • Specifying Link Types
  • Specifying Link Users
  • Creating Shared Database Links
  • Configuring Shared Database Links
  • Managing Database Links
  • Managing a Distributed Database: Scenarios
  • Developing Applications for a Distributed Database System 
  • Database Links
  • What Are Database Links?
  • Schema Objects and Database Links
  • Distributed Database Administration
  • Step 3: Query DBA_2PC_NEIGHBORS on Local Node
Enterprise Manager Messages Manual
Error Messages
Net8 Administrator's Guide
  • Glossary
PL/SQL User's Guide and Reference
  • Invoker Rights versus Definer Rights
Replication
  • Master Site Mechanisms
  • Database Link
  • Troubleshooting Replication Problems
SQL Reference
  • Basic Elements of Oracle SQL
  • Referring to Objects in Remote Databases
  • dblink
  • ALTER SESSION
  • USE_STORED_OUTLINES = { true | false | 'category_name' }
  • USING 'connect string'
SQL*Plus User's Guide and Reference
  • Statistics
  • Glossary