Index

ALTER DATABASE CONVERT statement, 4-4, 4-33

re-running, A-20

ALTER DATABASE OPEN RESETLOGS statement, 4-4, 4-33

ALTER DATABASE RESET COMPATIBILITY statement, 9-8

ALTER DATABASE RESET LOGS statement, 4-8, 5-6

ALTER SESSION SET ISOLATION_LEVEL=SERIALIZABLE command, B-8

ALTER TABLE statement

bitmap index invalidation, 9-26

ANALYZE TABLE VALIDATE STRUCTURE statement

change in release 8.1, 9-18

applications

application context

role during migration, 2-7

downgrading, 13-45

client/server configurations

upgrading, 10-4

compatibility, 9-16, 10-2

development

index-organized tables

compatibility, 9-17

interoperability, 9-16

linking with newer libraries, 10-6

OCI

physical ROWIDs and UROWIDs, 9-17

interoperability, 9-18

physical ROWIDs in Oracle8i, 12-2

PL/SQL

compatibility, 9-21

interoperability, 9-21

precompiler

compatibility, 9-20

interoperability, 9-20

running against older server, 10-6

Tuxedo applications

AQ_TM_PROCESSES initialization parameter, 7-18, 7-38

upgrading, 10-1

compatibility rules, 10-5

options, 10-8

relinking rules, 10-5

AQ. See Advanced Queuing

archive log destination parameters

new in release 8.1, B-14

ARCHIVE_DEST_n initialization parameter

downgrading, 13-47

archived redo logs

analyzing

from other databases, 9-44

compatibility, 9-43

rearchiving, 9-43

archiving

error detection behavior, 9-43

associations

AUTOMATIC_IPC parameter, F-14

AUDIT_TRAIL initialization parameter

migration, A-3

autonomous transactions

after migration or upgrade, 8-2

backups

before migration, 4-27

compatibility, 9-12, 9-40

EBU, 9-41

preparing a strategy for migration, 3-21

Recovery Manager and EBU, 9-41

backward compatibility

of ROWIDs, 12-7

bitmap indexes

invalidations, 9-26

during migration, 8-12

when downgrading, 13-19

blocks

block size

DB_BLOCK_SIZE initialization parameter, 4-6, 5-5

minimums for migration, 4-6, 5-5

BUILD DEFERRED clause

bulk binds

downgrading, 13-34

C language

C call specifications

discontinue using, 13-3, 13-26

cache reads

for LOBS

call specifications

downgrading, 13-33

CALL statement

CartridgeServices.jar, 8-5

CATALOG5.SQL script, obsolete with Oracle8i, 9-25

CATALOG6.SQL script, obsolete with Oracle8i, 9-25

CATALOG.SQL script, 4-4, 4-34, 7-22, 13-60

CATEXP7.SQL script, 9-49

downgrading to Oracle7, 14-3

CATNOQUE.SQL script, 7-40

CATPARR.SQL script, 4-34, 7-36, 13-61

CATPROC.SQL script, 4-4, 4-34, 7-22, 13-60

CATQUEUE.SQL script, 7-40

CATREP.SQL script, 4-34, 5-21, 7-28, 13-60

chained row tables

dropping, 13-25

CHAR

maximum size

change, 9-16

CHARACTER keyword

behavior in Oracle7 and Oracle8i, 9-23

character sets

migrating the database, 4-9, 5-7

Migration utility, 4-9

Oracle Data Migration Assistant, 5-7

varying-width

CLOBs and NCLOBs, 9-26

CHECK_ONLY

Migration utility option, 4-18, 4-22

client-server configurations, 1-4

CLOBs

compatibility, 9-26

clusters

cluster tables

copying data, 3-15

CMAN_ADMIN parameter, F-16

CMAN.ORA file

CMAN_ADMIN parameter, F-16

migrating, F-16

upgrading, F-16

coexistence issues

release 8.1 client connection to version 7 database, F-9

collecting server event data, B-17

collection locators

user-specified storage, 9-29

collections

collection columns

collection locators

compatibility, 9-29

columns

partially dropped

unused

ALTER SESSION SET ISOLATION_LEVEL=SERIALIZABLE, B-8

command line

command-line options

Migration utility, 4-18

commands

COMMIT FORCE, 4-8, 5-6

ROLLBACK FORCE, 4-8, 5-6

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, B-8

comments

differences between Server Manager and SQL*Plus, 11-9

on Oracle documentation, xxiii

COMMIT command

differences between Server Manager and SQL*Plus, 11-17

COMMIT FORCE command, 4-8, 5-6

COMMIT keyword

behavior in Oracle7 and Oracle8i, 9-23

COMMUNITY parameter, F-4

compatibility, 9-1

8.1.0 compatibility level

features requiring, 9-9

Advanced Queuing, 9-13, 9-32

agent self-registration, 9-12

ALTER DATABASE RESET COMPATIBILITY statement, 9-8

ANALYZE VALIDATE STRUCTURE statement, 9-18

application context, 9-12

applications, 9-16, 10-2

index-organized tables, 9-17

physical ROWIDs and UROWIDs, 9-17

Tuxedo applications, 9-18

XA calls, 9-18

archived redo logs, 9-43

backup, 9-12, 9-40

change in maximum size

CHAR, 9-16

RAW, 9-16

VARCHAR2, 9-16

checking level for features, 9-8

compatibility level, 9-5

COMPATIBLE initialization parameter, 9-2

