Oracle Essentials
by Rick Greenwald, Robert Stackowiak, & Jonathan Stern


Following are the changes made in the 3/00 reprint.


Here's a key to the markup:

        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification


(13) The heading "Database Extensibility Options" has been changed to "Database
Extensibility".


(13) In the last paragraph, "Oracle8i interMedia is an option that bundles..."
has been changed to "Oracle8i interMedia bundles..."


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


(14) Table 1-3 Heading did read:

	"Oracle8i Database Extensibility Options"

Now reads:

	"Oracle8i Database Extensibility"


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


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



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


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


(39) In Figure 2-5, the bottom group did read:

        "Group 2"

It now reads:

        "Group 3"


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


(41)  In Figure 2-6, the bottom group did read:

        "Group 2"

It now reads:

        "Group 3"


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


(44) In Figure 2-7, the bottom group did read:

        "Group 2"

It now reads:

        "Group 3"


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


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


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


[46] In Figure 2-8, an additional arrow from the CKPT bgprocess to the 
datafiles has been added.


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


{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)"


[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;


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


?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);"


{87} In Figure 4-1, "Leaf nodes" now reads "Leaf blocks".


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


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


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


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


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


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

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


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


(174) The footnote did read: 

	"The SQL92 standard..."

Now reads:

         "The SQL99 standard..."


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


(297) The heading "Extensibility Options" has been changed to "Extensibility
Features and Options".


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


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


(300) The heading "interMedia Option" has been changed to "interMedia".


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


(301) The first sentence on the page did read:

	"The interMedia option utilizes..."

Now reads:

	"Oracle8i interMedia untilizes..."