Results for database


1 to 40 of 62098 results. Prev  Next
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 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 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 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 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 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 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 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 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 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 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 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)

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 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)

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)

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





Was this page helpful?

Integrated Cloud Applications & Platform Services