CREATE TABLE behavior change, 9-31

data dictionary, 9-25

database resource manager, 9-13

datafiles, 9-23

datatypes, 9-26

date columns in dynamic performance views, D-13

DBMS_REPAIR package, 9-13

DISABLE VALIDATE constraints, 9-13

downgrading, 9-5

Export/Import, 9-48

extensible optimizer, 9-13

fine-grained access control, 9-12

Heterogeneous Services agents, 9-46

indexes

key compression, 9-10

initialization parameters, B-9

LOB index clause, 9-27

LOBs, 9-11, 9-26

CLOBS and NCLOBs, 9-26

LogMiner, 9-43

materialized views, 9-14

nested tables, 9-29

NLS and NCHAR environment variables, 9-28

n-tier authentication and authorization, 9-12

OCI, 9-18

link line, 9-19

thread safety, 9-19

optimization, 9-35

optimizer plan stability, 9-13

Oracle Media Management API, 9-12

Oracle Parallel Server

instance affinity for jobs, 9-12

packages

PLSQL_V2_COMPATIBILITY initialization parameter, 9-21

precompilers, 9-20

recovery, 9-12, 9-40

fast-start rollback, 9-12

REFs, 9-11

removing incompatibilities, 13-2

replication, 9-12, 9-45

resetting for database, 13-51

ROWID issues, 12-7

rowids, 9-27

schema objects, 9-10

collection locators, 9-11

drop column, 9-10

extensible indexing, 9-10

function-based indexes, 9-10

indexes, 9-10

index-organized tables, 9-10

nested tables, 9-11

online index (re)build, 9-10

single-table hash clusters, 9-10

temporary tables, 9-10

scripts

UTLCHN1.SQL, 9-13, 9-31

UTLEXPT1.SQL, 9-13, 9-31

SHUTDOWN IMMEDIATE, 9-23

snapshots, 9-44

Spatial, 9-14

SQL and PL/SQL, 9-13

autonomous transactions, 9-13

bulk binds, 9-13

C call specifications, 9-13

CALL statement, 9-13

native dynamic SQL, 9-13

NOCOPY parameter passing mode, 9-13

standby database, 9-42

summary management, 9-14

tablespaces, 9-9, 9-23

locally managed tablespaces, 9-9

online read-only tablespaces, 9-9

transportable tablespaces, 9-9

triggers, 9-13

UROWIDs, 9-11

user-defined object identifiers, 9-11

varrays, 9-11

stored as LOBs, 9-29

Visual Image Retrieval, 9-14

compatibility level

checking, 13-2

resetting, 9-8

COMPATIBLE initialization parameter, 9-2

8.1.0 setting

features requiring, 9-9

checking the setting, 9-5

database structures, 9-3

setting, 9-6

when to set, 9-5

composite methods

partitioning and downgrading, 13-24

concurrent access, 3-17

concurrent users, 3-18

CONNECT THROUGH privileges

revoking, 13-46

connections

load balancing in Net8, 9-47

local and remote, 3-17

with multithreaded shared server, 3-17

connect-time failover

GLOBAL_DBNAME parameter in listener.ora, F-15

control files

renaming or removing for migration, 4-26, 7-17, 13-58

ContText

migrating to interMedia, 4-7, 5-6

copying data

large cluster tables, 3-15

migration method, 3-14

space requirements, 3-15

CREATE LIBRARY command

differences between Server Manager and SQL*Plus, 11-16

CREATE TABLE

AS subquery

behavior change, 9-31

behavior change

Oracle7 to Oracle8i, 9-31

CREATE TYPE command

differences between Server Manager and SQL*Plus, 11-16

cursors

number of open, 3-18

data definition conversion

Import utility, 3-13

data dictionary

compatibility, 9-25

protection, 9-25

database

failure to open after removing incompatibilities, 9-8

database administrator

role during migration, 2-7

database resource manager

backing up for migration, 4-27

databases

downgrading, 13-52

test migration results, 8-13

tuning after migration, 8-14

datafiles

compatibility, 9-23

offline during migration, 4-4

datatypes

compatibility, 9-26

internal

new in Oracle8i, E-2

date constraints

checking for bad, 8-4

DB_BLOCK_SIZE initialization parameter

migration, 4-6, 5-5

DB_DOMAIN initialization parameter, F-15

compatibility, B-10

DB_NAME initialization parameter, F-15

DBMS

precompiler command line option, 9-21

DBMS_APPLICATION_INFO package

SET_SESSION_LONGOPS procedure

syntax change, 9-34

DBMS_LOB package

NOCOPY syntax and compatibility, 9-34

DBMS_REPAIR package

compatibility, 9-13, 9-34

downgrading, 13-42

DBMS_ROWID package, 12-3

DBMS_STATS package

upgrading statistics tables, 7-44

DBMSLOB.SQL script

compatibility, 9-34

DBNAME

DEC keyword

behavior in Oracle7 and Oracle8i, 9-23

definitions. See terminology

DEGREE keyword

in PARALLEL clause, 9-36

deinstalling, 1-13

Developer/2000 Applications

upgrading, 10-12

dimensions

downgrading, 13-21

DISABLE VALIDATE constraints

preparing to migrate, 4-8, 5-6

downgrading, 13-42

distributed databases

DML_LOCKS initialization parameter

compatibility, B-10

documentation

conventions, xxii

roadmap for Migration utility, 4-2

