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 184.108.40.206 OracleJVM Java/JDK 5.0 Compatibility 220.127.116.11 OracleJVM JIT Configuration … OracleJVM Ease-of-Use: Output Redirect 18.104.22.168 OracleJVM Ease of Use: Database Resident Jars 22.214.171.124 … ANYDATA 126.96.36.199 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.