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 → Conventions What's New in Oracle Database Administrator's Guide? Oracle Database 11 g Release 1 (11.1 … ) New Features in the Administrator's Guide Part I Basic Database Administration 1 Getting Started with … Database Administration Types of Oracle Database Users Database Administrators
Contents → Conventions What's New in the SQL Language Reference? Oracle Database 11 g Release 1 New Features in the … USE_HASH Hint USE_MERGE Hint USE_NL Hint USE_NL_WITH_INDEX Hint Database Objects Schema Objects … Database Resolves Schema Object References References to Objects in Other Schemas References to … Objects in Remote Databases
Contents → Conditional Compilation Examples Using Conditional Compilation to Specify Code for Database Versions Using … Records Into the Database Updating the Database with Record Values Restrictions on Record Inserts and … /SQL How the Database Does Implicit Rollbacks Ending Transactions Setting Transaction Properties (SET
Contents → Accessing Documentation Related Documentation Conventions What's New in Oracle Database 11g New Components … Available for Installation Changes in the Install Options Database Configuration Assistant Database … Components in Oracle Database 11 g Release 1 (11.1) 1 Overview of Oracle Database Installation
Contents → Configuring a Database for Performance 4.1 Performance Considerations for Initial Instance … Database Statistics 5.1.2 Operating System Statistics 5.1.3 Interpreting Statistics 5.2 Overview of … Diagnostics 6.1 Overview of the Automatic Database Diagnostic Monitor 6.1.1 ADDM Analysis 6.1.2 Using ADDM … : Example 6.2 Setting Up
Contents → Database Data Recovery Advisor Backup and Recovery Documentation Roadmap Recovery Manager … Overview of the RMAN Environment Starting RMAN and Connecting to Database Showing the Default RMAN … Configuration Backing Up a Database Backing Up a Database in ARCHIVELOG Mode Backing Up a Database in
Contents → Conventions Part I What Is Oracle? 1 Introduction to Oracle Database Oracle Database Architecture … Overview of Grid Architecture Overview of Application Architecture Overview of Physical Database … Structures Overview of Logical Database Structures Overview of Schemas and Common Schema Objects Overview … of the
Contents → Conventions What's New in Oracle Database 11g New Components Available for Installation Changes in … the Install Options Database Configuration Assistant Database Upgrade Assistant Active Directory … Components in Oracle Database 11 g Release 1 (11.1) 1 Overview of Oracle Database Installation 1.1 Planning
Contents → Documentation Accessibility Related Documents Conventions What's New in Oracle Database Security … Network Services on the Database Change to AUDIT BY SESSION Oracle XML DB Security Enhancements … Directory Security Enhancements Oracle Call Interface Security Enhancements 1 Introducing Oracle Database … Security About Oracle Database
Contents → Conventions What's New in Oracle Database Reference? Oracle Database 11g Release 1 (11.1) New Features … $CPOOL_CC_STATS V$CPOOL_STATS V$CR_BLOCK_SERVER V$CURRENT_BLOCK_SERVER V$DATABASE V$DATABASE_BLOCK_CORRUPTION V … $XS_SESSION_ATTRIBUTE V$XS_SESSION_ROLE A Database Limits Datatype Limits Physical Database
Contents → Conventions What9s New in Oracle Database Upgrade Guide 1 Introduction to the Database Upgrade … Process Overview of the Database Upgrade Process Oracle Release Numbers Running Multiple Oracle Releases … Homes on Separate Computers Upgrade a Database to the Current Release Upgrade Clients to the … 64-bit Oracle
Contents → Documentation Accessibility Related Documentation Syntax Diagrams Conventions What's New in Database … Utilities? New Features in Oracle Database 11g Release 1 Part I Oracle Data Pump 1 Overview of Oracle … Parallelism Using Substitution Variables Moving Data Between Different Database Versions 2 Data Pump … Needed in a Table-Mode
Contents → Documents Conventions 1 Oracle 11g Database New Features 1.1 Application Development 1.1.1 APIs and … in the Database 188.8.131.52 OracleJVM Java/JDK 5.0 Compatibility 184.108.40.206 OracleJVM JIT Configuration … OracleJVM Ease-of-Use: Output Redirect 220.127.116.11 OracleJVM Ease of Use: Database Resident Jars 18.104.22.168 … ANYDATA 22.214.171.124 JDBC Support
Contents → Conventions What's New in Oracle Database? Oracle Database 11g Release 1 (11.1) New Features in Data … Warehousing Oracle Database 10 g Release 2 (10.2) New Features in Data Warehousing Part I Concepts 1 … Database Plan for Growth Storage Management 5 Partitioning in Data Warehouses 6 Indexes Using Bitmap … with
Contents → MAINTENANCE ALTER DATABASE BACKUP CATALOG CHANGE CONFIGURE CONNECT CONVERT CREATE CATALOG CREATE SCRIPT … CROSSCHECK DELETE DELETE SCRIPT DROP CATALOG DROP DATABASE DUPLICATE EXECUTE SCRIPT EXIT FLASHBACK … DATABASE GRANT HOST IMPORT CATALOG LIST PRINT SCRIPT QUIT RECOVER REGISTER DATABASE RELEASE CHANNEL … REPAIR
Contents → Conventions What's New in PL/SQL Packages and Types Reference? Oracle Database 11g Release 1 (11.1) 1 … Objects From the Database Subprograms for Submitting XML to the Database Summary of All DBMS_METADATA … Database URI TYPEs Summary of URITYPE Supertype Subprograms GETBLOB GETCLOB GETCONTENTTYPE GETEXTERNALURL
Contents → Conventions What's New in Oracle Clusterware Administration and Deployment? Oracle Database 11 g Release … for the Cluster Verification Utility Database Versions Supported by Cluster Verification Utility
CREATE DATABASE → Caution: This statement prepares a database for initial use and erases any data currently in the … Security Enhancements: In this release of Oracle Database and in subsequent releases, several enhancements … are being made to ensure the security of default database user accounts. You can find a security … checklist for this release
FLASHBACK DATABASE → Purpose Use the FLASHBACK DATABASE statement to return the database to a past time or system change … number (SCN). This statement provides a fast alternative to performing incomplete database recovery … . Following a FLASHBACK DATABASE operation, in order to have write access to the flashed back … database,
DROP DATABASE → Purpose Caution: You cannot roll back a DROP DATABASE statement. Use the DROP DATABASE statement to … drop the database. This statement is useful when you want to drop a test database or drop an old … database after successful migration to a new host. See Also: Oracle Database Backup
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.
Nonschema Objects → Other types of objects are also stored in the database and can be created and manipulated with SQL … Chapter 19, in the section devoted to the statement that creates the database object. These statements … Also: Oracle Database Concepts for an overview of database objects You must provide names for most … types
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 that contains the data … dictionary
Authorization for Accessing Remote Schema Objects → database. Further, to perform any updates, inserts, or deletes on the remote object, you must be … the database has no remote describe capability. The database must do a SELECT * on the remote object in order to determine its structure.
Schema Objects → database user and has the same name as that user. Each user owns a single schema. Schema objects can … Database links Database triggers Dimensions External procedure libraries Index-organized tables
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 … table in
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 … database.
Why Use Database Links? → The great advantage of database links is that they allow users to access another user's objects in … a remote database so that they are bounded by the privilege set of the object owner. In other words … , a local user can access a link to a remote database without having to be a user on the remote … database.
Fixed User Database Links → A benefit of a fixed user link is that it connects a user in a primary database to a remote … database with the security context of the user specified in the connect string. For example, local user joe … can create a public database link in joe 's schema that specifies the fixed user scott with … password tiger. If jane uses the
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 … or shared server mode. The following table illustrates the possibilities: Local
Current User Database Links → Current user database links make use of a global user. A global user must be authenticated by an X … (not as a global user) by password to the Accounts Payable database, she can access a stored procedure … to retrieve data from the hq database. The procedure uses a current user database link, which … certificate
Naming of Schema Objects Using Database Links → Oracle Database uses the global database name to name the schema objects globally using the … structures of data, or schema objects. A schema is owned by a database user and has the same name as … , index, view, synonym, procedure, package, or a database link. global_database_name is the name that … uniquely identifies
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 SYSTEM accesses a … public link in a query,
Schema Object Name Resolution → 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 a result, a … schema object name is always unique within the database. Furthermore, the database resolves
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 your own schema. To drop a PUBLIC database link,
References to Database Links → Database links are available only if you are using Oracle distributed functionality. When you issue … 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
Database Data Dictionary Views → information about your database content and structure using the following views: View Description … DATABASE_PROPERTIES Displays permanent database properties GLOBAL_NAME Displays the global database name V … $DATABASE Contains database information from the control file
Dropping a Database → Dropping a database involves removing its datafiles, redo log files, control files, and … initialization parameter files. The DROP DATABASE statement deletes all control files and all other database … files listed in the control file. To use the DROP DATABASE statement successfully, all of the … following conditions
Distributed Database Application Development → development: Transparency in a Distributed Database System Remote Procedure Calls (RPCs) Distributed … Query Optimization See Also: Chapter 31, \"Developing Applications for a Distributed Database System
Auditing Database Use → You can monitor and record selected user database actions, including those performed by … administrators. There are several reasons why you might want to implement database auditing. Complete … background information and instructions for database auditing are found in Oracle Database Security Guide.
Basic Database Administration → Part I Basic Database Administration Part I provides an overview of the responsibilities of a … database administrator, and describes how to accomplish basic database administration tasks. It contains … the following chapters: Chapter 1, \"Getting Started with Database Administration\" Chapter 2 … , \"Creating