Oracle9i DBA JumpStart | Oracle9i DBA JumpStart

Bob Bryla

Associate Publisher: Neil Edde

Acquisitions Editor: Elizabeth Hurley Peterson

Developmental Editor: Heather O’Connor

Production Editor: Leslie E.H. Light

Technical Editor: Betty MacEwen

Copyeditor: Marilyn Smith

Compositor: Kate Reber, Happenstance Type-O-Rama

Graphic Illustrator: Jeffery Wilson, Happenstance Type-O-Rama

Proofreaders: Nancy Riddiough, Monique Van Den Berg, and Emily Hsuan

Indexer: Ann Rogers

Book Designer: Maureen Forys, Happenstance Type-O-Rama

Cover Designer: Archer Design

Cover Illustrator/Photographer: Archer Design

Copyright 2003 SYBEX Inc., 1151 Marina Village Parkway, Alameda, CA 94501. World rights reserved. No part of this publication may be stored in a retrieval system, transmitted, or reproduced in any way, including but not limited to photocopy, photograph, magnetic, or other record, without the prior agreement and written permission of the publisher.

Library of Congress Card Number: 2002115476

ISBN: 0-7821-4189-7

JumpStart is a trademark of SYBEX Inc.

SYBEX and the SYBEX logo are either registered trademarks or trademarks of SYBEX Inc. in the United States and/or other countries.

Internet screen shot(s) using Microsoft Internet Explorer 6 reprinted by permission from Microsoft Corporation.

SYBEX is an independent entity from Oracle Corporation and is not affiliated with Oracle Corporation in any manner. This publication may be used in assisting students to prepare for an Oracle Certified Professional exam. Neither Oracle Corporation nor SYBEX warrants that use of this publication will ensure passing the relevant exam. Oracle is either a registered trademark or a trademark of Oracle Corporation in the United States and/or other countries.

TRADEMARKS: SYBEX has attempted throughout this book to distinguish proprietary trademarks from descriptive terms by following the capitalization style used by the manufacturer.

The author and publisher have made their best efforts to prepare this book, and the content is based upon final release software whenever possible. Portions of the manuscript may be based upon pre-release versions supplied by software manufacturer(s). The author and the publisher make no representation or warranties of any kind with regard to the completeness or accuracy of the contents herein and accept no liability of any kind including but not limited to performance, merchantability, fitness for any particular purpose, or any losses or damages of any kind caused or alleged to be caused directly or indirectly from this book.

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

For MCL and the kids.

Acknowledgments

I couldn’t have written this book without the help of many talented and creative people.

I would like to thank Neil Edde, associate publisher, and Elizabeth Hurley, acquisitions editor, for recognizing the need for an introductory Oracle DBA text. Many thanks to developmental editor Heather O’Connor for telling me in the nicest possible way when I was way out in left field, and production editor Leslie Light and copyeditor Marilyn Smith for their valuable advice. Thanks also to technical editor Betty MacEwen for her attention to detail and helpful suggestions throughout the book.

The nature of this book required a great deal of artwork. Jeffery Wilson and the rest of Happenstance Type-O-Rama did an excellent job of creating artwork that was appropriate for the book. They say a picture is worth a thousand words, and their art is an essential part of this book. Somehow they were able to decipher my Microsoft Word cave drawings and turn them into real graphics.

Many of my professional colleagues at both Lands’ End and Greenbrier & Russel were a source of both inspiration and guidance. Also, regards to my long lost friend from fourth grade, Janice, who I’m sure is a DBA out there somewhere.

Finally, I want to thank my family for all of their support and patience. I was still able to give the kids a bath and read books at bedtime, even with the tough deadlines. The journey wouldn’t have been half the fun without them.