Errata

Oracle Scripts

Errata for Oracle Scripts

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Printed
Page xv-xvi
The following information was added to the preface after the

"Comments and Questions" heading:

"We have tested and verified the information in this book to
the best of our ability, but you may find that features have
changed (or even that we have made mistakes!). Please let us
know about any errors you find, as well as your suggestions
for future editions, by writing to:

...

You can also send us messages electronically. To be put on
the mailing list or request a catalog, send email to:

info@oreilly.com

To ask technical questions or comment on the book, send email
to:

bookquestions@oreilly.com

For corrections and amplifications for the book and its
accompanying CD-ROM, check out:

http://www.oreilly.com/catalog/9781565924383/

See the ads at the end of the book for information about all
of O'Reilly & Associates' online services. For more information
about this book and others, see the O'Reilly web site:

http://www.oreilly.com"

The addition of this text threw off the page break for page xvi.

 Anonymous    Jan 01, 2000
Printed
Page xiv
in the "About the CD-ROM," the second "tools.tar" changed to "tools.zip"

Anonymous    Dec 01, 1998
Printed
Page xvi
line 5: After the sentence ending, "...whatever

it took to get the job done" added this sentence:

"Special thanks to John Dockery, without whose invaluable
assistance this book would not have come to fruition."

 Anonymous    Jul 01, 1998
Printed
Page 7
Added paragraph #8 as follows

8. Modify the PATH to include the $TOOLS variable defined in 2. above. In
the Korn or Bourne shells this can be done by adding the following
statement to the user .profile script:

PATH=$PATH:$TOOLS

Although it is not required, you may find it useful to add $DBA to the PATH
as well.

(Note that ".profile" should be in italics)

 Anonymous    Dec 01, 1998
Printed
Page 8
Modified Installation Summary paragraph #1 as follows

1. Create directories for DBA and TOOLS, assign the DBA and TOOLS
environment variables to them, and add $TOOLS to the user PATH.

 Anonymous    Dec 01, 1998
Printed
Page 10
"Calculate the age of a file in days": chapter number should be 11, not 10

Anonymous    Dec 01, 1998
Printed
Page 14
"Replace a fine in RCS" now reads "Replace a file in RCS."

Anonymous    Dec 01, 1998
Printed
Page 15
Last line: added closing ")".

Anonymous    Dec 01, 1998
Printed
Page 26
Under "dbousers.sql,"

"Output File: dbausers.lst" is now spelled correctly (with an "o"):
"Output File: dbousers.lst"

 Anonymous    Dec 01, 1998
Printed
Page 47
Middle of the page


added the word "process" to the sentence beginning "The every5 script..."
to read "The every5 script allows you to establish an automated process
that will..."

 Anonymous    Dec 01, 1998
Printed
Page 73
Changed "archwaitSQL" to "archwait.sql" (lower case .sql).

Anonymous    Dec 01, 1998
Printed
Page 74
Changed "startmgr" to "startm", and "stopmgr" to "stopm".

Anonymous    Dec 01, 1998
Printed
Page 106
Changed "Output File: bad_cons.lis" to


"Output File: bad_cons.lis, <tablename>_drop.sql,
<tablename>_create.sql

(all in italic)

 Anonymous    Dec 01, 1998
Printed
Page 106 and 107
Changed all occurrances of

<table_name>drop.sql to <table_name>_drop.sql
and
<table_name>create.sql to <table_name>_create.sql

 Anonymous    Dec 01, 1998
Printed
Page 136
Changed last sentence under "resize" to

"This script assumes that no foreign key constraints exist for the table."

 Anonymous    Dec 01, 1998
Printed
Page 183
Changed index entry for "reports, security-related" to 52-71.

Anonymous    Dec 01, 1998
Printed
Page 188
Added the following credit to the last paragraph of the Colophon

"The CD design was created by Hanna Dyer."

 Anonymous    Dec 01, 1998