Index

abandoning migration, 3-20

access

concurrent, E-3

Ada, SQL*Module, 6-4

administrative procedures

develop new, 5-4

migrated database and, 5-4

Advanced Queuing Option

aq$_agent Data Type, 8-6

CATNOQUEUE.SQL script, 8-6

CATQUEUE script, 8-6

extended address field, 8-6

new dictionary tables, 8-7

upgrading, 8-6

Advanced Replication Option

downgrading, 8-9

upgrading, 8-3

ALTER DATABASE CONVERT command

migration utility, 3-2

ALTER DATABASE OPEN RESETLOGS command

Migration Utility, 3-3

ALTER TABLESPACE command

OFFLINE IMMEDIATE or OFFLINE TEMPORARY, 3-6

application developer

role during migration, 1-6

applications

migrating, 6-1

testing, 2-15

AQ

aq$_agent Data Type, 8-6

CATNOQUEUE.SQL, 8-6

CATQUEUE script, 8-6

extended address field, 8-6

new dictionary tables, 8-7

upgrading, 8-6

architecture

migrating to a different architecture, 3-5

TWO-TASK, E-3

AS clause

space requirements, 2-9

Audience, xii

backup

after migration, 1-4, 3-14, 5-2

before migration, 3-14

EBU, 6-12

Recovery Manager, 6-12

strategy, 2-11

target database, 3-14, 5-2

bad date constraints, 5-2, 8-4

BFILE keyword

behavior in Oracle8 and Oracle7, 6-9

bitmap indexes

invalidated, 5-3

BLOB keyword

behavior in Oracle8 and Oracle7, 6-9

block size

DB_BLOCK_SIZE, 3-5

minimums, 3-5

CAST keyword

behavior in Oracle8 and Oracle7, 6-9

CAT8000.SQL script, 3-18

CAT8004D.SQL script, 8-9

CAT8004.SQL script, 8-3

CATALOG5.SQL, obsolete with Oracle8, 6-6

CATALOG6.SQL, obsolete with Oracle8, 6-6

CATALOG.SQL script, 3-18, 8-3, 8-9

abandoning migration, 3-20

CATEXP.SQL script, 6-16

CATNOQUEUE.SQL script, 8-6

CATOUTU.LOG, 8-3, 8-9

CATPROC.SQL script, 3-18, 8-3, 8-9

abandoning migration, 3-20

CATQUEUE.SQL script, 8-6

CATREP8M.SQL script, 3-18

CATREPARR.SQL script, 3-18, 8-3, 8-10

CATREP.SQL script, 3-18, 3-21, 8-3, 8-9

CHAR

size, E-4

character encoding

CREATE DATABASE command, 3-6

CHARACTER keyword

behavior in Oracle8 and Oracle7, 6-9

character set

migration utility uses, 3-6, C-4

CHARACTER_SET_NAME, 6-16

CHECK_ONLY

using option, 3-4

CHECK_ONLY migration parameter, 3-9

CLOB keyword

behavior in Oracle8 and Oracle7, 6-9

cluster tables

COPY command, 2-9

command line options, 3-9

COMMIT keyword

behavior in Oracle8 and Oracle7, 6-9

compatibility, 2-11

conventional path export, 6-16

direct path export, 6-16

SQL scripts Oracle7-->Oracle8, 6-7

COMPATIBLE parameter, C-2

concurrent access, E-3

concurrent users, E-4

CONNECT INTERNAL, 3-11

connection manager

used by OCI-Net2 clients, 6-10

connections

local and remote, E-3

with multi_threaded shared server, E-3

TWO_TASK architecture with, E-3

control files, 3-16

conventional path

export, 6-16

conversion

of data definition, 2-8

COPY command

cluster tables, 2-9

large cluster tables, 2-9

space requirements, 2-9

CREATE DATABASE command

character encoding, 3-6

cursors

number of open, E-4

data definition conversion by Import, 2-8

data dictionary

Export/Import utility, 2-8

database

backing up, 3-14

developing a test plan, 2-14

prepare source database for migration, 3-6

shutting down, 3-12

specifying name, 3-10

specifying new name, 3-10

test the migrated, 5-3

testing, 5-3

tune the migrated, 5-3

tuning, 5-3

database administrator

role during migration, 1-5

datafile

limit per tablespace, E-4

date constraints

bad, 5-2, 8-4