roadmap for Oracle Data Migration Assistant, 5-2

domain indexes

dropping, 13-20

downgrading

Advanced Queuing, 13-6, 13-35

CATALOG.SQL, 13-60

CATPROC.SQL, 13-60

locally managed tablespaces, 13-7, 13-12

Oracle Parallel Server, 13-61

ORADIM, 13-57

procedure for, 13-52

queue tables, 13-39

removing incompatibilities, 13-2

application context, 13-45

associations, 13-44

bitmap index invalidation, 13-19

cache reads for LOBs, 13-3, 13-26

chained row tables, 13-25

DBMS_REPAIR package, 13-42

dimensions, 13-21

DISABLE VALIDATE constraints, 13-42

domain indexes, 13-20

exception tables, 13-25

extensible indexing, 13-20

fine-grained access control, 13-45

function-based indexes, 13-20

global users, 13-5, 13-45

indextypes, 13-20

Java, 13-34

key compression on indexes and index-organized tables, 13-13

LOBs, 13-26

LOBs in index-organized tables, 13-14

locally managed tablespaces, 13-12

materialized views, 13-16

migrated tablespaces, 13-6, 13-10

mutually referencing types, 13-32

mutually referencing views, 13-18

nested tables, 13-31

Net8 service naming, 13-50

operators, 13-21

optimizer, 13-44

partially dropped columns, 13-15

partitioning, 13-22

plan stability, 13-44

referential constraints on REF columns, 13-31

replication, 13-47

secondary indexes on index-organized tables, 13-15

security policies, 13-45

SET_SESSION_LONGOPS syntax change, 13-41

single-table hash clusters, 13-16

SQL and PL/SQL, 13-33

stored outlines, 13-44

temporary tables, 13-13

transient segments, 13-7, 13-11

transported tablespaces, 13-10

triggers, 13-5, 13-43

triggers on nested table view columns, 13-43

unused columns, 13-15

UROWIDs, 13-25

user-defined datatypes, 13-29

user-defined object identifiers, 13-30

UTL_REF package, 13-41

varrays, 13-32

replication, 13-60

regenerating, 13-63

resetting database compatibility, 13-51

revoking CONNECT THROUGH privileges, 13-46

scripts, 13-54

to an older version 8 release, 13-1

rerunning, 13-55

to 8.0 release, 13-8

to Oracle7, 14-1

alternative methods, 14-4

CATEXP7.SQL script, 14-3

to previous 8.1 release, 13-3

triggers, 13-5

drop column

DUMP_TNSNAMES command, F-20

DTYCHR type, 12-10

Dynamic Discovery Option for Oracle Names

migrating issues, F-20

dynamic performance views

added in Oracle8i, D-2

changed in Oracle8i

added columns, D-8

renamed columns, D-12

date columns

compatibility, D-13

obsolete in Oracle8i, D-13

renamed in Oracle8i, D-7

with dropped columns in Oracle8i, D-11

EBU

backup management, 9-41

Enterprise Manager. See Oracle Enterprise Manager

enterprise user management

interoperability, 9-39

environment variables

compatibility

required for migration, 4-20, 4-24

ORA_NLS32, 9-28

ORA_NLS33, 4-20, 9-28

required for upgrading, 7-19

errors

during migration. See troubleshooting

event data

collecting, B-17

exception tables

dropping, 13-25

export

and extended ROWIDs, 12-8

Export utility

migration, 3-10, 6-1

Oracle8i using CATEXP7.SQL, 14-3

requirements for migration, 6-2

Export/Import

advantages and disadvantages, 3-10

basic steps for migration, 6-2

benefits for migration, 3-12

compatibility, 9-48

data definition conversion, 3-13

effects on migrated databases, 3-11

incompatible data, 9-49

limitations for migration, 3-12

migration steps using, 6-3

scripts

CATEXP7.SQL, 9-49

time requirements for migration, 3-13

Trusted Oracle, 6-3

extended address field

Advanced Queuing, 7-38

extended ROWIDs, 12-7

import and export issues, 12-8

extensible indexing

failure to open database after removing incompatibilities, 9-8

downgrading, 13-20

FAILOVER parameter, F-11

FALSE keyword

behavior in Oracle7 and Oracle8i, 9-23

FAST REFRESH mode

compatibility, 9-12, 9-42

fast-start parallel recovery

compatibility, 9-42

fast-start rollback

feature compatibility, 9-8

features

new features, 9-9

requiring migration, G-13

feedback

on Oracle documentation, xxiii

filenames

normalize, 8-9

fine-grained access control

upgrading Oracle Forms applications, 10-12

Forms

function-based indexes

replication support and migration, G-3, G-9

invalidations

during upgrade, 8-14

functions

SQL

new in Oracle8i, E-3

generating

global users

downgrading, 13-5, 13-45

GLOBAL_DBNAME parameter, F-15

glossary. See terminology

GREATEST_LB function

desupported, 9-30

Heterogeneous Services

agents

compatibility, 9-46

interoperability, 9-46

multithreaded, 9-46

import

and extended ROWIDs, 12-8

Import utility

data definition conversion, 3-13

migration, 3-10, 6-1

requirements for migration, 6-2

incompatibilities

removing, 13-2

system-defined, 9-6, 13-9

incremental migration, G-5

indexes

domain

key compression, 9-10

on physical ROWID, 12-10

rebuilding

physical ROWIDs, 12-10

index-organized tables

removing partitions from, 13-22

