Expert Oracle Database 10g Administration

1. Front Matter

   Pages i-xxvii

   PDF

2. Background, Data Modeling, and UNIX/Linux

   1. Front Matter

      Pages 1-1

      PDF

   2. The Oracle DBA’s World

      Pages 3-17

   3. Relational Database Modeling and Database Design

      Pages 19-41

   4. Essential UNIX (and Linux) for the Oracle DBA

      Pages 43-95

3. Oracle Database 10g Architecture, Schema, and Transaction Management

   1. Front Matter

      Pages 97-97

      PDF

   2. Introduction to the Oracle Database 10g Architecture

      Pages 99-144

   3. Schema Management

      Pages 145-224

   4. Oracle Transaction Management

      Pages 225-275

4. Installing Oracle Database 10g, and Creating and Upgrading Databases

   1. Front Matter

      Pages 277-277

      PDF

   2. Installing the Oracle Database 10g RDBMS

      Pages 279-313

   3. Upgrading to Oracle Database 10g

      Pages 315-328

   4. Creating an Oracle Database

      Pages 329-388

5. Connectivity and User Management

   1. Front Matter

      Pages 389-389

      PDF

   2. Connectivity and Networking

      Pages 391-420

   3. User Management and Database Security

      Pages 421-490

   4. Using SQL*Plus and iSQL*Plus

      Pages 491-536

6. Data Loading, Backup, and Recovery

   1. Front Matter

      Pages 537-537

      PDF

   2. Loading and Transforming Data

      Pages 539-587

   3. Using Data Pump Export and Import

      Pages 589-630

This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examplesnot just "showcase" examples.

This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring Oracle database administrator needs to build and administer complex Oracle 10g databases.

• Oracle
• RDBMS
• SQL
• SQL programming
• UNIX
• data model
• database design
• database modeling
• relational database

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

Policies and ethics