Oracle8 to 8i Upgrade Exam Cram

( 1 )


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.
Read More Show Less
... See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (10) from $1.99   
  • New (3) from $6.42   
  • Used (7) from $1.99   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any coupons and promotions
Seller since 2009

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

2000-12-15 Paperback 1st New 157610737X Ships Within 24 Hours. Tracking Number available for all USA orders. Excellent Customer Service. Upto 15 Days 100% Money Back Gurantee. ... Try Our Fast! ! ! ! Shipping With Tracking Number. Read more Show Less

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Seller since 2015

Feedback rating:


Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Seller since 2008

Feedback rating:


Condition: New

Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by
Sending request ...


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.
Read More Show Less

Product Details

  • ISBN-13: 9781576107379
  • Publisher: Coriolis Group
  • Publication date: 12/1/2000
  • Series: Exam Cram 2 Series
  • Pages: 448
  • Product dimensions: 5.99 (w) x 8.98 (h) x 1.00 (d)

Meet the Author

Robert Freeman (Enid, OK), is a certified Oracle8i DBA. He has worked with Oracle products for almost 20 years, most recently as a consultant IDS Corporation in Florida, where he is working as a database administrator. Robert was the author of the Oracle 7.3 to 8 Upgrade Exam Cram.

Charles Pack (Oklahoma City, OK) has over 15 years computer experience. He is Oracle7 and 8 certified. He is currently a database administrator with CSX in Jacksonville, Florida.

Read More Show Less

Read an Excerpt

Chapter 2: Installing, Configuring, and Migrating to Oracle8i

Terms you'll need to understand:
  • Universal Installer
  • Silent-mode installation
  • Database Configuration Assistant
  • Oracle Software Packager
  • Migration
  • Upgrade
  • Data Migration Assistant
Techniques you'll need to master:
  • Using the features of the Universal Installer
  • Performing a silent-mode installation
  • Describing how the installer uses Oracle Optimal Flexible Architecture (OFA)
  • Knowing and understanding the features of the Database Configuration Assistant
  • Migrating and upgrading databases to Oracle8i
This chapter deals with the many changes that have been made to the Oracle8i installation process and with what you'll be expected to know about it in the Oracle8i Oracle Certified Professional (OCP) Upgrade exam. Oracle has introduced a whole new installer for 8i-we will discuss this installer, including its new features, in this chapter. We will also review the new features of the Database Configuration Assistant and the Oracle Software Packager as we cover these areas. Finally, the methods of migrating or upgrading previous Oracle database versions to Oracle8i will also be discussed, as will configuration issues related to migrating or upgrading to Oracle8i.

The Oracle Universal Installer

In previous versions of Oracle, a character-based installer was available on Unix platforms (among others), and a graphical-based installer was available for Windows platforms. For Oracle8i, Oracle decided to standardize on one single software installer package called the Oracle Universal Installer.

Based on Java, the Oracle Universal Installer provides a common graphical front end for Oracle8i Relational Database Management System (RDBMS) software installations, as well as installations of products packaged by the Oracle Software Packager. (For details, see "Oracle Software Packager" later in this chapter.) As a result of the introduction of the Universal Installer, the character-based installation program that you might be more familiar with is no longer available. Because the method of running the Universal Installer is different for each platform, refer to the Oracle8i Installation Manual for more information regarding your specific platform type.

The features of the Oracle Universal Installer include the following:

  • The Universal Installer provides a common interface for all Oracle RDBMS installations.
  • Automatic dependency resolution is supported.
  • Support for multiple ORACLE_HOME locations is provided.
  • Silent-mode installs are supported (see details later in this chapter).
  • Through the Oracle Software Packager, customized installation routines of additional, third-party products are supported as well. (For more details, see the section on the Oracle Software Packager later in this chapter.)
Note: Support for multiple CDs and compression is expected in a later release.
Be certain to concentrate heavily on the common elements of the Universal Installer. Although it's important to know about platform-specific issues, you don't need to worry about them for the exam.

Because the Universal Installer is Java based, you have to run the server installation from a Java-based client. An alternative to the client-based graphical installation program is the use of the silent-mode installation. The silent-mode installation uses a response file that contains all the information the installer needs to provide an automated installation on the Oracle RDBMS software without any user interaction. In this section, we'll look at Universal Installer first. Following that, we'll look at the silent-mode method of installing the RDBMS software, and finally, we'll do example installs using both methods.