removing LOBs from, 13-14

indextypes

dropping, 13-20

initialization parameters

added in Oracle8i, B-2

adjusting for release 8.1, 4-30, 5-11, 7-18, 8-8

AQ_TM_PROCESSES, 7-18, 7-38

archive log destination

switching to new, B-14

changes in Oracle8i, B-1

LOG_CHECKPOINT_TIMEOUT, B-9

DB_DOMAIN, B-10

DML_LOCKS, B-10

O7_DICTIONARY_ACCESSIBILITY, B-9

SORT_AREA_SIZE, B-9

SORT_DIRECT_WRITES, B-9

COMPATIBLE, 9-2

JOB_QUEUE_PROCESSES, 7-38

LARGE_POOL_SIZE

ORACLE_TRACE_COLLECTION_NAME, B-17

obsolete in Oracle8i, B-6

ORACLE_TRACE_ENABLE, B-17

renamed in Oracle8i, B-4

SERIALIZABLE=TRUE, B-8

SHARED_POOL_SIZE

SYSTEM_TRIG_ENABLED, 7-31

INIT.ORA parameters. See initialization parameters

installation

release 8.1 Oracle software, 4-14, 5-14, 6-3

INSTANCE_NAME initialization parameter, F-12

INSTANCES keyword

removed from PARALLEL clause, 9-36

INT keyword

behavior in Oracle7 and Oracle8i, 9-23

intchg.ora file, F-17

interMedia

migrating from ConText to, 4-7, 5-6

interMedia Text

upgrading, 7-24

internal datatypes

new in Oracle8i, E-2

interoperability, 9-1, 9-15

Advanced Queuing, 9-32

applications, 9-16

Heterogeneous Services agents, 9-46

native dynamic SQL, 9-30

OCI, 9-18

Oracle7 clients, 9-19

shared structures, 9-18

PL/SQL, 9-21

precompilers, 9-20

UROWIDs, 9-27

user-defined datatypes, 9-29

invokers-rights clause

downgrading, 13-33

Java

installing CartridgeServices.jar, 8-5

installing ODCI.jar, 8-5

removing incompatibilities for downgrading, 13-34

upgrading, 7-31

JOB_QUEUE_PROCESSES initialization parameter, 4-30, 5-11, 7-18, 7-38

JServer

upgrading, 7-31

key compression

discontinuing use of, 13-13

keywords

behavior differences

Oracle7 and Oracle8i, 9-23

large files

operating system dependencies, 9-50

Large Objects. See LOBs

LARGE_POOL_SIZE initialization parameter

changes in release 8.1, 8-5

modifying after migration, 8-6

LEAST_UB function

desupported, 9-30

listener.ora file

migrating, F-15

modifying after upgrading, 8-6

parameters

GLOBAL_DBNAME, F-15

ORACLE_HOME, F-15

SID_NAME, F-15

prespawned dedicated servers, F-16

upgrading, F-15

USE_PLUG_AND_PLAY_listener_name, F-20

listeners

configuring for Oracle Enterprise Manager, F-15

prespawned dedicated servers, F-16

load balancing

Net8, 9-47

LOAD_BALANCE parameter, F-11

LOAD_TNSNAMES command, F-21, F-24

LOB datatype

copying from LONG, 8-2

LOB index clause

compatibility, 9-27

LOBs

compatibility, 9-11, 9-26

downgrading, 13-26

removing from index-organized tables, 13-14

removing from partitioned tables, 13-28

local connections

multithreaded shared servers, 3-17

locally managed tablespaces

converting to dictionary tablespaces, 13-12

locks

DML lock limit, DML_LOCKS, B-10

LOG_CHECKPOINT_TIMEOUT

new default value, B-9

LOG_CHECKPOINT_TIMEOUT initialization parameter

incremental migration of, G-7

LogMiner

compatibility, 9-43

LONG datatype

copying to LOB, 8-2

master sites

migration, G-3

materialized views

BUILD DEFERRED clause, 13-17

downgrading, 13-16

FAST REFRESH mode, 13-17

NEVER REFRESH mode, 13-17

PREBUILT TABLE clause, 13-17

REFRESH ON COMMIT mode, 13-17

removing incompatibilities, 13-16

memory requirements

concurrent access, 3-17

migration, 3-15, 4-6, 5-4

migprep utility

running, 4-19

MIGRATE user

avoid, 4-11, 5-9

MIGRATE.BSQ script, 4-26

migrated tablespaces

correcting transient segments, 13-7, 13-11

removing migrated tablespaces, 13-6, 13-10

migration

abandoning, 4-36, 5-24

after migrating, 8-1, 8-12

ALTER DATABASE CONVERT statement, 4-4, 4-33

re-running, A-20

ALTER DATABASE OPEN RESETLOGS statement, 4-4, 4-33

AUDIT_TRAIL initialization parameter, A-3

avoiding common problems, 3-19

backup strategy, 3-21

block size minimums, 4-6, 5-5

character set, 4-9, 5-7

choosing a method, 3-3

control files, 4-26, 7-17, 13-58

copying data, 3-14

distributed database considerations, 4-8, 5-6

exclusive password file, A-18

Export/Import, 3-10

steps, 6-2

features requiring, G-13

incremental, G-5

initialization parameters, 4-30, 5-11, B-1

listener.ora file, 8-6

master sites, G-3

memory requirements, 3-15, 4-6, 5-4

methods

choosing, 3-3