DB_BLOCK_SIZE

blocksize consideration, 3-5

DB_NAME migration parameter, 3-10

DBA, 1-5

duties, 1-5

DBMS

precompiler command line option, 6-5

DBMS_LOB package

LOADFROMFILE procedure, 6-6

WRITE procedure, 6-6

DEC keyword

behavior in Oracle8 and Oracle7, 6-9

definitions, 1-2

DEREF keyword

behavior in Oracle8 and Oracle7, 6-9

Developer/2000 Applications

upgrading, 6-6

dictionary

migration, 3-21

Direct Path Export

migration and compatibility issues, 6-16

Distributed Lock Manager (DLM), E-4

DLM, E-4

DML_LOCKS

in INIT.ORA, C-4

downgrading, 8-7

Advanced Replication Option, 8-9

Parallel Server Option, 8-10

release 8.0.4 to release 8.0.3, 8-7

to release 7.x, 8-11

DTYCHR type, 7-8

EBU

backup management, 6-12

environment variable

NLS character set, C-4

errors during migration, 3-20

estimating system requirements, 2-9

executables

size of, E-2

space requirements, E-2

EXPLAIN PLAN

testing, 2-14

Export

Oracle7 with CATEXP7.SQL, 8-11

Export/Import

basic steps, 4-2

partitioned objects, 6-14

Export/Import utility

benefits, 2-7

compatibility issues, 6-16

data definition conversion, 2-8

data dictionary, 2-8

earlier versions, 2-8, 4-3

limitations, 2-7

limitations for migration, 2-7

migration utility or, 2-6

time requirements, 2-7

Trusted Oracle7 and, 4-3

using, 4-3

when to use, 2-6

extended address field

Advanced Queuing Option, 8-6

FALSE keyword

behavior in Oracle8 and Oracle7, 6-9

Forms

migrating Oracle Forms applications, 6-6

Forms applications

upgrading, 6-6

forms applications

running on Oracle8, 6-6

glossary, 1-2

import

data definition conversion, 2-8

index on ROWID, 7-8

index rebuilding, 7-8

indexes

bitmap, 5-3

INIT.ORA file

COMPATIBLE parameter, C-2

INIT.ORA parameters

obsolete, C-6

installing version 7, 4-3

INT keyword

behavior in Oracle8 and Oracle7, 6-9

INTO parameter

testing, 2-14

keywords, D-1

behavior differences

Oracle7 vs. Oracle8, 6-9

behavior in Oracle8, 6-9

new to Oracle8, 6-9

link line

for OCI applications, 6-5

LOADFROMFILE procedure

DBMS_LOB package, 6-6

LOB datatypes

converting LONG to, 6-6

local connections

multi-threaded shared servers, E-3

locks

DML lock limit, DML_LOCKS, C-4

LONG datatypes

upgrading to LOB datatype, 6-6

memory requirements, E-2

concurrent access, E-3

migration, 3-4

MIGRATE user dropped, 3-18

MIGRATE user, avoid, 3-7

MIGRATE.BSQ script, 3-13

migrating

applications, 6-1

errors during, 3-20

general comments, 1-3

OCI applications, 6-2, 6-5

offline tablespaces, 3-7

Oracle Forms applications, 6-6

precompiler applications, 6-2, 6-3

preserve the source database, 3-6

process, 1-3

role of application developer, 1-6

role of database administrator, 1-5

SQL*Net, 6-10

SQL*Plus scripts, 6-7

steps for, 1-3

testing, 2-15

to a different computer architecture, 3-5

migration

CATREPARR.SQL script, 3-18

choose a method, 2-3

common problems, 2-11

defined, 1-2

NCHAR and NLS, 6-16

new administrative procedures, 5-4

required Oracle release, 2-10

space requirements, 3-4

terminology, 1-2

using Export/Import, 2-6

UTLCONST.SQL script, 5-2

migration and compatibility

standby database, 6-15

thread safety, OCI, 6-14

migration by Export/Import

data definition conversion, 2-8

migration parameters

PFILE, 3-10

migration steps

step 1, prepare to migrate, 2-2

step 2, test the migration, 2-14

step 3, test your applications, 2-15

step 4, preserve and prepare the source database, 1-4

step 4, preserve the source database, 3-6

step 5, migrate the source database, 1-4

step 6, make initial adjustments to the migrated database, 1-5, 5-1

