Oracle Security Overview presents the basic concepts of data security in an Internet environment. It outlines fundamental data security requirements and explains the risks that threaten the integrity and privacy of your data. Several chapters introduce the rich array of technology that can contribute to system security. The book concludes with a survey of the Oracle features and products that implement these technologies.

Adds specified text to the end of the current line in the SQL buffer. To separate text from the preceding characters with a space, enter two spaces. To append text that ends with a semicolon, end the command with two semicolons (a single semicolon is interpreted as a command terminator).

This quick reference contains a high-level description of the Structured Query Language (SQL) used to manage information in an Oracle database. Oracle SQL is a superset of the American National Standards Institute (ANSI) and the International Standards Organization (ISO) SQL:2003 standard.

Part I presents fundamental concepts of data security requirements and threats that pertain to connecting to a database, accessing and altering tables, and using applications. In addition, security checklists are provided for DBAs and application developers, which cover installation preparation, database administration best practices, and recommendations for developing secure applications.

Oracle Database Utilities is intended for database administrators (DBAs), application programmers, security administrators, system operators, and other Oracle users who perform the following tasks: - Archive data, back up an Oracle database, or move data between Oracle databases using the Export and Import utilities (both the original versions and the Data Pump versions) - Load data into Oracle tables from operating system files using SQL*Loader or from external sources using the external tables feature - Perform a physical data structure integrity check on an offline database, using the DBVERIFY utility...

During a complete installation of Oracle Database, the Sample Schemas can be installed automatically with the seed database. If for some reason the seed database is removed from your system, you will need to reinstall the Sample Schemas before you can duplicate the examples you find in Oracle documentation and training materials.

Recovery Manager Reference is intended for database administrators who perform the following tasks: - Back up, restore, and recover Oracle databases - Perform maintenance on backups and copies of database files To use this document, you need to know the following: - Relational database concepts and basic database administration as described in Oracle Database Concepts and the Oracle Database Administrator's Guide - Basic RMAN concepts and tasks as described in Oracle Database Backup and Recovery Basics - The operating system environment under which you are running Oracle...

Oracle Database Backup and Recovery Advanced User's Guide presents in-depth information on RMAN architecture, backup and recovery concepts and mechanisms, advanced recovery techniques such as point-in-time recovery and database flashback features, and backup and recovery performance tuning. It also covers user-managed backup and recovery, using host operating system facilities instead of RMAN. This volume is essential for backup and recovery of more sophisticated database deployments, and for advanced recovery scenarios....

This document describes the tasks to install Oracle Database 10g Standard Edition on a Windows two-node cluster, using Real Application Clusters (RAC) and Automated Storage Management (ASM). This install also builds a general purpose starter database with the Sample Schemas included and with automatic disk backup enabled.

This section describes the RAC documentation set. The platform-specific Oracle Database 10g CD contains a copy of this book, the Oracle Real Application Clusters Installation and Configuration Guide in both HTML and PDF formats. This book contains the pre-installation, installation, and post-installation information for all UNIX- and Windows-based platforms on which RAC operates. If you are installing Oracle Database 10g Standard Edition with RAC on a Windows-based system, then refer to the Oracle Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition for Windows. Additional information for this release may be available in the Oracle Database 10g README or Release Notes....

The Oracle Spatial User’s Guide and Reference provides usage and reference information for indexing and storing spatial data and for developing spatial applications using Oracle Spatial and Oracle Locator. Oracle Spatial requires the Enterprise Edition of Oracle Database 10g. It is a foundation for the deployment of enterprise-wide spatial information systems, and Web-based and wireless location-based applications requiring complex spatial data management. Oracle Locator is a feature of the Standard and Enterprise Editions of Oracle Database 10g. It offers a subset of Oracle Spatial capabilities (see Appendix B for a list of Locator features) typically required to support Internet and wireless service applications and partner-based geographic information system (GIS) solutions...

The Oracle Real Application Clusters Administrator's Guide also describes how to use the Server Control (SRVCTL) utility to start and stop the database and instances, manage configuration information, and to delete or move instances and services. You can also use the appendix to resolve various RAC tools error and informational messages. A troubleshooting section describes how to interpret the content of various RAC-specific log files. In addition to this book, the Oracle Real Application Clusters Deployment and Performance Guide is on the Server Documentation CD and the Oracle Real Application Clusters Installation and Configuration Guide is on your platform CD as described under the following headings:...

Oracle Database on Windows is a stable, reliable, and high performing system upon which to build applications. Each release of the database provides new platform-specific features for high performance on Windows.

This document describes the features of Oracle Database for Windows software installed on Windows NT Server, Windows 2000, Windows XP Professional, and Windows Server 2003 operating systems. This guide is your primary source of introductory and reference information for Oracle Database for Windows for both client and server. Differences between product versions are noted where appropriate.

Oracle supplies many PL/SQL packages with the Oracle server to extend database functionality and provide PL/SQL access to SQL features. You can use the supplied packages when creating your applications or for ideas in creating your own stored procedures.

The Oracle Call Interface (OCI) is an application programming interface (API) that allows applications written in C or C++ to interact with one or more Oracle database servers. OCI gives your programs the capability to perform the full range of database operations that are possible with an Oracle database server, including SQL statement processing and object manipulation.

An option is a special type of analytic workspace object that specifies the characteristic of some aspect of how Oracle OLAP calculates or formats data or what Oracle OLAP operations are activated. You cannot define an option as part of a workspace. However, you can use any of the options that are defined as part of the Oracle OLAP DML.

The Oracle OLAP DML Reference provides a complete description of the OLAP Data Manipulation Language (OLAP DML) used to define and manipulate analytic workspace objects. Part I briefly describes how to use the OLAP DML. Part II consists of a reference topic for each of the OLAP DML statements. This manual is intended for programmers and database administrators who create and modify analytic workspaces and analytic workspace objects using the OLAP DML

Oracle Net Services provides control utilities to administer listeners, Oracle Names servers, and Oracle Connection Managers. Part 1 lists the commands that are available with each utility, including any applicable prerequisites, passwords, syntax or argument rules, and usage notes or examples to help you use them.

This section describes the RAC documentation set. This book, the Oracle Real Application Clusters Deployment and Performance Guide, highlights the main deployment topics for RAC by briefly describing Cluster Ready Services (CRS), storage, database creation, and services deployment in RAC. Design and deployment topics in this book describe service topologies and workload management in RAC. Specifically, this book describes how the Automatic Workload Repository tracks and reports service levels and how you can use service level thresholds and alerts to improve high availability in your RAC environment. There is also a services deployment example in the appendix of this book that you can use to learn more about...