migprep utility, 4-19

MIGRATE user, avoid, 4-11, 5-9

MIGRATE.BSQ script, 4-26

Migration utility, 3-6

new administrative procedures, 8-8

obsolete replication procedures, G-14

offline datafiles, 4-4

offline tablespaces, 4-11, 5-9

OPTIMAL setting for SYSTEM rollback segment, A-4

Oracle Data Migration Assistant, 3-8

Oracle Parallel Server, 4-8

rolling upgrade, 1-13

ORADIM, 4-25, 7-16

OUTLN user, avoid, 4-11, 5-9

overview for replication, G-2

overview of steps, 2-2

parallel execution, 8-5

post migration, 8-1, 8-12

post-migration actions, 8-1, 11-1

prepare the Oracle7 source database, 4-10, 5-7

Windows platforms, 4-13, 5-12

preparing to migrate, 3-2

read-only tablespaces, 4-4

replication, 4-7

role of application developer, 2-7

role of database administrator, 2-7

rollback segments, 4-4

ROWID compatibility, 12-7

rowids, 12-1

FAQ, 12-9

scripts

CATALOG.SQL, 4-4, 4-34

CATPARR.SQL, 4-34

CATPROC.SQL, 4-4, 4-34

CATREP.SQL, 4-34, 5-21

space requirements, 3-15, 4-6, 5-4

R0703040.SQL, 4-34, 5-21

rerunning, 4-34, 5-22

U0703040.SQL, 4-33

UTLRP.SQL, 4-34, 5-22

snapshot sites, G-6

SQL*Net requirement

Windows platforms, 4-13, 5-12

standby database, 8-6

system requirements, 3-15

SYSTEM tablespace, A-2

temporary tablespace, A-2

terminology, 1-2

testing, 3-21

testing results, 8-13

troubleshooting, A-1

ALTER DATABASE CONVERT statement, A-17

AUDIT_TRAIL initialization parameter, A-3

database name mismatch, A-19

datafile version integrity, A-20

Migration utility error messages, A-5

missing convert file, A-18

MULTIPLIER option, A-5

NOMOUNT database start mode, A-17

OPTIMAL setting, A-4

Oracle7 control file, A-17

password file, A-18

running the Migration utility, A-2

running the Oracle Data Migration Assistant, A-2

scripts run long, A-21

SYSTEM tablespace, A-2

temporary tablespace, A-2

tuning after, 8-14

upgrading to primary key snapshots, G-11

using import and export, G-10

Migration Assistant. See Oracle Data Migration Assistant

Migration utility

MTS. See multi-threaded server

MULTIPLIER

Migration utility option, 4-18, A-5

Multi-Protocol Interchange, F-2

multi-protocol support, F-2, F-17

multi-threaded server

requirements for running, 9-46

shared, 3-17

shared and local/remote connections, 3-17

multiversioning, 1-4

NAMES_DID table, F-18

NAMES_DOM table for Oracle Names, F-18

NAMES.ADMIN_REGION parameter, F-19, F-20

NAMES.DEFAULT_DOMAIN parameter, F-4

NAMES.DEFAULT_ZONE parameter, F-4

NAMES.DOMAINS parameter, F-18

namesini.sql script for Oracle Names, F-25

NAMES.PREFERRED_SERVERS parameter, F-4

namesupg.sql script for Oracle Names, F-18, F-20, F-23, F-25

national character set

in Oracle8i, 9-28

native dynamic SQL

downgrading, 13-34

interoperability, 9-30

NCHAR

migration, 9-28

use in Oracle8i, 9-28

NCHAR and NLS environment variables

compatibility, 9-11, 9-29

NCLOBs

compatibility, 9-26

nested tables

Net8

coexistence issues, F-5 to F-11

Oracle Names, F-11

release 8.0 client connection to release 8.1 database, F-6

release 8.1 client connection to release 8.0 database, F-9

release 8.1 client connection to release 8.1 database, F-5

release 8.1 client connection to version 7 database, F-9

third-party Oracle7 applications, F-8

using SERVICE_NAME, F-7

using SID, F-7

using the Net8 Assistant, F-11

compared with SQL*Net, F-2

connection load balancing, 9-47

FAILOVER parameter, F-11

listener.ora file with Oracle Enterprise Manager, F-15

LOAD_BALANCE parameter, F-11

migrating or upgrading to, 8-13, 9-46

NAMES.DEFAULT_DOMAIN parameter, F-4

NAMES.PREFERRED_SERVERS parameter, F-4

Net8 Assistant

Use Options Compatible with Net8 8.0 Clients option, F-11

Use Oracle8i Release 8.0 Compatible Identification option, F-11

obsolete parameters, F-4, F-14

COMMUNITY parameter, F-4

NAMES.DEFAULT_ZONE parameter, F-4

service naming, 9-47

downgrading, 13-50

SERVICE_NAME parameter, F-6

SOURCE_ROUTE parameter, F-11

upgrading

configuration files, F-13

listener.ora file, F-15

software on client, F-13

software on server, F-13

sqlnet.ora file, F-14

tnsnames.ora file, F-14

to Oracle Connection Manager release 8.1, F-16

to Oracle Names release 8.1, F-17

to release 8.1, F-12 to F-15

verify service name and instance name, F-12

Net8 Assistant, described, F-2

Net8 Configuration Assistant, described, F-2

NEVER REFRESH mode

adding after migration or upgrade, 8-8

new features

