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
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
Names for Database Links → Typically, a database link has the same name as the global database name of the remote database … the database link is also called sales.us.oracle.com. When you set the initialization parameter … GLOBAL_NAMES to TRUE, the database ensures that the name of the database
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
Creation of Database Links: Examples → Create database links using the CREATE DATABASE LINK statement. The table gives examples of SQL … database: SQL Statement Connects To Database Connects As Link Type CREATE DATABASE LINK … connected user CREATE DATABASE LINK
Connected User Database Links → link is that a user referencing the link connects to the remote database as the same user, and … jobs. The ability to use a connected user database link depends on several factors, chief among them … , then the ability to use a connected user link also depends on whether the remote database
Schema Objects and Database Links → After you have created a database link, you can execute SQL statements that access objects on the … remote database. For example, to access remote object emp using database link foo, you can issue … : SELECT * FROM emp@foo; You must also be authorized in the remote database to access
What Are Database Links? → A database link is a pointer that defines a one-way communication path from an Oracle Database … server to another database server. The link pointer is actually defined as an entry in a data dictionary … table. To access the link, you must be connected to the local database
Synonyms for Schema Objects → Oracle Database lets you create synonyms so that you can hide the database link name from the user … . A synonym allows access to a table on a remote database using the same syntax that you would use to … access a table on a local database. For example, assume you issue the following query against a
Why Use Database Links? → , a local user can access a link to a remote database without having to be a user on the remote … of 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
Fixed User Database Links → A benefit of a fixed user link is that it connects a user in a primary database to a remote … can create a public database link in joe 's schema that specifies the fixed user scott with … password tiger. If jane uses the fixed user link in a query, then jane is the user on the local database
What Are Shared Database Links? → A shared database link is a link between a local server process and the remote database. The link … database is connected to a remote database through a database link, either database can run in dedicated … Shared server
Current User Database Links → to retrieve data from the hq database. The procedure uses a current user database link, which … current user database link is not accessed from within a stored object, then the current user is … procedure, view, or trigger that accesses a database link, the current user
Naming of Schema Objects Using Database Links → , index, view, synonym, procedure, package, or a database link. global_database_name is the name that … FALSE, in which case any name is acceptable. For example, using a database link to database … .acme.com. For example, you can call the link foo. Then, you can access the remote database
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
Schema Object Name Resolution → issue the following statements using database link hq.acme.com to access objects in the scott and jane … database forms object names hierarchically. For example, the database guarantees that each schema within a … database has a unique name, and that within a schema each object has a unique name. As
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 connect_descriptor components. The partial
Creating Shared Database Links → To create a shared database link, use the keyword SHARE D in the CREATE DATABASE LINK statement … : CREATE SHARED DATABASE LINK dblink_name [CONNECT TO username IDENTIFIED BY password]|[CONNECT TO … server processes from clients that masquerade as a database link
Managing Database Links → This section contains the following topics: Closing Database Links Dropping Database Links Limiting the Number of Active Database Link Connections
Creating Database Links → You create a database link with the statement CREATE DATABASE LINK. The statement lets you specify … this information about the database link: The name of the database link The database connect string … stores this information in the
Authentication Through Database Links → : CREATE PUBLIC DATABASE LINK foo USING 'sales'; You create authenticated links by specifying the … CONNECT TO clause, AUTHENTICATED BY clause, or both clauses together in the database link creation … statement. For example, you can issue: CREATE DATABASE LINK sales CONNECT TO scott