Cover image for Oracle8 to Oracle8i upgrade
Title:
Oracle8 to Oracle8i upgrade
Author:
Freeman, Robert G., 1965-
Personal Author:
Publication Information:
Scottsdale, AZ : Coriolis Group Books, [2001]

©2001
Physical Description:
xxxvi, 410 pages ; 23 cm.
General Note:
"Exam 1Z0-020"--Cover.
Language:
English
Title Subject:
ISBN:
9781576107379
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.76.D47 F74 2001 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Covers the published objectives for the Oracle 8i: New Features for Administrators exam. Contains key terms and acronyms an Oracle 8i Certified DBA is expected to know to pass the exam.


Table of Contents

Introductionp. xxi
Self-Assessmentp. xxxi
Chapter 1 Oracle OCP Certification Examsp. 1
Assessing Exam-Readinessp. 2
The Testing Situationp. 3
Test Layout and Designp. 4
Using Oracle's Test Software Effectivelyp. 6
Taking Testing Seriouslyp. 6
Question-Handling Strategiesp. 7
Mastering the Inner Gamep. 8
Additional Resourcesp. 9
Chapter 2 Installing, Configuring, and Migrating to Oracle8ip. 13
The Oracle Universal Installerp. 14
Installing the Oracle RDBMS Software with the Universal Installerp. 15
Installing the Oracle RDBMS Software with the Silent-Mode Installerp. 16
Oracle Flexible Architecture and the Oracle Universal Installerp. 20
The Oracle Database Configuration Assistantp. 20
Using the Database Configuration Assistant to Create a Databasep. 21
The Oracle Software Packagerp. 22
Migrating or Upgrading the Databasep. 23
Before the Upgrade or Migration Occursp. 24
Migrating from Oracle7 to Oracle8ip. 26
Upgrading from Oracle8 to Oracle8ip. 32
Alternative Methods of Moving Your Database to Oracle8ip. 34
After the Upgrade or Migration Is Completep. 36
Configuration Issues When Converting to Oracle8ip. 37
Practice Questionsp. 39
Need to Know More?p. 45
Chapter 3 Java in the Databasep. 47
Oracle Java Componentsp. 48
The Java Virtual Machine (JVM)p. 48
JDBCp. 51
SQLJp. 52
Developing Oracle Applications with Javap. 52
Java Stored Proceduresp. 53
Using SQL and PL/SQL in a SQLJ Applicationp. 56
Enterprise JavaBeans (EJB)p. 56
Common Object Request Broker Architecture (CORBA)p. 57
Practice Qestionsp. 58
Need to Know More?p. 63
Chapter 4 Availability and Recoverability Enhancementsp. 65
Duplex and Multiplex Archived Redo Logsp. 66
Standby Database Enhancementsp. 68
Managed Recovery Modep. 68
Read-Only Databasesp. 69
Database SUSPEND/RESUMEp. 69
Redo Log Analysis with LogMinerp. 69
Using LogMinerp. 70
Fast-Start Fault Recoveryp. 72
Fast-Start Checkpointingp. 72
Fast-Start On-Demand Rollbackp. 73
Corrupt Block Detection and Repairp. 73
DBMS_REPAIR Proceduresp. 74
Using the DBMS_REPAIR Packagep. 74
Limitations of DBMS_REPAIRp. 75
Practice Questionsp. 76
Need to Know More?p. 81
Chapter 5 Summary Managementp. 83
Summary Management in Oracle8ip. 84
Why Summary Management?p. 84
Overview of Summary Management Featuresp. 85
Materialized Viewsp. 86
Why Use Materialized Views?p. 86
Managing Materialized View Logsp. 87
Managing Materialized Viewsp. 89
Query Rewritep. 94
How Oracle Does Query Rewritep. 95
Parameters Affecting Query Rewritep. 96
Privileges Needed for Query Rewritesp. 97
Dimensionsp. 97
The Purpose of Dimensionsp. 97
Managing Dimensionsp. 97
Packages for Managing Materialized Viewsp. 100
The DBMS_MVIEW Packagep. 100
The DBMS_OLAP Packagep. 102
Materialized Views and the Data Dictionaryp. 104
Practice Questionsp. 106
Need to Know More?p. 111
Chapter 6 New Features of Net8p. 113
New Features of Net8p. 114
Net8 Security Solutionsp. 114
Service Namingp. 115
Automatic Instance Registrationp. 116
Client and Connection Load Balancingp. 117
Failoverp. 118
Other Net8 Enhancementsp. 119
Practice Questionsp. 121
Need to Know More?p. 125
Chapter 7 SQL*Plus, PL/SQL, and National Language Supportp. 127
SQL*Plus Enhancementsp. 128
Migrating Server Manager Scripts to SQL*Plusp. 128
New SQL*Plus Commands for Database Administrationp. 129
PL/SQL Enhancementsp. 129
Database Event Triggersp. 131
User (Client) Event Triggersp. 131
The DBMS_PROFILER Packagep. 131
The DBMS_TRACE Packagep. 132
Native Dynamic SQLp. 133
Invoker-Rights Routinesp. 134
Bulk Bindsp. 134
The NOCOPY Compiler Hintp. 134
Autonomous Transactionsp. 135
National Language Support (NLS) Enhancementsp. 135
Init.ora and Session Parametersp. 136
NLS Commandsp. 137
NLS Data Typesp. 137
Practice Questionsp. 139
Need to Know More?p. 143
Chapter 8 Using New Oracle8i Database Security Features and Constraint Typesp. 145
User Password Managementp. 146
Profile Management and Securityp. 146
Fine-Grained Access Controlp. 150
Basics of Fine-Grained Access Controlp. 151
Using Fine-Grained Access Controlp. 152
Constraint Changes in Oracle 8 and 8ip. 161
Deferred Constraint Enforcementp. 161
Enabling Constraints without Enforcementp. 162
Other Oracle8i Constraint Enhancementsp. 162
Practice Questionsp. 164
Need to Know More?p. 170
Chapter 9 Optimizer and Query Improvementsp. 171
The DBMS_STATS Packagep. 172
Gathering Statisticsp. 172
Backing Up and Recovering Statisticsp. 172
Copying Statistics Between Databasesp. 173
Optimizer Plan Equivalence and Stored Plansp. 173
Creating Stored Outlinesp. 174
Using Stored Outlinesp. 174
Altering Stored Outlinesp. 174
Using the OUTLN_PKG Packagep. 175
Why Use Stored Outlines?p. 175
New SQL Keywords for Computing Subtotalsp. 176
ROLLUPp. 176
CUBEp. 177
The GROUPING Functionp. 179
Top-N SQL Queriesp. 180
The TRIM Functionp. 182
New Sort Processing Optionsp. 183
Automatic Parallel Executionp. 183
Practice Questionsp. 185
Need to Know More?p. 191
Chapter 10 Tablespace Managementp. 193
Space Management in Tablespacesp. 194
Dictionary-Managed Tablespacesp. 194
Locally-Managed Tablespacesp. 194
Transportable Tablespacesp. 195
Verify Self-Contained Status with the DBMS_TTS Packagep. 197
Generate a Transportable Tablespace Setp. 198
Transport the Tablespace Setp. 198
Import the Tablespace Setp. 198
Final Cleanupp. 199
Known Limitations of Transportable Tablespacesp. 199
Enhancements in Read-Only Tablespacesp. 200
Read-Only Tablespace Requirementsp. 201
Practice Questionsp. 202
Need to Know More?p. 208
Chapter 11 Indexes and Index-Organized Tablesp. 209
Index-Organized Tablesp. 210
What is an Index-Organized Table?p. 210
Creating an Index-Organized Tablep. 210
Logical ROWIDsp. 211
Creating Secondary Indexes on IOTsp. 211
Partitioning IOTsp. 212
IOTs and LOBsp. 212
IOTs and Overflow Storagep. 212
Moving IOTsp. 212
IOT Data Dictionary Viewsp. 213
IOT Restrictionsp. 213
Why Use an IOT?p. 213
Index Enhancementsp. 214
Reverse-Key Indexesp. 214
Function-Based Indexesp. 214
Descending Indexesp. 215
Creating or Rebuilding an Index Onlinep. 216
Coalescing an Indexp. 217
Computing Index Statisticsp. 217
Practice Questionsp. 218
Need to Know More?p. 224
Chapter 12 Recovery Manager (RMAN) Enhancementsp. 225
Optional Recovery Catalogp. 226
The Media Management APIp. 227
Crosschecking Backup Setsp. 228
New and Enhanced Maintenance Commandsp. 229
LIST and REPORT Commandsp. 229
Recovery-Catalog Maintenance Commandsp. 229
Database Maintenance Commandsp. 230
Other Commandsp. 230
Node Affinity Detectionp. 230
Backupsp. 230
TSPITR Without a Recovery Catalogp. 231
V$ Performance Views for RMAN Backupsp. 231
V$BACKUP_SYNC_IOp. 231
V$BACKUP_ASYNC_IOp. 232
Additional New Features in Release 2p. 232
Practice Questionsp. 233
Need to Know More?p. 238
Chapter 13 Partitioning Tables and Indexes in Oracle8ip. 241
Overview of Partitioned Tablesp. 242
Basics of Partitioning Tablesp. 242
Table Partitioning Methods in Oracle8ip. 244
Creating Partitioned Tablesp. 250
Creating a Range-Partitioned sales_detail_data Tablep. 250
Creating a Hash-Partitioned sales_detail_data Tablep. 260
Creating a Composite-Partitioned sales_detail_data Tablep. 261
Partitioning Index-Organized Tablesp. 263
Partitioning Tables with LOBsp. 265
A Few More Words on Table Partitioningp. 265
Restrictions on Partitioned Tablesp. 266
Partitioning Indexesp. 266
Basics of Partitioning Indexesp. 267
Global Indexesp. 268
Local Indexesp. 269
Secondary Indexes on IOTsp. 271
Restrictions on Partitioned Indexesp. 271
Locks, Pruning, and Joins: Miscellaneous Partitioning Informationp. 272
Oracle DML Locksp. 272
Partition Pruning and Partition-Wise Joinsp. 273
Practice Questionsp. 275
Need to Know More?p. 283
Chapter 14 Administration of Partitioned Tables and Indexes in Oracle8ip. 285
Managing Partitioned Objectsp. 286
General Information on Managing Partitioned Tablesp. 286
Managing Partitioned Tablesp. 288
General Information on Managing Partitioned Indexesp. 291
Managing Partitioned Indexesp. 292
Partitioned Indexes in an UNUSABLE Statep. 293
Views for Administering Partitioned Tables and Indexesp. 294
Using Partitionsp. 304
Accessing Partitions Directly in SQLp. 304
Analyzing the Partitioned or Subpartitioned Objectp. 306
Using the EXPLAIN PLAN Commandp. 307
Importing and Exporting Partitionsp. 309
Using SQL*Loader with Partitionsp. 310
Practice Questionsp. 312
Need to Know More?p. 318
Chapter 15 Manageability Enhancementsp. 319
Database Limitsp. 320
Moving Tablesp. 321
Removing Unused Columns from a Tablep. 321
Dropping a Column or Columnsp. 322
Setting a Column Unusedp. 322
Dropping Unused Columnsp. 322
Restrictionsp. 322
Temporary Tablesp. 323
Restrictionsp. 323
SQL*Loader Enhancementsp. 323
Export/Import Enhancementsp. 324
Monitoring Long-Running Operationsp. 324
New Constraints Optionsp. 325
The DISABLE VALIDATE Constraintp. 325
Practice Questionsp. 326
Need to Know More?p. 330
Chapter 16 The Database Resource Managerp. 331
Using the Database Resource Managerp. 332
Resource Plansp. 332
Resource Consumer Groupsp. 333
Resource Plan Directivesp. 333
Resource Allocation Methodsp. 334
Database Resource Manager PL/SQL Packagesp. 334
The DBMS_RESOURCE_MANAGER Packagep. 334
The DBMS_RESOURCE_MANAGER_PRIVS Packagep. 336
The DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP Procedurep. 336
Example of Using the Database Resource Managerp. 337
Restrictions on Using the Database Resource Managerp. 338
Practice Questionsp. 340
Need to Know More?p. 346
Chapter 17 Sample Testp. 347
Questions, Questions, Questionsp. 348
Picking Proper Answersp. 348
Decoding Ambiguityp. 349
Working within the Frameworkp. 350
Deciding What to Memorizep. 350
Preparing for the Testp. 351
Taking the Testp. 351
Sample Testp. 352
Chapter 18 Answer Keyp. 375
Glossaryp. 389
Indexp. 399

Google Preview