Combined Errata
Page 24
In the NOTE- "hostname:5550" should be changed to "hostname:5500".
Page 53
s
In the statement,"On windows systems, you can create
the PFILE in the
%ORACLE_BASE%\admin\PROD\pfile directory and then put
another PFILE in %ORACLE_HOME%\dbs etc"
should be modified to
"put another PFILE in %ORACLE_HOME%\database etc" Page 141
second NOTE, the word "system" should be changed to "SYSTEM" (fixed font).
Page 167
The first complete CREATE TABLE statement should instead be:
CREATE TABLE employees
(employee_id NUMBER NOT NULL
,hire_date DATE NOT NULL
,first_name VARCHAR2(42)
,last_name VARCHAR2(42)
,payroll_id VARCHAR2(10)
CONSTRAINT uniq_payroll_id UNIQUE
); Page 211
In Table 4.2
The two entries of Table 4.2 on page 211 in the first column "Save Configuration On Shutdown" and "Unavailable from Net Manager" should be swapped. Also, to make the table more understandable, "Unavailable from Net Manager" should be changed to "(Unavailable from Net Manager)" to make it clear that this entry does not have a prompt in Net Manager. Page 214
In the second paragraph on page 214, "select the listener" should be replaced with "select Listeners".
Page 216
On page 216, first paragraph, change "You will then see the new listener listed in the listener control screen" to "You will then see the new listener listed on the Listeners screen".
Page 226
(FAILOVER=ON) is needed in the tsnnames.ora file for connect-time failover just after ADDRESS_LIST=
Page 278
Table 5.1-Caption, "DISPATCHER" should be changed to "DISPATCHERS".
Page 325
The create role statement "CREATE ROLE app1-dba;"
should be replaced with "CREATE ROLE
app1_dba IDENTIFIED BY seekwrit;", because the role is
enabled with a SET ROLE statement which
has a IDENTIFIED BY clause in the statement,"SET ROLE
app1_dba IDENTIFIED BY seekwrit;".
Yes, while the two statements at the top of page 325 will technically not generate a syntax error, the IDENTIFIED BY in the second statement is not validated if the role itself does not have a password. Therefore, the first statement "CREATE ROLE appl_dba;" should be replaced with "CREATE ROLE appl_dba IDENTIFIED BY seekwrit;". Page 360
line #8 of the INSERT FIRST statement should be changed from..
line #8 of the INSERT FIRST statement should be changed from "INTO property_premium_fact(policy_id" to "INTO casualty_premium_fact(policy_id". Page 367
In the line,"Events can be created on DML events, DLL events..." 'DLL' should be replaced with 'DDL'.
Page 390
In table 7.7, "aata" should instead be "data".
Page 413
On the last line of page 413,
On the last line of page 413, "UR * UPS" should instead be "UR * UPS * DB_BLOCK_SIZE" Page 470
Three errors in the third paragraph of the text box at the top of page 470:
- "(1 + Warning %/100)" should be changed to "(1 - Warning Percentage/100)" (two errors fixed here, one for consistency with the wording earlier on the page)
- "or 15, raising" should be changed to "or 15MB, raising"
- "below 15 percent." should be changed to "below 15MB."
Page 472
The last sentence of the second paragraph should read "Background process trace files are found in the directory specified by the BACKGROUND_DUMP_DEST parameter, and the user process trace files are found in the directory specified by the USER_DUMP_DEST parameter. Both of these parameters are defined in the PFILE or SPFILE." Page 477
In the statement,"Using the Indexes screen...recompile
indexes..", should be replaced with "Using
the Indexes screen... rebuild indexes..". Indexes are
rebuilt.
The screen reference is correct; in Figure 9.55 we're only showing that the index is unusable at this point, and fixing the index later.
However, in the first paragraph on page 477, "JOBS_ID_PK" should be changed to "JOB_ID_PK".
|
Add to Cart