testing, migration test plan, 2-12

migration utility

multi-threaded server

requirements for running, 6-10

shared, E-3

shared and local/remote connections, E-3

national character set

in Oracle8, 6-16

NCHAR, 6-16

compatibility and interoperability, 6-17

compatibility issues, 6-5

migration, 6-16

size, E-4

use in Oracle8, 6-16

NCHAR and NLS use, 6-16

NCHAR keyword

behavior in Oracle8 and Oracle7, 6-9

NCHAR VARYING

size, E-4

NCLOB keyword

behavior in Oracle8 and Oracle7, 6-9

Net8

upgraded applications and, 6-10

new dictionary tables

Advanced Queuing Option, 8-7

new features

adding, 5-4

NEW_DBNAME migration parameter, 3-10

NLS

compatibility and interoperability, 6-17

migration, 6-16

NLS character set, C-4

NLS use and NCHAR, 6-16

NLS_LANG setting, C-4

NLS_NCHAR migration parameter, 3-10

NLS_NCHAR_CHARACTERSET, 6-16

NO_SPACE_CHECK migration parameter, 3-10

NUMERIC keyword

behavior in Oracle8 and Oracle7, 6-9

NVARCHAR2 keyword

behavior in Oracle8 and Oracle7, 6-9

O7_DICTIONARY_ACCESSIBILITY switch, 6-12

obsolete parameters, C-6

OCI application

link line, 6-5

OCI applications

Oracle8 link line, 6-5

OCI/UPI clients

relinking with Net8, 6-11

OCIChangePassword call, 6-13

OCILIB, OCI library, 6-4

OCILobLoadFromFile command, 6-6

OCILobWrite command, 6-6

OCI-Net2 clients

requirements, 6-10

OCISessionBegin call, 6-13

offline tablespaces, 3-7

OLQP, E-3

OLTP, E-3

operating system

compatibility, 2-11

options

migration utility, 3-9

ORA_NLS32, C-4

ORA_NLS33, 3-11, C-4

Oracle Call Interface (OCI)

migrating applications, 6-5

Oracle8 features, 6-11

preparing to migrate applications, 6-2

thread safety compatibility issues, 6-14

Oracle release

required for migration, 2-10

Oracle6

Export/Import utility and, 4-3

Oracle Call Interface (OCI) library, 6-6

Oracle6 OCI library

not supported, 6-6

Oracle8 and Oracle8 Enterprise Edition, xi

upgrading, 8-4

Parallel Server Option

downgrading, 8-10

system requirements, E-4

upgrading, 8-3

parameter files (INIT.ORA)

obsolete parameters, 3-15

specifying filename, 3-10

parameters

migration utility, 3-9

obsolete, C-6

partitioned objects

Export/Import, 6-14

password expiration, 6-13

password management

application changes required for Oracle8, 6-13

performance testing, 2-13

PFILE migration parameter, 3-10

PL/SQL

backward compatibility, 6-5

compatibility between V2 and V8.0.3, 6-8

V2 compatibility mode, 6-7, 6-8

PL/SQL variables

NCHAR and NLS, 6-16

PLSQL_V2_COMPATIBILITY flag, 6-5, 6-8

precompiler applications

migrating, 6-3

upgrading from Oracle7 to Oracle8, 6-4

upgrading to Oracle8, 6-2

precompilers

compatibility between Oracle8 and Oracle7, 6-4

preface

Send Us Your Comments, ix

prepare source database for migration, 3-6

previous database

downgrading to, 8-11

primary key

field limit, E-4

privileges

migration utility requirements, 3-11

Pro*Ada

upgrading to SQL*Module for Ada, 6-4

Pro*C 3, 6-4

Pro*C/C++

integration testing, 2-13

Pro*C/C++ 2.2

compatibility with Oracle8 server, 6-4

Pro*C/C++ 3.0

compatibility with Oracle7, 6-4

Procedural Option, 3-6

product configurations

upgrading, 8-4

props$ view, 3-10

NCHAR and NLS, 6-16

read-only tablespaces, 3-3

REAL keyword

behavior in Oracle8 and Oracle7, 6-9

rebuilding indexes, 7-8

Recovery Manager

backup management, 6-12

REF keyword

behavior in Oracle8 and Oracle7, 6-9

release

required for migration, 2-10

relinking with SQL*Net, 6-2

remote connections

