Cover image for Migrating to Oracle8i
Title:
Migrating to Oracle8i
Author:
Austin, David.
Personal Author:
Publication Information:
Indianapolis, Ind. : Sams, [2000]

©2000
Physical Description:
xxii, 708 pages : illustrations ; 24 cm
General Note:
Includes index.
Language:
English
Title Subject:
Subject Term:
ISBN:
9780672315770
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 A94 2000 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Oracle 8i is the first database to incorporate a Java Virtual machine and allow programming to occur purely in Java. Aimed at the database developer, this book discusses topics including multi-platform programming, migration issues, and how to increase customer interaction with corporate data.


Table of Contents

Introductionp. 1
Part I Migratingp. 5
1 Steps to Perform Migrationp. 7
Introducing the Migration Stepsp. 8
Choose a Migration Methodp. 9
Design a Test Planp. 22
Build a Migration Planp. 23
Perform the Migrationp. 24
Complete Post-Migration Tasksp. 24
Summaryp. 25
2 PreMigration Issuesp. 27
Assess Resource Requirementsp. 28
Assign Dutiesp. 31
Build a Test Planp. 35
Summaryp. 44
3 Installing and Configuring Oracle8ip. 45
System Requirementsp. 46
Starter Database Componentsp. 50
Installing Oracle8ip. 51
Configuring Oracle8i Cartridgesp. 56
Noninteractive Installationp. 57
Summaryp. 65
4 Migration Using the Migration Utilityp. 67
Reviewing the Migration Processp. 68
Manual Migration with MIGp. 70
Migration Utility Command-Line Optionsp. 72
Step-by-Step Migrationp. 73
Abandoning the Migration Processp. 77
Post-Migration Stepsp. 78
Troubleshooting the Migration Processp. 79
Summaryp. 83
5 Migration Using the Data Migration Assistantp. 85
System Resource Requirements for Data Migration Assistantp. 88
Prepare the Oracle 7 Database for Data Migration Assistantp. 89
Install Oracle8i for Data Migration Assistantp. 97
Migrate the Database Using Data Migration Assistantp. 98
Complete the Migration Using Data Migration Assistantp. 101
Troubleshooting and Abandoning a Migration with Data Migration Assistantp. 103
Summaryp. 104
6 Migration Using Export/Importp. 107
Define System Resource Requirements for Export/Importp. 108
Prepare the Oracle 7 Database for Export/Importp. 114
Install Oracle8i for Migration Using Export/Importp. 115
Prepare the Oracle8i Database for Migration Using Export/Importp. 117
Perform the Export/Importp. 120
Troubleshooting and Abandoning the Migration with Export/Importp. 139
Summaryp. 140
7 Migration Using Data Copyingp. 141
Define System Resource Requirements for Data Copyingp. 143
Prepare the Oracle 7 Database for Data Copyingp. 147
Install Oracle8i for Data Copyingp. 148
Prepare the Oracle8i Database for Data Copyingp. 149
Completing the Migration with Data Copyingp. 154
Troubleshooting and Abandoning the Migration with Data Copyingp. 157
Summaryp. 158
8 Post-migration Issuesp. 159
Back Up the Migrated Databasep. 160
Execute Test Proceduresp. 161
Review Initialization Parametersp. 165
Tune the Databasep. 167
Introduce New Features as Neededp. 169
Modify/Add Administrative Proceduresp. 170
Summaryp. 172
9 Upgrading from Oracle8 to Oracle8ip. 173
Pre-Upgrade Issuesp. 175
Upgrading with Oracle Data Migration Assistantp. 177
Performing an Upgrade Manuallyp. 180
User-Defined Datatype Upgradesp. 184
Recovery Manager Upgradesp. 185
Advanced Queuing Upgrade Issuesp. 186
Snapshot Upgradesp. 189
Advanced Replication Upgradesp. 189
Parallel Server Upgrade Issuesp. 190
PL/SQL Validationp. 191
Post-Upgrade Actionsp. 191
Summaryp. 194
10 Issues with Compatibilityp. 195
The COMPATIBLE Initialization Parameterp. 196
Oracle8i Features Requiring COMPATIBLE=8.1.xp. 197
Application Compatibility and Interoperabilityp. 202
Startup and Shutdown Compatibility and Interoperabilityp. 206
Tablespace and Datafile Compatibility and Interoperabilityp. 207
Data Dictionary Compatibility and Interoperabilityp. 208
National Language Support Datatype Compatibility and Interoperabilityp. 208
SQL and PL/SQL Compatibility and Interoperabilityp. 210
Advanced Qucuing Compatibility and Interoperabilityp. 213
Procedure and Package Compatibility and Interoperabilityp. 213
Oracle Parallel Server Compatibility and Interoperabilityp. 214
Database Security Compatibility and Interoperabilityp. 216
Database Backup and Recovery Compatibility and Interoperabilityp. 216
Distributed Database Compatibility and Interoperabilityp. 218
SQL*Net and Net8 Compatibility and Interoperabilityp. 219
Export/Import Compatibility and Interoperabilityp. 219
Miscellaneous Compatibility and Interoperability Topicsp. 219
Summaryp. 220
11 Upgrading Applicationsp. 221
Overviewp. 222
Upgrading OCI Applicationsp. 222
Upgrading Precompiler Applicationsp. 223
Upgrading Forms and Developer/2000 Applicationsp. 224
Upgrading SQL *Plus Scriptsp. 224
Copying LONGs to LOBsp. 233
Summaryp. 234
12 Issues with ROWIDsp. 237
ROWID Structuresp. 238
The DBMS_ROWID Packagep. 240
Migrating Applications and Datap. 241
Client Compatibility Issuesp. 247
Universal ROWIDsp. 247
Summaryp. 248
13 Downgradingp. 249
Prepare to Downgradep. 250
Downgrade to Oracle8, Release 8.0p. 251
Downgrade to Oracle 7p. 275
Summaryp. 276
14 Troubleshooting the Migration Processp. 277
Migration Utility and Data Migration Assistant Messages and Corrective Actionsp. 278
Summaryp. 291
15 Migrating from Non-Oracle Databasesp. 293
Migrating from MS SQL Serverp. 295
Oracle Migration Workbench Parser Issuesp. 297
Issues with Object Names and Reserved Wordsp. 302
Migration Using the Oracle Migration Workbenchp. 303
Migrating from MS Accessp. 306
Summaryp. 314
Part II Using the Oracle 8/ Featuresp. 315
16 Partitioningp. 317
Understanding Partitionsp. 318
Partition Viewsp. 323
Maintenance Operations on Partitionsp. 325
Partitioning Modelsp. 328
Using Partition and Sub-partition Namesp. 330
Equipartitioningp. 332
Data Dictionary Viewsp. 333
Summaryp. 334
17 Parallel Executionsp. 335
Parallel DML Versus Manual Parallelismp. 337
Parallelization Methodsp. 338
Parallel Query Architecturep. 339
Using Initialization Parameters with Parallel Operationsp. 341
Degree of Parallelismp. 344
Managing Contentionp. 348
Parallel Data Loadp. 349
Parallel Recoveryp. 350
Transaction Recovery and Rollback Segment Issuesp. 350
Diagnosing Parallel Query Performance Problemsp. 351
Summaryp. 353
18 Object Relational Featuresp. 355
Objects in Oracle8ip. 357
Object Referencesp. 360
Collections in Oracle8ip. 363
Working with Object Methodsp. 368
Working with Object Viewsp. 371
Case Study: Purchase Order Systemp. 372
Working with the Object Cachep. 376
Summaryp. 380
19 Create and Manage Large Objects (LOBs)p. 381
Internal LOBsp. 382
External LOBs (BFILE)p. 382
LOBs Versus LONGs/LONG RAWsp. 384
Creating LOBsp. 387
Manipulating LOBsp. 389
Loading LOBsp. 397
Data Dictionary Viewsp. 400
Summaryp. 403
20 Advanced Queuingp. 405
Overview of Advanced Queuingp. 406
Essential Features of Advanced Queuingp. 407
Setting Up Advanced Queuingp. 409
Programmatic Interfaces for Working with Advanced Queuingp. 418
Summaryp. 419
21 Recovery Manager (RMAN)p. 421
RMAN Componentsp. 423
Starting RMANp. 426
Performing Database Backups with RMANp. 427
Performing Database Restores with RMANp. 431
Performing Database Recovery Using RMANp. 433
Sample Scenarios for Using RMANp. 435
Useful RMAN Commandsp. 437
Summaryp. 442
22 Password Managementp. 443
Password Composition/Complexityp. 445
Password Aging and Expirationp. 446
Password Historyp. 447
Account Locking Featurep. 447
Data Dictionary Views for Password Managementp. 449
Managing Profilesp. 450
Choosing the Authentication Methodp. 455
Summaryp. 459
23 Net8 Featuresp. 461
Net8 and Listener Enhancementsp. 462
Enhanced Connectivity and Scalabilityp. 462
Security Featuresp. 469
Configuration Featuresp. 470
Additional Net8 Featuresp. 471
Summaryp. 473
24 Oracle Parallel Serverp. 475
Cluster Configurationsp. 476
Integrated Distributed Lock Managerp. 480
Parallel Cache Management and Lockingp. 485
Locking in Oracle Parallel Serverp. 486
Application Designp. 493
Global Dynamic Performance Viewsp. 494
Summaryp. 496
25 Using the Advanced Replication Optionp. 497
Replication Conceptsp. 498
Replication Configurationsp. 501
Methods for Distributing Datap. 502
Replication Componentsp. 505
Using the Replication Managerp. 505
Using DBMS_JOB packagep. 506
Migrating from Oracle 7 to Oracle8i Replication Environmentsp. 507
Primary Key Snapshotsp. 514
Parallel Propagationp. 516
Summaryp. 517
26 Using the Internet Capabilities of Oracle8ip. 519
Java in Oracle8ip. 521
Java Stored Proceduresp. 530
Oracle Internet File Systemp. 540
Summaryp. 542
27 Managing Securityp. 543
Using Views to Secure Applicationsp. 544
Application Contexts and Fine-Grained Access Controlp. 545
Invoker Rightsp. 548
Database Resource Managerp. 551
Oracle8i Internet Security Featuresp. 553
Using Digital Certificatesp. 554
External Authenticationp. 555
Enterprise Authenticationp. 556
Encrypting the Datap. 557
Auditingp. 558
Auditing DML Activityp. 560
Summaryp. 561
28 Performing Backups and Recoveryp. 563
Types of Failurep. 564
Choosing a Backup Strategyp. 564
Using Standby Databasesp. 566
Performing Cold and Hot Backupsp. 568
Database Recovery Considerationsp. 576
Database Recovery: Case Studiesp. 578
Summaryp. 588
29 Oracle Enterprise Managerp. 589
Oracle Enterprise Manager Architecturep. 590
Integrated Database Applicationsp. 597
Advanced Administrationp. 601
Summaryp. 611
30 Application Developmentp. 613
Optimization of Top-N Analysisp. 614
Index Enhancementsp. 615
Rewriting Queriesp. 616
PL/SQL Enhancementsp. 619
Oracle WebDBp. 623
Online Data Reorganization and Defragmentationp. 624
Oracle InterMediap. 624
Integration with Windows NTp. 629
Summaryp. 631
31 Data Warehousing Enhancementsp. 633
Multidimensional Analysisp. 634
ROLLUP Operationsp. 635
Materialized Viewsp. 642
Oracle8i Supplied Database Packagesp. 642
Parallel Query Enhancements in Oracle8ip. 646
Summaryp. 647
32 Miscellaneous Oracle8i Featuresp. 649
Constraintsp. 650
National Language Support Enhancementsp. 650
SYS Securityp. 651
LogMinerp. 651
Transportable Tablespacesp. 654
Locally Managed Tablespacesp. 655
Temporary Tablesp. 656
Materialized Viewsp. 657
Dealing with Data Block Corruptionp. 657
Summaryp. 667
Indexp. 669

Google Preview