Installing the Oracle RDBMS Software with the Universal Installer

As noted before, the Universal Installer is a Java-based product and therefore requires the use of the Java Runtime Environment (JRE). Several tools are available that can provide the JRE if you are doing, for example, a Unix installation on an NT client. The screen captures you'll see in this chapter were generated on a Windows NT PC using ReflectionX. The Oracle RDBMS installation was done on a Sun Solaris machine.

Note: Following are the names of the programs that you'll want to use to start the Universal Installer. On NT, it's simply setup.exe, located in the \install\win32 directory of the CD-ROM from which you are installing. On Unix, it's RunInstaller, which is in the root directory of the 8.1.5 CD.

The Universal Installer has a point-and-click interface and is very user friendly. Figure 2.1 provides an example of the look and feel of the Universal Installer. As you can see from the figure, the Installer is a graphical application with almost a wizard feel to it. Also, at the bottom of the figure, note that the Installer indicates where it's keeping a log of the installation processes. It's a good idea to note the location of this log file for future reference should some problem with the installed database software appear later.

The installation process itself remains generally the same as it was in previous versions of Oracle with the character-based installer. You identify the ORACLE_HOME and ORACLE_BASE locations either by setting the correct environment variables or after opening the Installer itself. The Installer then leads you through the various steps of the installation, giving you the option of loading the server software, loading the client software, or selecting the specific software you wish to load through a custom installation. When you use the Universal Installer, you might also have the option to create a starter database, depending on which installation configuration you select. If you choose this option, then the Installer will start the Oracle Database Configuration Assistant along with the NET8 Configuration Assistant after the RDBMS software has been installed.

Oracle8i requires its own ORACLE_HOME directory, and you cannot install the software over any existing version of Oracle. Thus, if you are low on available hard-drive space, you'll have to remove the previous version of the Oracle RDBMS before you can install Oracle8i. You can, of course, load Oracle8i into its own ORACLE_HOME directory, separate from any other ORACLE_HOME directory, if you have the space available. This allows you to run one database in Oracle8i and other databases on different versions of the RDBMS software at the same time.

Installing the Oracle RDBMS Software with the Silent-Mode Installer

Sometimes you might want to use the Oracle Universal Installer (to install the Oracle RDBMS database software on a group of networked servers, for example) without requiring a user response to any prompts and without needing to use the graphical capabilities of the universal installer. This is a case when you might consider using the silent-mode installation method supported by the Universal Installer. Note that on Unix, although the installation itself is silent, the installer still requires an Xwindows connection to the client, even if the Installer is running in silent mode. Of course, this isn't an issue if you're using the Installer on NT.

When doing a silent-mode installation of the Oracle RDBMS software, you use a response file (see Listing 2.1) that will be used by the Universal Installer in silent mode. The response file provides the information that the Universal Installer needs to properly install the RDBMS software. Before you do the silent-mode installation, you modify the response file so that the settings, such as ORACLE_HOME, reflect the settings you want the Installer to use.

Listing 2.1 Example of response file used to do a silent-mode installation....

Read More Show Less

Table of Contents

