Errata for Oracle Essentials: Oracle8 & Oracle8i

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.

"How to Contact Us
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:
O'Reilly & Associates, Inc.
101 Morris Street
Sebastopol, CA 95472
1-800-998-9938 (in the U.S. or Canada)
1-707-829-0515 (international/local)
1-707-829-0104 (FAX)
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
We have a web site for the book, where we'll list examples,
errata, and any plans for future editions. You can access
this page at:
http://www.oreilly.com/catalog/9781565927087/
For more information about this book and others, see the
O'Reilly web site:
http://www.oreilly.com
See the ads at the end of the book for information about all
of O'Reilly & Associates' online services."
(colophon) The first sentence of the fifth paragraph now reads:
"Ellie Volkhausen designed...based on a series design by Edie
Freedman."

Page 13
The heading "Database Extensibility Options" has been changed to "Database

Extensibility".

Anonymous

Mar 01, 2000

Printed

Page 13
In the last paragraph, "Oracle8i interMedia is an option that bundles..."

has been changed to "Oracle8i interMedia bundles..."

Anonymous

Mar 01, 2000

Printed

Page 14
The Time Series paragraph has been changed to read

"Time Series functions extend the database SQL to provide additional
analysis capabilities for databases in which data has a timestamp
associated with it. The time-based analysis functions provide advanced
functionality such as the computation of moving averages."

"...you simply move or copy these read-only tablespaces from one
database to another..."
Now reads:
"...you simply move or copy these read-only tablespaces after they
have been put in read-only mode from one database to another..."

Anonymous

Mar 01, 2000

Printed

Page 24
Beginning on the first line, the second paragraph did read

"...NT-based systems, and you could acces each repository of
management information by a single database administrator."
Now reads:
"...each repository could only be accessed by a single database
administrator at one time."

Anonymous

Mar 01, 2000

Printed

Page 29
The fourth sentence of the fourth paragraph did read

"Instances are temporal, but databases are, with proper maintenance,
forever."
Now reads:
"Instances are temporal, but databases are, with proper maintenance,
last forever."

Anonymous

Mar 01, 2000

Printed

Page 30
The second sentence of the second paragraph did read

"You cannot change the database name once you create the database..."
Now reads:
"You cannot change the database name once you have created the
database..."
{<37>} The second paragraph did read:
"From a logical point of view, a datafile is composed of data blocks.
From a physical point of view, data files have two intermediate
organizational levels: extents and segments."
Now reads:
"From a physical point of view, a datafile is stored as operating
system blocks. From a logical point of view, data files have three
intermediate organizational levels: datablocks, extents and
segments."

Anonymous

Mar 01, 2000

Printed

Page 39
In Figure 2-5, the bottom group did read

"Group 2"
It now reads:
"Group 3"

Anonymous

Mar 01, 2000

Printed

Page 39
The second paragraph after Figure 2-5 did read

"There are ways you can rebuild the control file..."
Now reads:
"There are ways you can rebuild the static part of the control
file..."

Anonymous

Mar 01, 2000

Printed

Page 41
In Figure 2-6, the bottom group did read

"Group 2"
It now reads:
"Group 3"

Anonymous

Mar 01, 2000

Printed

Page 43
In the last paragraph, the following sentence has been added:

"To avoid such problems first modify the INIT.ORA and then issue the
ALTER DATABASE ARCHIVELOG command."

Anonymous

Mar 01, 2000

Printed

Page 44
In Figure 2-7, the bottom group did read

"Group 2"
It now reads:
"Group 3"

Anonymous

Mar 01, 2000

Printed

Page 45
The last sentence of the first paragraph did read

"...you shut down the instance not the database."
Now reads:
"...you shut down the instance, but you only close the database."

Anonymous

Mar 01, 2000

Printed

Page 45
The fourth line of the last paragraph did read:

"Use of the password file is an added level of security beyond simply
using operating system groups to allow users to start up and shut down
Oracle."
It now reads:
"Use of a password file is a method typically used to implement
remote access security in addition to access security by operating
system, which is typically used locally, i.e, on the database server."

Anonymous

Mar 01, 2000

Printed

Page 45
The fifth sentence of the last paragraph did read:

"The password file can be used to force the entry of a password,
thereby providing more security than just the operating system group."
Now reads:
"However, the database server operating system authentication
always has priority over a password file authentication and cannot
be used to force the entry of a password if operating system
authentication is enabled."

Anonymous

Mar 01, 2000

Printed

Page 46
In Figure 2-8, an additional arrow from the CKPT bgprocess to the

datafiles has been added.

Anonymous

Mar 01, 2000

Printed

Page 57
In the third line of the 2nd paragraph, changed "Edit" to "edit."

Anonymous

Mar 01, 2001

Printed

Page 63
In the first paragraph, the following has been added:

"You need the special privilege SYSOPER or SYSDBA granted through
either the operating system or a password file to start an instance."

