You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for database


1 to 60 of 62103 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Database Administrator's Guide, 11g Release 1 (11.1)

Database Administrator's Guide - Contents

ContentsConventions 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

Database SQL Language Reference, 11g Release 1 (11.1)

Database SQL Language Reference - Contents

ContentsConventions 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

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Database PL/SQL Language Reference - Contents

ContentsConditional 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

Database Installation Guide for Linux, 11g Release 1 (11.1)

Database Installation Guide - Contents

ContentsAccessing 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

Database Performance Tuning Guide, 11g Release 1 (11.1)

Database Performance Tuning Guide - Contents

ContentsConfiguring 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

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Database Backup and Recovery User's Guide - Contents

ContentsDatabase 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

Database Concepts, 11g Release 1 (11.1)

Database Concepts - Contents

ContentsConventions 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

Database Installation Guide for Microsoft Windows, 11g Release 1 (11.1)

Database Installation Guide - Contents

ContentsConventions 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

Database Security Guide, 11g Release 1 (11.1)

Database Security Guide - Contents

ContentsDocumentation 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

Database Reference, 11g Release 1 (11.1)

Database Reference - Contents

ContentsConventions 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

Database Upgrade Guide, 11g Release 1 (11.1)

Database Upgrade Guide - Contents

ContentsConventions 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

Database Utilities, 11g Release 1 (11.1)

Database Utilities - Contents

ContentsDocumentation 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

Database New Features Guide, 11g Release 1 (11.1)

Database New Features Guide - Contents

ContentsDocuments Conventions 1 Oracle 11g Database New Features 1.1 Application Development 1.1.1 APIs and … in the Database 1.1.5.1 OracleJVM Java/JDK 5.0 Compatibility 1.1.5.2 OracleJVM JIT Configuration … OracleJVM Ease-of-Use: Output Redirect 1.1.5.7 OracleJVM Ease of Use: Database Resident Jars 1.1.5.8 … ANYDATA 1.1.6.4 JDBC Support

Database Data Warehousing Guide, 11g Release 1 (11.1)

Database Data Warehousing Guide - Contents

ContentsConventions 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

Database Backup and Recovery Reference, 11g Release 1 (11.1)

Database Backup and Recovery Reference - Contents

ContentsMAINTENANCE 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

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

Database PL/SQL Packages and Types Reference - Contents

ContentsConventions 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

Database Clusterware Administration and Deployment Guide, 11g Release 1 (11.1)

Clusterware Administration and Deployment Guide - Contents

ContentsConventions 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

Database SQL Language Reference, 11g Release 1 (11.1)

CREATE DATABASE

CREATE DATABASECaution: 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

Database SQL Language Reference, 11g Release 1 (11.1)

FLASHBACK DATABASE

FLASHBACK DATABASEPurpose 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,

Database SQL Language Reference, 11g Release 1 (11.1)

DROP DATABASE

DROP DATABASEPurpose 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 Administrator's Guide, 11g Release 1 (11.1)

Jobs

Database JobsDatabase 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 Administrator's Guide, 11g Release 1 (11.1)

Types of Oracle Database Users

Database AdministratorsEach 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 Administrator's Guide, 11g Release 1 (11.1)

Types of Oracle Database Users

Database UsersDatabase users interact with the database through applications or utilities. A typical user's

Database SQL Language Reference, 11g Release 1 (11.1)

Oracle Database SQL Language Reference, 11g Release 1 (11.1)

Oracle® DatabaseSQL Language Reference 11 g Release 1 (11.1) B28286-07 July 2013 Oracle Database SQL Language

Database Administrator's Guide, 11g Release 1 (11.1)

Session Trees for Distributed Transactions

Database ServersA 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.

Database Administrator's Guide, 11g Release 1 (11.1)

Oracle Database Administrator's Guide, 11g Release 1 (11.1)

Oracle® DatabaseAdministrator's Guide 11 g Release 1 (11.1) B28310-04 March 2008 Oracle Database Administrator's

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Database EventsDatabase 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

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Oracle Database PL/SQL Language Reference, 11g Release 1 (11.1)

Oracle® DatabasePL/SQL Language Reference 11 g Release 1 (11.1) B28370-05 August 2009 Oracle Database PL/SQL

Database SQL Language Reference, 11g Release 1 (11.1)

ALTER DATABASE

ALTER DATABASEPurpose 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 Administrator's Guide, 11g Release 1 (11.1)

Database Links

Database LinksThe 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 SQL Language Reference, 11g Release 1 (11.1)

Graphic Syntax Diagrams

Database ObjectsThe 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 SQL Language Reference, 11g Release 1 (11.1)

Database Objects

Database ObjectsOracle Database recognizes objects that are associated with a particular schema and objects that

Database 2 Day DBA, 11g Release 1 (11.1)

Database 2 Day DBA - Contents

ContentsRelated 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Global Database Names in Database LinksTo 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

Database Administrator's Guide, 11g Release 1 (11.1)

Manually Committing an In-Doubt Transaction: Example

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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Names for Database LinksTypically, 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Types of Database LinksOracle 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Creation of Database Links: ExamplesCreate 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Connected User Database Linkslink 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Schema Objects and Database LinksAfter 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.

Database SQL Language Reference, 11g Release 1 (11.1)

Database Objects

Nonschema ObjectsOther 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Authorization for Accessing Remote Schema Objectsdatabase. 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.

Database SQL Language Reference, 11g Release 1 (11.1)

Database Objects

Schema Objectsdatabase 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Synonyms for Schema ObjectsOracle 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 Administrator's Guide, 11g Release 1 (11.1)

Database Links

Database Link RestrictionsYou 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.

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

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.

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Fixed User Database LinksA 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Current User Database LinksCurrent 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Naming of Schema Objects Using Database LinksOracle 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

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Users of Database LinksWhen 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,

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Schema Object Name Resolutiondatabase 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

Database SQL Language Reference, 11g Release 1 (11.1)

DROP DATABASE LINK

DROP DATABASE LINKPurpose 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,

Database SQL Language Reference, 11g Release 1 (11.1)

Syntax for Schema Objects and Parts in SQL Statements

References to Database LinksDatabase 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 Administrator's Guide, 11g Release 1 (11.1)

Database Data Dictionary Views

Database Data Dictionary Viewsinformation 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

Database Administrator's Guide, 11g Release 1 (11.1)

Dropping a Database

Dropping a DatabaseDropping 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

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Application Development

Distributed Database Application Developmentdevelopment: Transparency in a Distributed Database System Remote Procedure Calls (RPCs) Distributed … Query Optimization See Also: Chapter 31, \"Developing Applications for a Distributed Database System

Database Administrator's Guide, 11g Release 1 (11.1)

Auditing Database Use

Auditing Database UseYou 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.

Database Administrator's Guide, 11g Release 1 (11.1)

Basic Database Administration

Basic Database AdministrationPart 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