Introduction ..... xxi
Self-Assessment ..... xxxi
Chapter 1: Oracle OCP Certification Exams ..... 1
Assessing Exam-Readiness
The Testing Situation
Test Layout and Design
Using Oracle’s Test Software Effectively
Taking Testing Seriously
Question-Handling Strategies
Mastering the Inner Game
Additional Resources
Chapter 2: Installing, Configuring, and Migrating to Oracle8i ..... 13
The Oracle Universal Installer
Installing the Oracle RDBMS Software with the Universal Installer
Installing the Oracle RDBMS Software with the Silent- Mode Installer
Oracle Flexible Architecture and the Oracle Universal Installer
The Oracle Database Configuration Assistant
Using the Database Configuration Assistant to Create a Database
The Oracle Software Packager
Migrating or Upgrading the Database
Before the Upgrade or Migration Occurs
Migrating from Oracle7 to Oracle8i
Upgrading from Oracle8 to Oracle8i
Alternative Methods of Moving Your Database to Oracle8i
After the Upgrade or Migration Is Complete
Configuration Issues When Converting to Oracle8i
Practice Questions
Need to Know More?
Chapter 3: Java in the Database ..... 47
Oracle Java Components
The Java Virtual Machine (JVM)
Developing Oracle Applications with Java
Java Stored Procedures
Using SQL and PL/SQL in a SQLJ Application
Enterprise JavaBeans (EJB)
Common Object Request Broker Architecture (CORBA)
Practice Questions
Need to Know More?
Chapter 4: Availability and Recoverability Enhancements ..... 65
Duplex and Multiplex Archived Redo Logs
Standby Database Enhancements
Managed Recovery Mode
Read-Only Databases
Redo Log Analysis with LogMiner
Using LogMiner
Fast-Start Fault Recovery
Fast-Start Checkpointing
Fast-Start On-Demand Rollback
Corrupt Block Detection and Repair
DBMS_REPAIR Procedures
Using the DBMS_REPAIR Package
Limitations of DBMS_REPAIR
Practice Questions
Need to Know More?
Chapter 5: Summary Management ..... 83
Summary Management in Oracle8i
Why Summary Management?
Overview of Summary Management Features
Materialized Views
Why Use Materialized Views?
Managing Materialized View Logs
Managing Materialized Views
Query Rewrite
How Oracle Does Query Rewrite
Parameters Affecting Query Rewrite
Privileges Needed for Query Rewrites
The Purpose of Dimensions
Managing Dimensions
Packages for Managing Materialized Views
The DBMS_MVIEW Package
The DBMS_OLAP Package
Materialized Views and the Data Dictionary
Practice Questions
Need to Know More?
Chapter 6: New Features of Net8 ..... 113
New Features of Net8
Net8 Security Solutions
Service Naming
Automatic Instance Registration
Client and Connection Load Balancing
Other Net8 Enhancements
Practice Questions
Need to Know More?
Chapter 7: SQL*Plus, PL/SQL, and National Language Support ..... 127
SQL*Plus Enhancements
Migrating Server Manager Scripts to SQL*Plus
New SQL*Plus Commands for Database Administration
PL/SQL Enhancements
Database Event Triggers
User (Client) Event Triggers
The DBMS_TRACE Package
Native Dynamic SQL
Invoker-Rights Routines
Bulk Binds
The NOCOPY Compiler Hint
Autonomous Transactions
National Language Support (NLS) Enhancements
Init.ora and Session Parameters
NLS Commands
NLS Data Types
Practice Questions
Need to Know More?
Chapter 8: Using New Oracle8i Database Security Features and Constraint Types ..... 145
User Password Management
Profile Management and Security
Fine-Grained Access Control
Basics of Fine-Grained Access Control
Using Fine-Grained Access Control
Constraint Changes in Oracle 8 and 8i
Deferred Constraint Enforcement
Enabling Constraints without Enforcement
Other Oracle8i Constraint Enhancements
Practice Questions
Need to Know More?
Chapter 9: Optimizer and Query Improvements ..... 171
The DBMS_STATS Package
Gathering Statistics
Backing Up and Recovering Statistics
Copying Statistics Between Databases
Optimizer Plan Equivalence and Stored Plans
Creating Stored Outlines
Using Stored Outlines
Altering Stored Outlines
Using the OUTLN_PKG Package
Why Use Stored Outlines?
New SQL Keywords for Computing Subtotals
The GROUPING Function
Top-N SQL Queries
The TRIM Function
New Sort Processing Options
Automatic Parallel Execution
Practice Questions
Need to Know More?
Chapter 10: Tablespace Management ..... 193
Space Management in Tablespaces
Dictionary-Managed Tablespaces
Locally-Managed Tablespaces
Transportable Tablespaces
Verify Self-Contained Status with the DBMS_TTS Package
Generate a Transportable Tablespace Set
Transport the Tablespace Set
Import the Tablespace Set
Final Cleanup
Known Limitations of Transportable Tablespaces
Enhancements in Read-Only Tablespaces
Read-Only Tablespace Requirements
Practice Questions
Need to Know More?
Chapter 11: Indexes and Index-Organized Tables ..... 209
Index-Organized Tables
What is an Index-Organized Table?
Creating an Index-Organized Table
Logical ROWIDs
Creating Secondary Indexes on IOTs
Partitioning IOTs
IOTs and LOBs
IOTs and Overflow Storage
Moving IOTs
IOT Data Dictionary Views
IOT Restrictions
Why Use an IOT?
Index Enhancements
Reverse-Key Indexes
Function-Based Indexes
Descending Indexes
Creating or Rebuilding an Index Online
Coalescing an Index
Computing Index Statistics
Practice Questions
Need to Know More?
Chapter 12: Recovery Manager (RMAN) Enhancements ..... 225
Optional Recovery Catalog
The Media Management API
Crosschecking Backup Sets
New and Enhanced Maintenance Commands
LIST and REPORT Commands
Recovery-Catalog Maintenance Commands
Database Maintenance Commands
Other Commands
Node Affinity Detection
TSPITR Without a Recovery Catalog
V$ Performance Views for RMAN Backups
Additional New Features in Release 2
Practice Questions
Need to Know More?
Chapter 13: Partitioning Tables and Indexes in Oracle8i ..... 241
Overview of Partitioned Tables
Basics of Partitioning Tables
Table Partitioning Methods in Oracle8i
Creating Partitioned Tables
Creating a Range-Partitioned sales_detail_data Table
Creating a Hash-Partitioned sales_detail_data Table
Creating a Composite-Partitioned sales_detail_data Table
Partitioning Index-Organized Tables
Partitioning Tables with LOBs
A Few More Words on Table Partitioning
Restrictions on Partitioned Tables
Partitioning Indexes
Basics of Partitioning Indexes
Global Indexes
Local Indexes
Secondary Indexes on IOTs
Restrictions on Partitioned Indexes
Locks, Pruning, and Joins: Miscellaneous Partitioning Information
Oracle DML Locks
Partition Pruning and Partition-Wise Joins
Practice Questions
Need to Know More?
Chapter 14: Administration of Partitioned Tables and Indexes in Oracle8i ..... 285
Managing Partitioned Objects
General Information on Managing Partitioned Tables
Managing Partitioned Tables
General Information on Managing Partitioned Indexes
Managing Partitioned Indexes
Partitioned Indexes in an UNUSABLE State
Views for Administering Partitioned Tables and Indexes
Using Partitions
Accessing Partitions Directly in SQL
Analyzing the Partitioned or Subpartitioned Object
Using the EXPLAIN PLAN Command
Importing and Exporting Partitions
Using SQL*Loader with Partitions
Practice Questions
Need to Know More?
Chapter 15: Manageability Enhancements ..... 319
Database Limits
Moving Tables 3
Removing Unused Columns from a Table
Dropping a Column or Columns
Setting a Column Unused
Dropping Unused Columns
Temporary Tables
SQL*Loader Enhancements
Export/Import Enhancements
Monitoring Long-Running Operations
New Constraints Options
Practice Questions
Need to Know More?
Chapter 16: The Database Resource Manager ..... 331
Using the Database Resource Manager
Resource Plans
Resource Consumer Groups
Resource Plan Directives
Resource Allocation Methods
Database Resource Manager PL/SQL Packages
Example of Using the Database Resource Manager
Restrictions on Using the Database Resource Manager
Practice Questions
Need to Know More?
Chapter 17: Sample Test ..... 347
Questions, Questions, Questions
Picking Proper Answers
Decoding Ambiguity
Working within the Framework
Deciding What to Memorize
Preparing for the Test
Taking the Test
Sample Test
Chapter 18: Answer Key ..... 375
Glossary ..... 389
Index ..... 399
Read More Show Less

Customer Reviews

Average Rating 3
( 1 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted April 23, 2001

    It is just OK.

    I use this book to pass 1Z0-020 (score 40 of 54) today. This book just is OK because the exam updated after the book published. If you only use this book, 10-15 questions will not be answered clearly in the exam. Some topics such as parallel_adaptive_multi_user, composite partitioned indexes, temporary lob, and so on are not covered in the book. Some topics are not deep enough such as if a listener is not available when client try to connect server using loading balance and failover, where client look for listener. So if you use this book, you have to totally understand knowledge covered in the book and very closely pass the exam.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)