Errata
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 xii changed the O'Reilly address to regular (not bold) type |
Anonymous | Oct 01, 1997 | ||
Printed | Page xiii changed "Rob Romano" to "Robert Romano" |
Anonymous | Oct 01, 1997 | ||
Printed | Page xii The following information was added to the preface |
"How to Contact Us |
Anonymous | Jan 01, 2000 | |
Printed | Page 2 deleted the extra period from the sentence just before the figure |
Anonymous | Oct 01, 1997 | ||
Printed | Page 7 second para: changed "index-only table" to "table of organization |
index" and "Such tables are ideal for ..." to "Such tables appear |
Anonymous | Jan 01, 1998 | |
Printed | Page 7 third para: changed "index-only tables" to "tables of organization index" |
Anonymous | Jan 01, 1998 | ||
Printed | Page 7 last line: changed "abstract data types (or ADTs)" to |
"user-defined data types (or UDTs)" |
Anonymous | Jan 01, 1998 | |
Printed | Page 8 first para - line 5: changed "ADT" to "UDT" |
Anonymous | Jan 01, 1998 | ||
Printed | Page 8 first para - line 6: changed "abstract" to "user-defined" |
Anonymous | Jan 01, 1998 | ||
Printed | Page 10 para under the heading The Type System |
"User-defined types are known formally as abstract data types |
Anonymous | Jan 01, 1998 | |
Printed | Page 10 para under the heading The Type System in both line 7 and line 8 |
changed "ADTs" to "UDTs" |
Anonymous | Jan 01, 1998 | |
Printed | Page 10 code example at bottom of page, first line |
... AS OBJECT { |
Anonymous | Jan 01, 1998 | |
Printed | Page 10 code example at bottom of page, lines 5 to 7 |
MEMBER FUNCTION area RETURN NUMBER); |
Anonymous | Jan 01, 1998 | |
Printed | Page 10 line -4 |
CREATE OR REPLACE TYPE BODY circle |
Anonymous | Apr 01, 1999 | |
Printed | Page 11 at end of page add new para |
Perhaps more importantly, Oracle's Object Database Designer |
Anonymous | Jan 01, 1998 | |
Printed | Page 21 chapter contents: changed "ENFORCE option" to "NOVALIDATE |
option" |
Anonymous | Jan 01, 1998 | |
Printed | Page 22 first bullet point (middle of page), second line: changed |
"trigger" to "view" |
Anonymous | Jan 01, 1998 | |
Printed | Page 23 para starting "The INSTEAD OF trigger carries no such ..." |
"However, if the insert has resulted in a duplicate ..." |
Anonymous | Jan 01, 1998 | |
Printed | Page 28 Para before heading 3GL callouts: added |
We would also caution that the performance of these features should be |
Anonymous | Jan 01, 1998 | |
Printed | Page 35 Heading "ENFORCE Option" changed to "NOVALIDATE option" |
Anonymous | Jan 01, 1998 | ||
Printed | Page 35 Section on ENFORCE Option - para 3, first sentence |
Oracle has an option ... rather than enable it. |
Anonymous | Jan 01, 1998 | |
Printed | Page 35 Section on ENFORCE Option - code example |
ALTER TABLE my_tab ENFORCE CONSTRAINT mt_ccl; |
Anonymous | Jan 01, 1998 | |
Printed | Page 35 Section on ENFORCE Option - last para: after "... having to check |
every row." |
Anonymous | Jan 01, 1998 | |
Printed | Page 53 last two sentences |
"Of course for .... discussed in the next section" |
Anonymous | Jan 01, 1998 | |
Printed | Page 55 and 56 deleted everything from "Well it only needs to scan that |
one partition ..." to "... which are entirely within a single |
Anonymous | Jan 01, 1998 | |
Printed | Page 56 TIP - line 2: changed "local prefixed" to "locally partitioned" |
Anonymous | Jan 01, 1998 | ||
Printed | Page 56 TIP - line 3: remove the word "can" |
Anonymous | Jan 01, 1998 | ||
Printed | Page 57 Figure 4-4: "Equi-partitioned index" changed to "Locally |
partitioned index" |
Anonymous | Jan 01, 1998 | |
Printed | Page 57 Figure 4-4: in every case where a little grid was labelled |
"Index", it is now labelled "Index Partition" (6 cases) |
Anonymous | Jan 01, 1998 | |
Printed | Page 57 Figure 4-4: EXCEPT FOR THE LOWER RIGHT, every case where a little |
grid was labelled "Table", it is now labelled "Table Partition" (4 |
Anonymous | Jan 01, 1998 | |
Printed | Page 58 Para under heading Unusable Index Partitions: Last sentence |
"For this reason ... rather than globally, partitioned." |
Anonymous | Jan 01, 1998 | |
Printed | Page 58 Para under heading Locally Prefixed Partitions, line 1: changed |
"need" to "have" |
Anonymous | Jan 01, 1998 | |
Printed | Page 60 Heading "Index-Only Tables" changed to "Tables of Organization |
Index" |
Anonymous | Jan 01, 1998 | |
Printed | Page 61 second para |
"... it also has to be both backed up and restored." |
Anonymous | Jan 01, 1998 | |
Printed | Page 61 - third para |
" ... new type of object called an index-only table." |
Anonymous | Jan 01, 1998 | |
Printed | Page 61 third para, line 5 |
" ... call it an index-only table." |
Anonymous | Jan 01, 1998 | |
Printed | Page 61 third para, line 8 |
" ... before you decide to use index-only tables ..." |
Anonymous | Jan 01, 1998 | |
Printed | Page 65 bullet point starting "Constraints" |
"Constraints cannot be defined on ... constraints." |
Anonymous | Jan 01, 1998 | |
Printed | Page 71 last line: "... as far as we can tell ..." changed to "... sadly |
..." |
Anonymous | Jan 01, 1998 | |
Printed | Page 73 paragraph at top of page - first 6 lines |
"Oracle had continually asked ... as much as 10 megabytes." |
Anonymous | Jan 01, 1998 | |
Printed | Page 73 paragraph at top of page - last sentence: changed "Needing a |
terabyte for the database is one thing ..." to "Needing 100Gb for the |
Anonymous | Jan 01, 1998 | |
Printed | Page 73 second para - line 3: changed "... requires connection sharing |
..." to "... requires true connection sharing ..." |
Anonymous | Jan 01, 1998 | |
Printed | Page 76 TIP - first para - second sentence |
"If necessary, you can specify each bitmap for |
Anonymous | Jan 01, 1998 | |
Printed | Page 76 TIP - second para. typeface fixed to match first para. |
Anonymous | Jan 01, 1998 | ||
Printed | Page 77 WARNING - second para: fixed this typeface too |
Anonymous | Jan 01, 1998 | ||
Printed | Page 77 para under the WARNING - last two sentences |
"... lock conflicts are almost inevitable ... values |
Anonymous | Jan 01, 1998 | |
Printed | Page 80 second para, code example, final para before APPEND heading |
"In Oracle8, you can use ...as we describe in the next section." |
Anonymous | Jan 01, 1998 | |
Printed | Page 81 heading "Direct-Path Inserts" changed to "Direct-Load Insert" |
Anonymous | Jan 01, 1998 | ||
Printed | Page 81 para under heading Direct-Path Inserts, line 1: changed |
"direct-path INSERT" to "direct-load INSERT" |
Anonymous | Jan 01, 1998 | |
Printed | Page 84 sidebar A Question of Terminology, line 12 |
"... have been competing to provide (much as they ..." |
Anonymous | Jan 01, 1998 | |
Printed | Page 89 - second code example |
"SELECT p.proj_name |
Anonymous | Jan 01, 1998 | |
Printed | Page 95 - first para |
"It may be that REFs will give faster navigation ... |
Anonymous | Jan 01, 1998 | |
Printed | Page 95 para after heading Abstract Data Types (ADTs) - first sentence |
" ... described through the data dictionary." |
Anonymous | Jan 01, 1998 | |
Printed | Page 95 para after WARNING, line 2 |
" ... features of ADTs in general. ..." |
Anonymous | Jan 01, 1998 | |
Printed | Page 96 first para, line 5 |
" ... since one of Oracle's major projected uses ..." |
Anonymous | Jan 01, 1998 | |
Printed | Page 96 first code example, line 5 |
" , event_codeNUMBER NOT NULL REFERENCES event_codes" |
Anonymous | Jan 01, 1998 | |
Printed | Page 96 second code example |
" ... dateonly(trunc(sysdate));" |
Anonymous | Jan 01, 1998 | |
Printed | Page 96 para under second code example, line 4 |
"... constructor function offers a natural ..." |
Anonymous | Jan 01, 1998 | |
Printed | Page 97 lines 1 and 2, and twice in Warning: changed "ADTs" to "UDTs" |
Anonymous | Jan 01, 1998 | ||
Printed | Page 107 chapter contents: changed "Object Designer" to "Object Database |
Designer (ODD)" |
Anonymous | Jan 01, 1998 | |
Printed | Page 110 same change as on p. 107 |
Anonymous | Jan 01, 1998 | ||
Printed | Page 110 - 111 under heading Object Designer: replaced entire section |
with: |
Anonymous | Jan 01, 1998 | |
Printed | Page 112 first para, last line |
"... for managing the user interface." |
Anonymous | Jan 01, 1998 | |
Printed | Page 112 under heading C, C++ and OCI, second para, line 1 |
"... from Object Designer may ..." |
Anonymous | Jan 01, 1998 | |
Printed | Page 114 second para, line 6 |
"(Great word, soon.." |
Anonymous | Jan 01, 1998 | |
Printed | Page 114 last line on page: spelled "scalable" correctly |
Anonymous | Jan 01, 1998 |