Errata

Oracle Essentials: Oracle8 & Oracle8i

Errata for Oracle Essentials: Oracle8 & Oracle8i

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
The following information was added to the preface

"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."

 Anonymous    Jan 01, 2000
Printed
Page 3
The first line on the page did read:

"...relational users dodn't need to..."

It now reads:

"...relational users don't need to..."

 Anonymous    Mar 01, 2001
Printed
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."

 Anonymous    Mar 01, 2000
Printed
Page 14
Table 1-3 Heading did read

"Oracle8i Database Extensibility Options"

Now reads:

"Oracle8i Database Extensibility"

 Anonymous    Mar 01, 2000
Printed
Page 20
The third line of the third paragraph did read

"...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."

 Anonymous    Mar 01, 2000
Printed
Page 85
The syntax section at the bottom of the page did read

"CREATE INDEX emp_idx1 ON emp (ename, job);"

It now reads:

"CREATE INDEX emp_ename_job_idx ON emp (ename, job);"

 Anonymous    Mar 01, 2000
Printed
Page 87
In Figure 4-1, "Leaf nodes" now reads "Leaf blocks".

Anonymous    Mar 01, 2000
Printed
Page 88
In the fourth paragraph, the first sentence did read:

"...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..."

 Anonymous    Mar 01, 2000
Printed
Page 301
The first sentence on the page did read

"The interMedia option utilizes..."

Now reads:

"Oracle8i interMedia untilizes..."

 Anonymous    Mar 01, 2000
Printed
Page 353

<353> Changed "SQL standard" to "SQL92 standard".

Anonymous    Mar 01, 2001