requiring 8.1.0 compatibility, 9-9

NEW_DBNAME

NLS

migration, 9-28

NLS and NCHAR environment variables

NLS_LANG environment variable

NLS_NCHAR

NMO_INFORMATION table for Oracle Names, F-19

nmcbild.sql script, F-22

nmcrgrnt.sql script, F-22

NO_SPACE_CHECK

NOCOPY parameter passing mode

n-tier authentication and authorization

obsolete replication procedures, G-14

NUMERIC keyword

behavior in Oracle7 and Oracle8i, 9-23

O7_DICTIONARY_ACCESSIBILITY parameter

compatibility, 9-25, B-9

object identifiers

user-defined

downgrading, 13-30

object tables

partitioned

downgrading, 13-23

OCI

applications

changing to use Oracle8i, 10-11

client notification, 9-9, 9-19

batch error mode, 9-19

link line, 9-19

LISTEN call and AQ, 9-20

thread safety, 9-19

interoperability, 9-18

Oracle7 clients, 9-19

shared structures, 9-18

OCIChangePassword call, 9-38

OCISessionBegin call, 9-38

upgrading applications to Oracle8i, 10-3

OCI applications

upgrading options, 10-8

ODCI.jar, 8-5

OFA, 1-11

offline datafiles

migration, 4-4

OID. See object identifiers

OLON calls

obsolete, 9-19

OLQP, 3-18

OLTP, 3-18

online index (re)build

online read-only tablespaces

migrating to a different, 4-8, 5-6

operating system

operators

dropping, 13-21

OPS. See Oracle Parallel Server

Optimal Flexible Architecture. See OFA

OPTIMAL setting for SYSTEM rollback segment

migration, A-4

optimization

compatibility, 9-35

extensible optimizer, 9-13

optimizer plan stability, 9-13

optimizer

plan stability

for Migration utility, 4-18

options

deinstalling, 1-13

ORA_NLS32 environment variable

ORA_NLS33 environment variable, 4-20

migrating to release 8.1, F-16

Oracle Advanced Queuing. See Advanced Queuing

Oracle AQ. See Advanced Queuing

Oracle Call Interface. See OCI

Oracle Connection Managers

CMADMIN process, F-16

CMCW process, F-16

intchg.ora, F-17

multi-protocol support, F-17

port 1610, F-16

port 1630, F-16

port 1830, F-16

tnsnav.ora file, F-17

tnsnet.ora file, F-17

upgrading to release 8.1, F-16

using instead of Oracle Multi-Protocol Interchange, F-17

Oracle Data Migration Assistant

advantages and disadvantages, 3-8

character set used, 5-7

differences from the Migration utility, 3-9

documentation roadmap, 5-2

migrating to a different operating system, 5-6

Oracle Parallel Server

does not support migration, 3-9

does not support upgrading, 7-7

overview, 5-3

restrictions, 5-3

running, 5-20, 7-7, 7-13

space required for SYSTEM tablespace, 5-4

Oracle Enterprise Manager

static service information in listener.ora file, F-15

Oracle home

multiple, 1-5

Oracle Media Management API

proxy copy requirement, 9-44

proxy copy and downgrading, 13-46

Oracle Names

Oracle Network Manager, described, F-2

Oracle Parallel Server

compatibility requirements, 9-35

downgrading, 13-61

instance affinity for jobs

not supported by Oracle Data Migration Assistant, 3-9

migration, 4-8

rolling upgrade, 1-13

upgrading, 7-3, 7-36

not supported by Oracle Data Migration Assistant, 7-7

Oracle precompilers. See precompilers

Oracle Trace Manager application, B-17

ORACLE_HOME initialization parameter, F-15

ORACLE_TRACE_COLLECTION_NAME server initialization parameter, B-17

ORACLE_TRACE_ENABLE initialization parameter, B-17

Oracle7

downgrading to, 14-1

prepare for migration, 4-10, 5-7

Windows platforms, 4-13, 5-12

Oracle8i

changes to initialization parameters, B-1

new features

adding after migration or upgrade, 8-8

new internal types, E-1

new SQL functions, E-1

ORADIM

downgrading, 13-57

migration, 4-25, 7-16

upgrading, 7-16

ORLON calls

obsolete, 9-19

OUTLN user

avoid, 4-11, 5-9, 7-4

change password, 8-2

OWA packages

compatibility, 9-33

PARALLEL clause

DEGREE keyword, 9-36

INSTANCES keyword removed, 9-36

parallel execution

allocated from large pool, B-11

avoiding problems with, 8-5

Parallel Server. See Oracle Parallel Server

parameters

for Migration utility. See command-line options

partially dropped columns

migrate to partition tables, 8-12

partition views

partitioning

password expiration, 9-39

downgrading, 13-22

removing LOBs, 13-28

password file

migration

exclusive setting, A-18

password management

application changes required for Oracle8i, 9-38

interoperability, 9-39

pending transactions

and migration, 4-8, 5-6

PFILE

plan stability

backward compatibility, 9-21

PL/SQL

bulk binds

downgrading, 13-34

compatibility, 9-13, 9-21

functions

desupported in Oracle8i, 9-30

interoperability, 9-21

modules

recompiling, 7-45

PLSQL_V2_COMPATIBILITY initialization parameter, 9-21

removing incompatibilities for downgrading, 13-33

variables

PREBUILT TABLE clause

upgrading dynamically linked, 10-7

precompilers

