Errata

Oracle in a Nutshell

Errata for Oracle in a Nutshell

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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 31
Second Paragraph

Default of Distributed_Transactions is TRANSACTIONS*0.25 not *25 as printed.
Also this parameter is depreciated in Oracle 9.2

 Anonymous   
Printed Page 34
Second line

There are a whole lot of zeros in both the minimum and maximum values for
JAVA_POOL_SIZE, and the default has quite a few less zeros. Therefore, there is
either an error in the default (numerically or missing a multiplier) or there is an
error in the minimum.

 Anonymous   
Printed Page 36
Forth Paragraph

TRANSACTIONS Parameter

Value: 4-2^32 (not 4-232 as printed)
Default: 1.1*SESSIONS (not 11*SESSIONS as printed)

 Anonymous   
Printed Page 238
ALTER TABLE

DROP COLUMN syntax omitted.

 Anonymous   
Printed Page 280
Select

the SAMPLE clause is missing paranthesis. It is listed as:

| table_name SAMPLE [BLOCK] sample_percent [AS OF {SCN | TIMESTAMP} expr]
it should read:
| table_name SAMPLE [BLOCK] (sample_percent) [AS OF {SCN | TIMESTAMP} expr]

 Anonymous   
Printed Page 319
in the definition of MAKE_REF

in the definition of MAKE_REF, the underscore is missing from the definition

 Anonymous  Feb 22, 2012 
Printed Page 417
First paragraph

PROCEDURE DBMS_LOB.FREETEMPORARY ( ... ) ...
New with Oracle9i.
should read:
New with Oracle8i.

 Anonymous   
Printed Page 427
DBMS_METADATA, last procedure

Last procedure is called
GET_GRANTED_XML.
Should be
GET_GRANTED_DDL.

 Anonymous