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
Database Jobs → Database jobs run Oracle Database program units, including PL/SQL anonymous blocks, PL/SQL stored … procedures, and Java stored procedures. For a database job where the action is specified inline
Database Administrators → Each database requires at least one database administrator (DBA). An Oracle Database system can be … large and can have many users. Therefore, database administration is sometimes not a one-person job … , but a job for a group of DBAs who share responsibility. A database administrator's responsibilities
Database Users → Database users interact with the database through applications or utilities. A typical user's
Oracle® Database → SQL Language Reference 11 g Release 1 (11.1) B28286-07 July 2013 Oracle Database SQL Language
Database Servers → A database server is a node that hosts a database from which a client requests data. In Figure 32-2 … finance are both database servers. In this example, sales is a database server and a client because … the application also modifies data in the sales database.
Oracle® Database → Administrator's Guide 11 g Release 1 (11.1) B28310-04 March 2008 Oracle Database Administrator's
Database Events → Database events are related to entire instances or schemas, not individual tables or rows. Triggers … associated with startup and shutdown events must be defined on the database instance. Triggers … associated with on-error and suspend events can be defined on either the database instance or a … particular schema. Table 9-4 Database
Oracle® Database → PL/SQL Language Reference 11 g Release 1 (11.1) B28370-05 August 2009 Oracle Database PL/SQL
ALTER DATABASE → Purpose Use the ALTER DATABASE statement to modify, maintain, or recover an existing database. Note … : In earlier versions of Oracle Database, you could use the ALTER DATABASE for two conversion … operations: The RESET COMPATIBILITY clause lets you reset the database to an earlier version at the next
Database Links → The central concept in distributed database systems is a database link. A database link is a … connection between two physical database servers that allows a client to access them as one logical … database. This section contains the following topics: What Are Database Links? Why Use
Database Objects → The names of Oracle identifiers, such as tables and columns, must not exceed 30 characters in length. The first character must be a letter, but the rest can be any combination of letters, numerals, dollar signs ($), pound signs (#), and underscores (_). However, if an Oracle identifier is enclosed by double quotation marks (\"), then it can contain any combination of legal characters, including spaces
Database Objects → Oracle Database recognizes objects that are associated with a particular schema and objects that
Contents → Related Material About Oracle Database Common Oracle DBA Tasks Tools for Administering the Database 2 … Installing Oracle Database and Creating a Database Overview of Installing Oracle Database Software and … Creating a Database Checking Prerequisites Installation Choices Basic Installation
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 the database
Obtaining Database Role and Database Link Information → ( IN_OUT = in ) or outbound ( IN_OUT = out ): IN_OUT Meaning DATABASE DBUSER_OWNER in Your node is a … server of another node. Lists the name of the client database that connected to your node. Lists the … local account for the database link connection that corresponds to the in-doubt transaction. out Your … node is a client of
Names for Database Links → Typically, a database link has the same name as the global database name of the remote database … that it references. For example, if the global database name of a database is sales.us.oracle.com, then … the database link is also called sales.us.oracle.com. When you set the initialization
Types of Database Links → Oracle Database lets you create private, public, and global database links. These basic link types … differ according to which users are allowed access to the remote database: Type Owner Description … USER_DB_LINKS Creates link in a specific schema of the local database. Only the owner of a private database
Creation of Database Links: Examples → Create database links using the CREATE DATABASE LINK statement. The table gives examples of SQL … statements that create database links in a local database to the remote sales.us.americas.acme_auto.com … database: SQL Statement Connects To Database Connects As Link Type CREATE DATABASE
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 … whether the user is authenticated by the database using a password, or externally authenticated by … , then the ability to use a
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 specific remote … objects.