applications

changing to use Oracle8i, 10-10

upgrading options, 10-8

compatibility, 9-20

interoperability, 9-20

PL/SQL backward compatibility, 9-21

upgrading applications to Oracle8i, 10-3

prespawned dedicated servers, F-16

primary keys

upgrading snapshots, G-11

Pro*Ada

upgrading to SQL*Module for Ada, 9-20

Pro*C/C++

connecting with SYSDBA privileges, 9-20

Pro*COBOL

connecting with SYSDBA privileges, 9-20

Procedural Option

required for migration, 4-10, 5-8

propagation

removing, 13-40

PROPS$ view

NCHAR character set, 4-18

proxy copy

requirement, 9-44

queue tables

downgrading, 13-39

upgrading, 7-41

R0703040.SQL script

replication, 4-34, 5-21

RAW

maximum size

change, 9-16

read-only tablespaces

active transactions, 9-24

compatibility, 9-24

migration, 4-4

REAL keyword

behavior in Oracle7 and Oracle8i, 9-23

rebuilding indexes

physical ROWIDs, 12-10

recovery

compatibility, 9-12, 9-40

recovery catalog

compatibility with Recovery Manager, 9-40

upgrading, 7-43

Recovery Manager

backup management, 9-41

commands

compatibility, 9-41

compatibility, 9-40

downgrading to 8.0.3

re-installing packages, 13-64

normalize catalog, 8-9

REF columns

referential constraints on

downgrading, 13-31

REFRESH ON COMMIT mode

REFs

relinking with SQL*Net, 10-2

release

defined, 1-2

remote connections

multithreaded shared servers, 3-17

REMOTE_LOGIN_PASSWORDFILE initialization parameter

migration, A-18

removing incompatibilities for downgrading, 13-31

replication

compatibility, 9-12, 9-45

downgrading, 13-60

preparing environment for, 13-47

regenerating after, 13-63

migration, 4-7

migration overview, G-2

obsolete procedures, G-14

upgrading, 7-28

requirements

export, 6-2

resource manager. See database resource manager

restricted ROWIDs, 12-7

reverse migration

not supported, 14-2

ROLLBACK FORCE command, 4-8, 5-6

rollback segments

migration, 4-4

rosbild.sql script, F-22

ROSFILES

nmcbild.sql script, F-22

nmcgrnt.sql script, F-22

rosbild.sql script, F-22

rosgrnt.sql script, F-22

ROWIDs

extended, 12-7

migration and compatibility issues, 12-7

restricted, 12-7

rowids

compatibility, 9-27

client access, 12-7

conversion to Oracle8i format, 12-3

examples, 12-5

DBMS_ROWID compatibility package, 12-3

indexes, 12-10

migration, 12-1

FAQ, 12-9

questions and answers, 12-9

snapshot refresh, 12-6

SAVEPOINT keyword

behavior in Oracle7 and Oracle8i, 9-23

schema objects

scripts

downgrading, 13-54

rerunning, 4-34, 5-22, 7-22, 13-55

upgrading, 7-20

utlconst.sql, 8-4

secondary indexes

dropping from index-organized tables, 13-15

security policies

downgrading, 13-45

fine-grained access control, 13-45

serializable transactions, B-8

SERIALIZABLE=TRUE initialization parameter, B-8

server event data

collecting, B-17

Server Manager

differences with SQL*Plus

COMMIT command, 11-17

CREATE LIBRARY command, 11-16

CREATE TYPE command, 11-16

hyphen continuation character, 11-13

startup, 11-2

syntax, 11-9

migrating scripts to SQL*Plus, 11-1

server processes

SHUTDOWN, 9-23

service naming

Net8, 9-47

SERVICE_NAME parameter, F-6

SERVICE_NAMES initialization parameter, F-12, F-15

SET COMPATIBILITY command

SQL*Plus scripts, 10-11

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE command, B-8

SET_SESSION_LONGOPS procedure

syntax change, 9-34

shadow processes

open cursors and, 3-18

shared structures

interoperability, 9-18

SHARED_POOL_SIZE initialization parameter

changes in release 8.1, 8-5

upgrading to primary key, G-11

SID parameter, F-6

SID_NAME parameter, F-15

single-table hash clusters

snapshot sites

snapshots

refresh

physical ROWIDs, 12-6

upgrading, 7-37

SORT_AREA_SIZE initialization parameter

SORT_DIRECT_WRITES initialization parameter

source database

SOURCE_ROUTE parameter, F-11

space requirements

copying data, 3-15

migration, 3-15, 4-6, 5-4

Spatial

SPOOL

SQL

removing incompatibilities for downgrading, 13-33

functions

new in Oracle8i, E-3

SQL commands

ALTER SESSION SET ISOLATION_LEVEL=SERIALIZABLE, B-8

COMMIT FORCE, 4-8, 5-6

ROLLBACK FORCE, 4-8, 5-6

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, B-8

SQL*Module

for Ada, 9-20

SQL*Net, F-9

SQL*Net Easy Configuration, described, F-2

SQL*Plus

differences with Server Manager

COMMIT command, 11-17

CREATE LIBRARY command, 11-16

CREATE TYPE command, 11-16

hyphen continuation character, 11-13

startup, 11-2

syntax, 11-9

migrating scripts from Server Manager, 11-1

scripts

sqlnet.ora file

standby database

migrating to Oracle8i, 8-6

upgrading, 8-6

statements