multi-threaded shared servers, E-3

requirements

release for migration, 2-10

reserved words, 2-11, D-1

reverse migration support, 8-11

role

of application developer, 1-6

of database administrator, 1-5

rollback segments

conversion of, 3-3

ROWID conversion, 7-4

examples, 7-5

ROWID in indexes, 7-8

ROWID use

DBMS_ROWID compatibility package, 7-2

ROWIDs, 2-11

compatibility, client access, 7-7

migration

questions and answers, 7-7

snapshot refresh, 7-6

ROWIDs for Oracle8

partitioned tables and tablespace-relative data block addresses, 7-1

SAVEPOINT keyword

behavior in Oracle8 and Oracle7, 6-9

SCN generation

improved, C-3

SELECT list

keyword behavior differences

Oracle7 vs. Oracle8, 6-9

Send Us Your Comments

boilerplate, ix

SERIALIZABLE=TRUE

desupported, C-7

SET COMPATIBILITY command, 6-7

shadow processes

open cursors and, E-4

SHUTDOWN ABORT, avoid, 3-19

shutting down the database, 3-12

snapshot compatibility

ROWID, 7-7

snapshot refresh, ROWID, 7-6

source database

space requirements

special characters, D-1

SPOOL migration parameter, 3-10

SQL

keywords, D-1

reserved words, D-1

special characters, D-1

SQL scripts

compatibility Oracle7-->Oracle8, 6-7

running on Oracle8, 6-7

SQL*Module

for Ada, 6-4

SQL*Module for Ada, 6-4

SQL*Net

migrating, 6-10

relinking, 6-2

SQL*Net V1 not used with Oracle8, 6-2

SQL*Net V2 and Net8 used with Oracle8, 6-2

upgraded applications and, 6-10

upgrading from Version 1 to Version 2, 6-10

SQL*Plus

upgrading scripts to Oracle8, 6-7

SQL*Plus scripts

migrating, 6-7

SQL_TRACE

performance testing, 2-13

SQLLIB calls

relinking, 6-4

work against Oracle8, 6-4

standby database

compatibility and upgrade, 6-15

compatibility issues, 6-15

migration and compatibility, 6-15

STARTUP command

NOMOUNT option and blocksize, 3-17

SYS schema

user-created objectst in, 6-12

SYS_OP_NTCIMG$ keyword

behavior in Oracle8 and Oracle7, 6-9

System Change Number (SCN), C-3

system requirements

estimating, 2-9

parallel server, E-4

SYSTEM tablespace

Migration Utility, 2-5, 3-4

table

column limit, E-4

tablespaces

migrating offline tablespaces, 3-7

target database

before migrating, 2-12

comparing results, 5-3

performance

volume/load stress, 2-13

third-party software

compatibility, 2-11

thread safety, OCI

compatibility and migration, 6-14

time requirements

export/import, 2-7

TP monitors, E-3

TRUE keyword

behavior in Oracle8 and Oracle7, 6-9

Trusted Oracle7

migrating with Export/Import utility, 4-3

tuning, 5-3

migrated database, 5-3

Tuxedo applications

compatibility with Oracle8 XA libraries, 6-2

relink, 6-2

TWO_TASK, E-3

TWO_TASK variable, 3-11

type DTYCHR, 7-8

types

new to Oracle8, 6-9

upgrading, 8-2

Advanced Replication Option, 8-3

CAT8004.SQL, 8-3

CAT8004.SQL script, 8-3, 8-9, 8-10

defined, 1-2

Parallel Server Option, 8-3

product configurations, 8-4

UTLCONST.SQL script, 8-4

US7ASCII, 3-10

user-created objects

in SYS schema, 6-12

utilities

Export, 2-6

Import, 2-6

Migration Utility, 2-5

UTLCONST.SQL script, 5-2, 8-4

VALUE keyword

behavior in Oracle8 and Oracle7, 6-9

VALUE$

VARCHAR

VARCHAR2

version 7

upgrading applications to Oracle8, 6-1

version 7 clients

with version 8 server, 6-14

version 7 parameters

obsolete, C-6

version 8

client with version 7 server, 6-14

volume/load stress testing, 2-13

W52DEC, 3-10

WRITE procedure

DBMS_LOB package, 6-6

XA

calls, 6-2

libraries, 6-2

XA libraries

compatibility between Oracle7 and Oracle8, 6-2