Anonymous

Mar 01, 2000

Printed

Page 76
The third line of the code at the top of the page did read

"varchar_field VARCHAR(10)
Now reads:
"varchar_field VARCHAR2(10)"

Anonymous

Mar 01, 2000

Printed

Page 82
The bulleted list at the end of the page did read:

A = 0 is FALSE
A > 0 is FALSE
A < 0 is FALSE
A != 0 is TRUE
Now reads:
None of the following conditions are true for column A if the column
contains a NULL value:
NULL > 0
NULL < 0
NULL = 0
NULL != 0;

Anonymous

Mar 01, 2000

Printed

Page 85
The first paragraph did read

"A view is an Oracle data structure constructed with a SQL statement.
The results of the SQL statement make up the definition
of the view. The SQL statement is stored in the database, while
the data for the view is assembled when data is requested
through the view. You can use a view instead of a table in a
SQL query."
Now reads:
"A view is an Oracle data structure constructed with a SQL statement.
TheSQL statement is stored in the database. When you use a view
in a query,the stored query is executed and the base table
data returned to the user.Views do not contain data, but
represent ways to look at the base table data in a way that
the query specifies."

"...ROWIDs are stored in the leaf pages of the index."
Now reads:
"...ROWIDs are stored in the leaf blocks of the index."

Anonymous

Mar 01, 2000

Printed

Page 97
The fifth paragraph now reads

"When you re-enable the operation of the constraint, you can instruct
Oracle to validate all the data for the constraint or simply start
applying the constraint to the new data."

Anonymous

Mar 01, 2000

Printed

Page 115
The last word on the page has been changed from "synonym" to "synonyms".

Anonymous

Mar 01, 2000

Printed

Page 116
In the second to last paragraph, the heading did read

"Default Roles"
Now reads:
"Default Roles and Privileges"
The first sentence of this section has been changed to read "The following
default roles and sets of privileges..."
The SYSOPER item and SYSDBA item identifies these two items as privilege sets.

Anonymous

Mar 01, 2000

Printed

Page 118
The last sentence of the last paragraph, last sentence did read:

"...only write operations when a user logs on and logs off."
Now reads:
"...only write operations during the time a user is logged on.

Anonymous

Mar 01, 2000

Printed

Page 132
The second sentence of the last paragraph, second sentence did read:

"Fragmentation is the free space' that appears between filled
extents..."
Now reads:
"Fragmentation can be an unwanted phenomenon if it results in small
parts of non-contiguous "free space" that cannot be reused."

Anonymous

Mar 01, 2000

Printed

Page 150
In Figure 6-3, the diagram of the EMC disk array has been changed. The

new figure shows four disks - the box in black across the top half of the four
disk arrays with a label of "Disk 1", "Disk 2", etc. represents a logical disk
composed of a horizontal slice across the array - half of each of the four
physical disks. The text describes this.

Anonymous

Mar 01, 2000

Printed

Page 174
The fourth line of the second paragraph did read:

"...another transaction inserts new rows into the database that would
have been selected..."
Now reads:
"...new rows into the database that should have been selected..."

Anonymous

Mar 01, 2000

Printed

Page 174
The footnote did read:

"The SQL92 standard..."
Now reads:
"The SQL99 standard..."

Anonymous

Mar 01, 2000

Printed

Page 181
In the first line of the 1st paragraph, changed "multversion" to

"multiversion."

Anonymous

Mar 01, 2001

Printed

Page 212
The last sentence on page did read

"That chapter lists all of the applications that Oracle can
paralyze..."
Now reads:
"That chapter lists all of the applications that Oracle can
parallelize..."

Anonymous

Mar 01, 2000

Printed

Page 226
The second sentence of the 2nd paragraph did read

"Ignoring this often repeated piece of advice is probably is the..."
It now reads:
"Ignoring this often-repeated piece of advice is probably the..."

Anonymous

Mar 01, 2001

Printed

Page 297
The heading "Extensibility Options" has been changed to "Extensibility

Features and Options".

Anonymous

Mar 01, 2000

Printed

Page 297
The heading "Time Series Option" has been changed to "Time Series".

Anonymous

Mar 01, 2000

Printed

Page 297
The last sentence of the first Time Series paragraph has been changed

from:
"The Time Series Option, first introduced for Oracle8, provides
functions for analyzing this data through the inclusion of calendar and
time series functions."
to:
"Time Series functions for analyzing this data were first introduced as
an option in Oracle8 and became a standard feature as of Oracle8i
Release 2 (version 8.1.6)."

Anonymous

Mar 01, 2000

Printed

Page 300
The heading "interMedia Option" has been changed to "interMedia".

Anonymous

Mar 01, 2000

Printed

Page 300
The beginning of the first interMedia paragraph did read

"The interMedia option is new to Oracle8i, but..."
Now reads:
"Oracle8i interMedia is now included as of Release 2 (version 8.1.6),
but..."