ALTER DATABASE RESET COMPATIBILITY, 9-8

ALTER DATABASE RESET LOGS, 4-8, 5-6

static data dictionary views

added in Oracle8i, C-2

changed in Oracle8i

added columns, C-7

columns that may return NULLs, C-15

dropped columns, C-12

renamed columns, C-14

obsolete in Oracle8i, 9-25, C-17

statistics tables

upgrading, 7-44

stored outlines

SUBSTR operator, 9-16

summary management

user-created objects in, 9-25

SYS schema

SYSDBA

connecting in Pro*C/C++, 9-20

connecting in Pro*COBOL, 9-20

system requirements

for migration, 3-15

SYSTEM tablespace

Migration utility, 3-6, 4-6

Oracle Data Migration Assistant, 5-4

space

insufficient for migration, A-2

SYSTEM_TRIG_ENABLED initialization parameter, 7-31

tablespaces

compatibility, 9-9, 9-23

migrating offline tablespaces, 4-11, 5-9

target database

data dictionary information, 9-24

tempfiles

temporary tables

dropping for downgrading, 13-13

temporary tablespace

space

insufficient for migration, A-2

terminology

migration, 1-2

testing

applications for migration, 3-25

developing a plan for migration, 3-21

EXPLAIN PLAN, 3-24

functional for migration, 3-22

integration for migration, 3-22

INTO clause, 3-24

migration results, 8-13

minimal for migration, 3-22

performance for migration, 3-23

pre- and post-migration, 3-24

the migrated test database, 3-25

the migration process, 3-25

volume/load stress for migration, 3-23

thread safety

tnsnames.ora file

parameters

SID, F-7

tnsnav.ora file, F-17

tnsnet.ora file, F-17

TO_LABEL function

transactions

setting isolation levels, B-8

transportable tablespaces

removing transported tablespaces, 13-10

triggers

dropped automatically when downgrading, 13-43

on nested table view columns

downgrading, 13-43

troubleshooting

database fails to open after removing incompatibilities, 9-8

migration, A-1

ALTER DATABASE CONVERT statement, A-17

AUDIT_TRAIL initialization parameter, A-3

database name mismatch, A-19

datafile version integrity, A-20

Migration utility error messages, A-5

missing convert file, A-18

MULTIPLIER option, A-5

NOMOUNT database start mode, A-17

OPTIMAL setting, A-4

Oracle7 control file, A-17

password file, A-18

running the Migration utility, A-2

running the Oracle Data Migration Assistant, A-2

scripts run long, A-21

SYSTEM tablespace, A-2

temporary tablespace tablespace, A-2

TRUE keyword

behavior in Oracle7 and Oracle8i, 9-23

Trusted Oracle

Export/Import, 6-3

tuning

after migration, 8-14

Tuxedo applications

compatibility with Oracle8i XA libraries, 9-18

type DTYCHR, 12-10

types

mutually referencing

downgrading, 13-32

U0703040.SQL script, 4-33

Universal ROWIDs. See UROWIDs

unused columns

after upgrading, 8-1, 8-14

upgrading

Advanced Queuing, 7-38

applications, 10-1

compatibility rules, 10-5

options, 10-8

relinking, 10-5

initialization parameters, 7-18

interMedia Text, 7-24

Java, 7-31

JServer, 7-31

listener.ora file, 8-6

manually, 7-14

new administrative procedures, 8-8

Oracle Forms applications, 10-12

Oracle Parallel Server, 7-3, 7-36

rolling upgrade, 1-13

ORADIM, 7-16

OUTLN user, avoid, 7-4

parallel execution, 8-5

paths, 7-2

post upgrade, 8-1, 8-14

post-upgrade actions, 8-1

preparing to upgrade, 7-3

queue tables, 7-41

recovery catalog, 7-43

user-defined datatypes, 7-42

rerunning, 7-22

UTLRP.SQL, 7-45

snapshots, 7-37

specific components, 7-24

SQL*Plus scripts, 10-11

standby database, 8-6

statistics tables, 7-44

steps, 7-3

supported releases, 7-2

using the Oracle Data Migration Assistant, 7-7

UROWIDs

Use Options Compatible with Net8 8.0 Clients option, F-11

downgrading, 13-25

interoperability, 9-27

Use Oracle8i Release 8.0 Compatible Identification option, F-11

USE_PLUG_AND_PLAY_listener_name parameter, F-20

user-created objects

in SYS schema, 9-25

user-defined datatypes

downgrading, 13-29

interoperability, 9-29

new format, 9-29

upgrading, 7-42

user-defined object identifiers

re-installing after downgrading, 13-63

downgrading, 13-30

UTL_REF package

downgrading, 13-41

UTLCHN1.SQL script, 9-31

UTLDST.SQL script, 9-6, 13-9

UTLCONST.SQL script, 8-4

utlconst.sql script, 8-4

UTLEXPT1.SQL script, 9-31

UTLRP.SQL script, 4-34, 5-22, 7-45

VALUE$ view

VARCHAR2

maximum size

change, 9-16

varrays

removing incompatibilities, 13-32

stored as LOBs

compatibility, 9-29

varying-width character set

LOBs

downgrading, 13-27

version

defined, 1-2

version 6

Export/Import for migration, 6-2

versions

multiple, 1-4

views

mutually referencing

downgrading, 13-18

example of, 13-18

Visual Image Retrieval

word-size

changing, 1-12, 7-45

XA libraries