Oracle in a Nutshell by David C. Kreines, Rick Greenwald The unconfirmed error reports are from readers. They have not yet been approved or disproved by the author or editor and represent solely the opinion of the reader. 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 This page was updated September 29, 2004. UNCONFIRMED errors and comments from readers: {31} Second Paragraph; Default of Distributed_Transactions is TRANSACTIONS*0.25 not *25 as printed. Also this parameter is depreciated in Oracle 9.2 {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. {36} Forth Paragraph; TRANSACTIONS Parameter Value: 4-2^32 (not 4-232 as printed) Default: 1.1*SESSIONS (not 11*SESSIONS as printed) [238] ALTER TABLE; DROP COLUMN syntax omitted. (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] [417] First paragraph; PROCEDURE DBMS_LOB.FREETEMPORARY ( ... ) ... New with Oracle9i. should read: New with Oracle8i. (427) DBMS_METADATA, last procedure Last procedure is called GET_GRANTED_XML. Should be GET_GRANTED_DDL.