|Table of Contents|
Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence:
About the Author
Bob Bryla, is an Oracle9i Certified Professional with more than ten years of experience in database design, database application development, training, and database administration. He is currently an internet database analyst and DBA at Land’s End, Inc. in Dodgeville, Wisconsin.
Oracle9i DBA JumpStart
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
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.
Screen reproductions produced with FullShot 99. FullShot 99 © 1991-1999 Inbit Incorporated. All rights reserved. FullShot is a trademark of Inbit Incorporated.
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.
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.