Oracle Essentials: Oracle 8 and Oracle 8i by Rick Greenwald, Robert Stackowiak, & Jonathan Stern This page contains changes made in the 10/00 printing. Here's a key to the markup: [page-number]: serious technical mistake {page-number}: minor technical mistake : important language/formatting problem (page-number): language change or minor formatting problem ?page-number?: reader question or request for clarification **NOTE: Chapter 14 has been replaced in this printing, and the index has been updated.** (vii) Added "The Data Dictionary.....................................50" to Chapter 2 in the Table of Contents. (x) The third entry in the TOC under Chapter 14 did read: "Oracle in the Middle Tier" Now reads: "Oracle Internet Application Server" (x) The fourth entry in the TOC under Chapter 14 did read: "Oracle Tools and the Internet Client" Now reads: "Oracle Portal" (xiv) The third line of the second paragraph did read: "Oracle Application Server, WebDB, and Java." Now reads: "Oracle Internet Application Server, Oracle Portal, and Java." (29) The last sentence in the fourth paragraph did read: "Instances are temporal, but databases are, with proper maintenance, last forever." Now reads: "Instances are temporal, but databases, with proper maintenance, last forever." (30) The fourth line in the first paragraph did read: "The instance is static: no changes can occur to it." Now reads: "The database is static: no changes can occur to it." (34) The third sentence in the fourth paragraph did read: "You might conclude that if storing the control file..." Now reads: "You might conclude that storing the control file..." (40) The second sentence in the 4th paragraph did read: "The the operating system..." Now reads: "The operating system..." (60) The first bullet under the topic "Net8 Configuration Files" did read: "On NT ORACLE_HOME\net80\admin AND Oracle 8.0 and ORACLE_HOME\network\admin for Oracle8i" Now reads: "On NT ORACLE_HOME\net80\admin FOR Oracle 8.0 and ORACLE_HOME\network\admin for Oracle8i" {69} Item number 6 in the numbered list did read: "The next available shared server process reads the request from the response queue and does the work." Now reads: "The next available shared server process reads the request from the request queue and does the work." (78) In the third line of the 2nd paragraph, changed "DD-MON-YY:HH:MI:SS" to "DD-MON-YY HH:MI:SS." {85} In the last paragraph, the SQL used as an example did read: CREATE INDEX emp_ename_job_idex ON emp (ename, job); Now reads: CREATE INDEX emp_idx1 ON emp (ename, job); {87} An arrow pointing from the rightmost branch block to the rightmost leaf block was added to Figure 4-1. [88] The second sentence in the 5th paragraph did read: "Figure 4-2 shows an illustration of how a bitmapped index is stored and used in a selection condition." Now reads: "Figure 4-2 shows an illustration of how a bitmapped index is stored. Figure 9-13 on page 213 shows how a bitmapped index is used in a selection condition." (93) The fourth line of the first paragraph in the sidebar did read: "...second normal form (2FN), and so on." Now reads: "...second normal form (2NF), and so on." (125) Figure 5-1: "Respository" was changed to "Repository." (133) The first bulleted item on the page did read: "* Segment fragmentation (i.e., segments consisting of multiple extents)" Now reads: "* Segment fragmentation (i.e., "holes" in segments consisting of multiple extents)" (204) The first sentence of the first paragraph did read: "...it handles a variety of purposes..." Now reads: "...it serves a variety of purposes..." (220) The second sentence of the fourth paragraph did read: "These users need ad hocad hoc query tools." Now reads: "These users need ad hoc query tools." (269) The second sentence in the last paragraph did read: "...the sum of the execution time of all serial operations is directly added to any performance gains..." Now reads: "...the sum of the execution time of all serial operations can offset any performance gains..." (297) The heading "Extensibility Features and Options" was changed to "Extensibility Options." <304-325> Chapter 14 has been replaced. (328) In the first paragraph, changed "devleopers" to "developers" and "softoware" to "software." (352, Index) The entry for "SGL standard" was changed to "SQL standard." <335-355> The index has been replaced. (Colophon) Paragraph 5; Changed "Ellie Volkenhausen" to "Ellie Volckhausen."