How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Contents → Resolution Database Link Restrictions Distributed Database Administration Site Autonomy Distributed … Mechanism Database Link Name Resolution Name Resolution When the Global Database Name Is Complete Name … Specifying Link Types Creating Private Database
Contents → CONTEXT CREATE CONTROLFILE CREATE DATABASE CREATE DATABASE LINK CREATE DIMENSION CREATE DIRECTORY … CONTEXT DROP DATABASE DROP DATABASE LINK DROP DIMENSION DROP DIRECTORY DROP DISKGROUP DROP FLASHBACK … Conventions What's New in the SQL Language Reference? Oracle Database
DROP DATABASE LINK → Purpose 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 database … link must be in
Database Link Name Resolution → A global object name is an object specified using a database link. The essential components of a … database link with a name that matches the database name specified in the global object name. For … searches for a database link called orders.us.acme.com. The database
Database Link Restrictions → 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. For example, if jane connects to the local database and executes a stored procedure that … uses a fixed
CREATE DATABASE LINK → Purpose 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 … DROP DATABASE LINK
Obtaining Database Role and Database Link Information → local account for the database link connection that corresponds to the in-doubt transaction. out Your … node is a client of other servers. Lists the name of the database link that connects to the remote … node. Lists the owner of the database link for the in-doubt transaction. In this
Procedure for Dropping a Public Database Link → Connect to the local database as a user with the DROP PUBLIC DATABASE LINK privilege. For example … selected. Drop the desired link using the DROP PUBLIC DATABASE LINK statement. For example, enter: DROP PUBLIC DATABASE LINK sales.us.oracle.com;
Procedure for Dropping a Private Database Link → … Drop the desired link using the DROP DATABASE LINK statement. For example, enter: DROP DATABASE LINK sales.us.oracle.com; … Connect to the local database using SQL*Plus. For example, enter: CONNECT scott@local_db Query
Example 2: 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 as … scott and authenticates this user as scott: CONNECT dana@local CREATE SHARED PUBLIC DATABASE
Example 5: Creating a Public Current User Database Link → link 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.acme.com … user. The consequences of this database link
Example 4: 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 … /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.acme.com
Limiting the Number of Active Database Link Connections → no distributed transactions are allowed. See Also: Oracle Database Reference for more information about the OPEN_LINKS initialization parameter
Example 3: 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 USING … 'sldb'; Any user connected to the local database can use the redwood database
Example 1: Creating a Public Fixed User Database Link → database 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.acme.com CONNECT TO scott IDENTIFIED … use the sales.division3.acme.com database link
Specifying Link Users → A database link defines a communication path from one database to another. When an application uses … a database link to access a remote database, Oracle Database establishes a database session in the … database link,
Specifying Link Types → When you create a database link, you must decide who will have access to it. The following sections … describe how to create the three basic types of links: Creating Private Database Links Creating Public Database Links Creating Global Database Links
database link → A named schema object that describes a path from one database to another. Database links are … implicitly used when a reference is made to a global object name in a distributed database.
Database Links → The central concept in distributed database systems is a database link. A database link is a … Database Links Creation of Database Links: Examples Schema Objects and Database Links Database Link Restrictions … connection
Determining Which Link Connections Are Open → You may find it useful to determine which database link connections are currently open in your … . The following views show the database link connections that are currently open in your current … , with one exception: Column Which Views? Description DB_LINK All The name of the database link