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 → in 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
Contents → ALTER 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 Link Restrictions → database. 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 Link Name Resolution → A 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
ALTER DATABASE LINK → Purpose 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
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
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 … V$DBLINK dynamic performance view ALTER DATABASE
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 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.example.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 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.example.com CONNECT TO scott … database can use the sales.division3.example.com database
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 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 … user. The consequences of this database link are as
Step 7 Staging Database Publisher: Create Database Link → The 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
Step 6 Source Database Publisher: Create Database Link → The 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
Create/Edit Database Link → The 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
Creating a Database Link → To 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
Browsing a Database Link → To 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
Dropping a Database Link → To 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
Importing a Full Database Using a Network Link → can 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
database link → In a schema object, a schema object in one database that enables users to access objects on a different database.
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 … private database link, specify the following (where link_name is the global database name or an arbitrary … link name): CREATE DATABASE LINK link_name...;
Type of Link Description → Figure 31-3 Database Link Description of \"Figure 31-3 Database Link\" Database links are either … their account on the local database. Fixed user link Users connect using the user name and password … referenced in the link. For example, if Jane uses
JMS-430 Database Link must be specified → Cause: DB Link is Action: Specify a non- Register Option
Database Links → database link. A database link is a connection between two physical database servers that allows a client … Types of Database Links Users of Database Links Creation of Database Links: Examples Schema Objects and Database Links Database
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
Global Database Names in Database Links → To understand how a database link works, you must first understand what a global database name is … . Each database in a distributed database is uniquely identified by its global database name. The … database forms a global database name by prefixing
Displaying the Queues and Database Link for Each Propagation → propagation 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
Specifying Whether Downstream Capture Uses a Database Link → You 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
Step 3 Create the Database Link at str1.example.com → Create the database link from the database where changes are captured to the database where changes … : ' HIDE CREATE DATABASE LINK str2.example.com CONNECT TO strmadmin IDENTIFIED BY &password USING 'str2.example.com'; /* … are propagated. In this example, the database
Step 3 Create the Database Link at dbs1.example.com → Create the database link from the database where changes are captured to the database where changes … : ' HIDE CREATE DATABASE LINK dbs2.example.com CONNECT TO strmadmin IDENTIFIED BY &password USING 'dbs2.example.com'; /* … are propagated. In this example, the database
Managing Database Links → Figure 32-1 A Shared Database Link to Dedicated Server Processes Description of \"Figure 32-1 A … Shared Database Link to Dedicated Server Processes\" Creating Shared Links to Shared Servers The … as shared servers. Figure 32-2 Shared Database Link to Shared Server Description of \"Figure
Users of Database Links → When creating the link, you determine which user should connect to the remote database to access … database links: User Type Description Sample Link Creation Syntax Connected user A local user accessing a … database link in which no fixed username and password have been specified. If
Why Use Database Links? → , a local user can access a link to a remote database without having to be a user on the remote … database link users \"Viewing Information About Database Links\" for an explanation of how to hide passwords from non-administrative users … The great advantage of database links is that
Using Shared Database Links → Every 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
References to Database Links → a SQL statement that contains a database link, you can specify the database link name in one of … these forms: The complete database link name as stored in the data dictionary, including the database … , domain, and optional connection_qualifier components. The partial
Types of Database Links → Oracle Database lets you create private, public, and global database links. These basic link types … USER_DB_LINKS Creates link in a specific schema of the local database. Only the owner of a private database link … or PL/SQL subprograms in the schema can use this link
Auditing Database Links → and 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 … audit use of a database link, although access to remote objects
Database Object Naming Rules → , database names, global database names, and database link names are always case insensitive and are … ASCII characters in database names, global database names, and database link names, because ASCII … Every database object has a name.