Oracle 8 how-to

Addressing practical, real-world database issues in a clear, easy-
to-understand language, Oracle8 How-To covers all the solutions
related to Oracle architecture, security, storage management,
and performance tuning. Find the additional detailed information
on Oracle networking, distributed databases, advanced
replication, and backup and recovery. Unlike other books, this
Oracle instructional doesn't focus only on theory-rather it includes
examples that take the guesswork out of performing database
administration tasks.

Each section begins with a succinct statement of a particular
database question. The authors present definitive answers in a
step-by-step format augmented by concise descriptions of the
outcome of each step. Additional comments at the end of each
section explain the authors' real-world experience with the
section's technique. In this single volume, you'll discover the right
questions to ask, you'll learn how to answer them, and you'll see
how to make the leap from textbook theory to production database
application.

The Web site includes all the source code found in the book,
database scripts, and PL/SQL programs for many of the
platforms supporting Oracle.

Oracle8 How-To shows you
how to:

• Create user accounts
  
• Grant and determine user disk
  quotas
  
• Create an object view and
  updateable join views
  
• Administer very large databases
  (VLDBs) with table and index
  partitioning
  
• Create, mirror, and copy control
  files
  
• Communicate with a new
  Oracle instance from SQL*Plus
  
• View and modify SQL*Plus
  system variables
  
• Extend object orientation to
  existing relational databases with
  object views
  
• Grant system and object
  privileges
  
• Determine privileges associated
  with a role
  
• Detect objects close to
  maximum extents
  
• Use PL/SQL to issue single/multiple
  queries with implicit/explicit cursors
  
• Use VARRAYs and nested tables to
  enhance performance and better
  model the "real world"
  
• Manipulate large objects (LOBs) with
  the DBMS-LOB package