Index

ALTER DATABASE CONVERT statement, 4-4, 4-31

re-running, A-19

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

ALTER DATABASE RESET COMPATIBILITY statement, 9-7

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-6

downgrading, 13-44

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

from other databases, 9-43

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-13

ARCHIVE_DEST_n initialization parameter

downgrading, 13-46

archived redo logs

analyzing

compatibility, 9-42

rearchiving, 9-42

archiving

error detection behavior, 9-43

associations

downgrading, 13-43

AUDIT_TRAIL initialization parameter

migration, A-3

AUTOMATIC_IPC parameter, F-14

autonomous transactions

after migration or upgrade, 8-2

backups

before migration, 4-26

compatibility, 9-12, 9-39

EBU, 9-40

preparing a strategy for migration, 3-21

Recovery Manager and EBU, 9-40

bitmap indexes

invalidations, 9-26

during migration, 8-11

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

C language

C call specifications

discontinue using, 13-3, 13-26

cache reads

for LOBS

call specifications

downgrading, 13-32

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-32, 7-21, 13-59

CATEXP7.SQL script, 9-48

downgrading to Oracle7, 14-3

CATNOQUE.SQL script, 7-32

CATPARR.SQL script, 4-33, 7-28, 13-59, 13-60

CATPROC.SQL script, 4-4, 4-32, 7-21, 13-59

CATQUEUE.SQL script, 7-32

CATREP.SQL script, 4-33, 5-20, 7-23, 13-59

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-8, 5-6

Migration utility, 4-8

Oracle Data Migration Assistant, 5-6

varying-width

CLOBs and NCLOBs, 9-26

CHECK_ONLY

Migration utility option, 4-17, 4-21

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

collection locators

user-specified storage, 9-29

collections

collection columns

collection locators

compatibility, 9-29

columns

partially dropped

unused

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

command line

command-line options

Migration utility, 4-17

comments

on Oracle documentation, xxiii

COMMIT command

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

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-14, 9-32

agent self-registration, 9-12

ALTER DATABASE RESET COMPATIBILITY statement, 9-7

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-42

backup, 9-12, 9-39

change in maximum size

CHAR, 9-16

RAW, 9-16

VARCHAR2, 9-16

compatibility level, 9-5

COMPATIBLE initialization parameter, 9-2

CREATE TABLE behavior change, 9-31

data dictionary, 9-25

database resource manager, 9-14

datafiles, 9-24

datatypes, 9-26

date columns in dynamic performance views, D-13

DBMS_REPAIR package, 9-14

DISABLE VALIDATE constraints, 9-14

downgrading, 9-5

Export/Import, 9-48

extensible optimizer, 9-14

fine-grained access control, 9-12

Heterogeneous Services agents, 9-45

indexes

key compression, 9-10

initialization parameters, B-8

LOB index clause, 9-27

LOBs, 9-11, 9-26

CLOBS and NCLOBs, 9-26

LogMiner, 9-43

materialized views, 9-13

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-18

optimization, 9-34

optimizer plan stability, 9-14

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-39

fast-start rollback, 9-12

REFs, 9-11

removing incompatibilities, 13-2

replication, 9-12, 9-44

resetting for database, 13-51

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-14, 9-31

UTLEXPT1.SQL, 9-14, 9-31

SHUTDOWN IMMEDIATE, 9-23

snapshots, 9-44

Spatial, 9-15

SQL and PL/SQL, 9-14

autonomous transactions, 9-14

bulk binds, 9-14

C call specifications, 9-14

CALL statement, 9-14

native dynamic SQL, 9-14

NOCOPY parameter passing mode, 9-14

standby database, 9-41

summary management, 9-13

tablespaces, 9-9, 9-24

locally managed tablespaces, 9-9

online read-only tablespaces, 9-9

transportable tablespaces, 9-9

triggers, 9-14

UROWIDs, 9-11

user-defined object identifiers, 9-11

varrays, 9-11

stored as LOBs, 9-29

Visual Image Retrieval, 9-15

compatibility level

checking, 13-2

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-16

concurrent users, 3-18

CONNECT THROUGH privileges

revoking, 13-46

connections

load balancing in Net8, 9-47

local and remote, 3-16

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-24, 7-16, 13-57

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-18

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-18

cursors

number of open, 3-18

data definition conversion

Import utility, 3-13

data dictionary

compatibility, 9-25

protection, 9-25

database administrator

role during migration, 2-6

database resource manager

backing up for migration, 4-26

databases

downgrading, 13-52

test migration results, 8-12

tuning after migration, 8-12

datafiles

compatibility, 9-24

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-9

DB_NAME initialization parameter, F-15

DBMS

precompiler command line option, 9-20

DBMS_APPLICATION_INFO package

SET_SESSION_LONGOPS procedure

syntax change, 9-33

DBMS_LOB package

NOCOPY syntax and compatibility, 9-33

DBMS_REPAIR package

compatibility, 9-14, 9-33

downgrading, 13-41

DBMS_ROWID package, 12-3

DBMS_STATS package

upgrading statistics tables, 7-36

DBMSLOB.SQL script

compatibility, 9-33

DBNAME

DEC keyword

behavior in Oracle7 and Oracle8i, 9-23

definitions. See terminology

DEGREE keyword

in PARALLEL clause, 9-35

deinstalling, 1-13

Developer/2000 Applications

upgrading, 10-12

dimensions

downgrading, 13-21

DISABLE VALIDATE constraints

roadmap for Migration utility, 4-2

downgrading, 13-42

DML_LOCKS initialization parameter

compatibility, B-9

documentation

conventions, xxii

roadmap for Oracle Data Migration Assistant, 5-2

domain indexes

dropping, 13-20

downgrading

Advanced Queuing, 13-6, 13-34

CATALOG.SQL, 13-59

CATPROC.SQL, 13-59

locally managed tablespaces, 13-7, 13-12

Oracle Parallel Server, 13-59, 13-60

ORADIM, 13-56

procedure for, 13-52

queue tables, 13-38

removing incompatibilities, 13-2

application context, 13-44

associations, 13-43

bitmap index invalidation, 13-19

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

chained row tables, 13-25

DBMS_REPAIR package, 13-41

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-33

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

LOBs, 13-26

LOBs in index-organized tables, 13-14

locally managed tablespaces, 13-11

materialized views, 13-16

migrated tablespaces, 13-6, 13-10

mutually referencing types, 13-31

mutually referencing views, 13-17

nested tables, 13-31

Net8 service naming, 13-49

operators, 13-21

optimizer, 13-43

partially dropped columns, 13-15

partitioning, 13-21

plan stability, 13-44

referential constraints on REF columns, 13-30

replication, 13-47

secondary indexes on index-organized tables, 13-15

security policies, 13-45

SET_SESSION_LONGOPS syntax change, 13-40

single-table hash clusters, 13-16

SQL and PL/SQL, 13-32

stored outlines, 13-44

temporary tables, 13-12

transient segments, 13-7, 13-11

transported tablespaces, 13-10

triggers, 13-4, 13-42

triggers on nested table view columns, 13-42

unused columns, 13-15

UROWIDs, 13-24

user-defined datatypes, 13-28

user-defined object identifiers, 13-29

UTL_REF package, 13-40

varrays, 13-31

replication, 13-59

regenerating, 13-61

resetting database compatibility, 13-51

revoking CONNECT THROUGH privileges, 13-46

scripts, 13-53

to an older version 8 release, 13-1

rerunning, 13-54

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-4

drop column

DUMP_TNSNAMES command, F-20

DTYCHR type, 12-8

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-40

Enterprise Manager. See Oracle Enterprise Manager

enterprise user management

interoperability, 9-38

environment variables

compatibility

required for migration, 4-19, 4-22

ORA_NLS32, 9-28

ORA_NLS33, 4-19, 9-28

required for upgrading, 7-18

errors

during migration. See troubleshooting

exception tables

dropping, 13-25

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-48

time requirements for migration, 3-13

Trusted Oracle, 6-3

extended address field

Advanced Queuing, 7-30

extensible indexing

downgrading, 13-20

FAILOVER parameter, F-11

FALSE keyword

behavior in Oracle7 and Oracle8i, 9-23

FAST REFRESH mode

compatibility, 9-12, 9-41

fast-start parallel recovery

compatibility, 9-41

fast-start rollback

features

new features, 9-9

requiring migration, G-12

feedback

on Oracle documentation, xxiii

filenames

normalize, 8-8

fine-grained access control

upgrading Oracle Forms applications, 10-12

Forms

function-based indexes

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

invalidations

during upgrade, 8-13

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-45

interoperability, 9-45

multithreaded, 9-45

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-4

indexes

domain

key compression, 9-10

on physical ROWID, 12-8

rebuilding

physical ROWIDs, 12-8

index-organized tables

removing partitions from, 13-21

removing LOBs from, 13-14

indextypes

dropping, 13-20

initialization parameters

added in Oracle8i, B-2

adjusting for release 8.1, 4-29, 5-10, 7-17, 8-8

archive log destination

switching to new, B-13

changes in Oracle8i, B-1

compatibility, B-8

DB_DOMAIN, B-9

DML_LOCKS, B-9

LOG_CHECKPOINT_TIMEOUT, B-9

O7_DICTIONARY_ACCESSIBILITY, B-9

SORT_AREA_SIZE, B-8

SORT_DIRECT_WRITES, B-8

COMPATIBLE, 9-2

LARGE_POOL_SIZE

obsolete in Oracle8i, B-6

renamed in Oracle8i, B-4

SHARED_POOL_SIZE

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

INIT.ORA parameters. See initialization parameters

installation

INSTANCE_NAME initialization parameter, F-12

INSTANCES keyword

removed from PARALLEL clause, 9-35

INT keyword

behavior in Oracle7 and Oracle8i, 9-23

intchg.ora file, F-17

interMedia

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

internal datatypes

new in Oracle8i, E-2

interoperability, 9-1, 9-15

Advanced Queuing, 9-32

applications, 9-16

Heterogeneous Services agents, 9-45

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

Java

installing CartridgeServices.jar, 8-5

installing ODCI.jar, 8-5

removing incompatibilities for downgrading, 13-33

upgrading, 7-26

JVMU815.SQL script, 7-26

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-27

local connections

multithreaded shared servers, 3-16

locally managed tablespaces

converting to dictionary tablespaces, 13-11

locks

DML lock limit, DML_LOCKS, B-9

LOG_CHECKPOINT_TIMEOUT

new default value, B-9

LOG_CHECKPOINT_TIMEOUT initialization parameter

compatibility, B-9

LogMiner

compatibility, 9-43

LONG datatype

copying to LOB, 8-2

master sites

incremental migration of, G-7

migration, G-3

materialized views

compatibility, 9-13

downgrading, 13-16

BUILD DEFERRED clause, 13-17

FAST REFRESH mode, 13-17

NEVER REFRESH mode, 13-17

PREBUILT TABLE clause, 13-17

REFRESH ON COMMIT mode, 13-16

removing incompatibilities, 13-16

memory requirements

concurrent access, 3-16

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

migprep utility

running, 4-18

MIGRATE user

avoid, 4-10, 5-9

MIGRATE.BSQ script, 4-25

migrated tablespaces

correcting transient segments, 13-7, 13-11

removing migrated tablespaces, 13-6, 13-10

migration

abandoning, 4-35, 5-23

after migrating, 8-1, 8-11

ALTER DATABASE CONVERT statement, 4-4, 4-31

re-running, A-19

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

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-8, 5-6

choosing a method, 3-3

control files, 4-24, 7-16, 13-57

copying data, 3-14

exclusive password file, A-18

Export/Import, 3-10

steps, 6-2

features requiring, G-12

incremental, G-4

initialization parameters, 4-29, 5-10, 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-18

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

MIGRATE.BSQ script, 4-25

Migration utility, 3-6

new administrative procedures, 8-8

obsolete replication procedures, G-13

offline datafiles, 4-4

offline tablespaces, 4-10, 5-8

OPTIMAL setting for SYSTEM rollback segment, A-4

Oracle Data Migration Assistant, 3-8

Oracle Parallel Server, 4-7

rolling upgrade, 1-13

ORADIM, 4-24, 7-16

OUTLN user, avoid, 4-10, 5-8

overview for replication, G-2

overview of steps, 2-2

parallel execution, 8-5

post migration, 8-1, 8-11

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

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

Windows platforms, 4-12, 5-11

preparing to migrate, 3-2

read-only tablespaces, 4-4

replication, 4-7

role of application developer, 2-6

role of database administrator, 2-6

rollback segments, 4-4

rowids, 12-1

FAQ, 12-7

scripts

CATALOG.SQL, 4-4, 4-32

CATPARR.SQL, 4-33

CATPROC.SQL, 4-4, 4-32

CATREP.SQL, 4-33, 5-20

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

R0703040.SQL, 4-33, 5-20

rerunning, 4-32, 5-21

U0703040.SQL, 4-32

UTLRP.SQL, 4-33, 5-21

snapshot sites, G-6

SQL*Net requirement

Windows platforms, 4-12, 5-11

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-12

troubleshooting, A-1

ALTER DATABASE CONVERT statement, A-16

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-17

MULTIPLIER option, A-4

NOMOUNT database start mode, A-17

OPTIMAL setting, A-4

Oracle7 control file, A-16

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-12

upgrading to primary key snapshots, G-10

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-17, A-4

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

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-12, 9-45

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-49

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-7

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-13

NUMERIC keyword

behavior in Oracle7 and Oracle8i, 9-23

O7_DICTIONARY_ACCESSIBILITY parameter

compatibility, 9-25, B-9

object identifiers

user-defined

downgrading, 13-29

object tables

partitioned

downgrading, 13-23

OCI

applications

changing to use Oracle8i, 10-10

client notification, 9-9, 9-19

batch error mode, 9-19

link line, 9-19

LISTEN call and AQ, 9-19

thread safety, 9-18

interoperability, 9-18

Oracle7 clients, 9-19

shared structures, 9-18

OCIChangePassword call, 9-37

OCISessionBegin call, 9-37

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-18

OLQP, 3-17

OLTP, 3-17

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-34

extensible optimizer, 9-14

optimizer plan stability, 9-14

optimizer

downgrading, 13-43

plan stability

for Migration utility, 4-17

options

deinstalling, 1-13

ORA_NLS32 environment variable

ORA_NLS33 environment variable, 4-19

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-6

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-6

overview, 5-3

restrictions, 5-3

running, 5-19, 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-43

proxy copy and downgrading, 13-46

Oracle Names

Oracle Network Manager, described, F-2

Oracle Parallel Server

compatibility requirements, 9-34

downgrading, 13-59, 13-60

instance affinity for jobs

not supported by Oracle Data Migration Assistant, 3-9

migration, 4-7

rolling upgrade, 1-13

upgrading, 7-3, 7-28

not supported by Oracle Data Migration Assistant, 7-6

Oracle precompilers. See precompilers

ORACLE_HOME initialization parameter, F-15

Oracle7

downgrading to, 14-1

prepare for migration, 4-9, 5-7

Windows platforms, 4-12, 5-11

Oracle8i

changes to initialization parameters, B-1

new features

adding after migration or upgrade, 8-7

new internal types, E-1

new SQL functions, E-1

ORADIM

downgrading, 13-56

migration, 4-24, 7-16

upgrading, 7-16

ORLON calls

obsolete, 9-18

OUTLN user

avoid, 4-10, 5-8, 7-3

change password, 8-2

PARALLEL clause

DEGREE keyword, 9-35

INSTANCES keyword removed, 9-35

parallel execution

allocated from large pool, B-10

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-11

partition views

partitioning

password expiration, 9-38

downgrading, 13-21

removing LOBs, 13-27

password file

migration

exclusive setting, A-18

password management

application changes required for Oracle8i, 9-37

interoperability, 9-38

PFILE

plan stability

backward compatibility, 9-20

downgrading, 13-44

PL/SQL

bulk binds

desupported in Oracle8i, 9-30

compatibility, 9-14, 9-21

functions

interoperability, 9-21

modules

recompiling, 7-36

PLSQL_V2_COMPATIBILITY initialization parameter, 9-21

removing incompatibilities for downgrading, 13-32

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-20

upgrading applications to Oracle8i, 10-3

prespawned dedicated servers, F-16

primary keys

upgrading snapshots, G-10

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-9, 5-7

propagation

removing, 13-39

PROPS$ view

NCHAR character set, 4-17

proxy copy

requirement, 9-43

queue tables

downgrading, 13-38

upgrading, 7-33

R0703040.SQL script

replication, 4-33, 5-20

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-8

recovery

compatibility, 9-12, 9-39

recovery catalog

compatibility with Recovery Manager, 9-39

upgrading, 7-34

Recovery Manager

backup management, 9-40

commands

compatibility, 9-40

compatibility, 9-39

downgrading to 8.0.3

re-installing packages, 13-62

normalize catalog, 8-8

REF columns

referential constraints on

downgrading, 13-30

REFRESH ON COMMIT mode

materialized views and downgrading, 13-16

REFs

relinking with SQL*Net, 10-2

release

defined, 1-2

remote connections

multithreaded shared servers, 3-16

REMOTE_LOGIN_PASSWORDFILE initialization parameter

migration, A-18

removing incompatibilities for downgrading, 13-31

replication

compatibility, 9-12, 9-44

downgrading, 13-59

preparing environment for, 13-47

regenerating after, 13-61

migration, 4-7

migration overview, G-2

obsolete procedures, G-13

upgrading, 7-23

requirements

export, 6-2

resource manager. See database resource manager

reverse migration

not supported, 14-2

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

compatibility, 9-27

client access, 12-7

conversion to Oracle8i format, 12-3

examples, 12-5

DBMS_ROWID compatibility package, 12-3

indexes, 12-8

migration, 12-1

FAQ, 12-7

questions and answers, 12-7

snapshot refresh, 12-6

SAVEPOINT keyword

behavior in Oracle7 and Oracle8i, 9-23

schema objects

scripts

downgrading, 13-53

rerunning, 4-32, 5-21, 7-21, 13-54

upgrading, 7-19

secondary indexes

dropping from index-organized tables, 13-15

security policies

downgrading, 13-45

fine-grained access control, 13-45

Server Manager

differences with SQL*Plus

COMMIT command, 11-18

CREATE LIBRARY command, 11-18

CREATE TYPE command, 11-18

hyphen continuation character, 11-15

startup, 11-2

syntax, 11-11

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_SESSION_LONGOPS procedure

syntax change, 9-33

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-10

SID parameter, F-6

SID_NAME parameter, F-15

single-table hash clusters

snapshot sites

snapshots

refresh

physical ROWIDs, 12-6

upgrading, 7-29

SORT_AREA_SIZE initialization parameter

compatibility, B-8

SORT_DIRECT_WRITES initialization parameter

compatibility, B-8

source database

SOURCE_ROUTE parameter, F-11

space requirements

copying data, 3-15

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

Spatial

compatibility, 9-15

SPOOL

SQL

removing incompatibilities for downgrading, 13-32

functions

new in Oracle8i, E-3

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-18

CREATE LIBRARY command, 11-18

CREATE TYPE command, 11-18

hyphen continuation character, 11-15

startup, 11-2

syntax, 11-11

migrating scripts from Server Manager, 11-1

scripts

sqlnet.ora file

standby database

migrating to Oracle8i, 8-6

upgrading, 8-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-16

statistics tables

upgrading, 7-36

stored outlines

downgrading, 13-44

SUBSTR operator, 9-16

summary management

compatibility, 9-13

SYS schema

user-created objects in, 9-25

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

tablespaces

compatibility, 9-9, 9-24

migrating offline tablespaces, 4-10, 5-8

target database

data dictionary information, 9-24

tempfiles

temporary tables

dropping for downgrading, 13-12

temporary tablespace

space

insufficient for migration, A-2

terminology

migration, 1-2

testing

applications for migration, 3-26

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-12

minimal for migration, 3-22

performance for migration, 3-22

pre- and post-migration, 3-24

the migrated test database, 3-26

the migration process, 3-24

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

desupported, 9-30

TO_LOB function, 8-2

TP monitors, 3-17

transportable tablespaces

removing transported tablespaces, 13-10

triggers

dropped automatically when downgrading, 13-42

on nested table view columns

downgrading, 13-42

troubleshooting

migration, A-1

ALTER DATABASE CONVERT statement, A-16

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-17

MULTIPLIER option, A-4

NOMOUNT database start mode, A-17

OPTIMAL setting, A-4

Oracle7 control file, A-16

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-12

Tuxedo applications

compatibility with Oracle8i XA libraries, 9-18

type DTYCHR, 12-8

types

mutually referencing

downgrading, 13-31

U0703040.SQL script, 4-32

Universal ROWIDs. See UROWIDs

unused columns

after upgrading, 8-1, 8-13

upgrading

Advanced Queuing, 7-30

applications, 10-1

compatibility rules, 10-5

options, 10-8

relinking, 10-5

initialization parameters, 7-17

Java, 7-26

listener.ora file, 8-6

manually, 7-13

new administrative procedures, 8-8

Oracle Forms applications, 10-12

Oracle Parallel Server, 7-3, 7-28

rolling upgrade, 1-13

ORADIM, 7-16

OUTLN user, avoid, 7-3

parallel execution, 8-5

paths, 7-2

post upgrade, 8-1, 8-13

post-upgrade actions, 8-1

preparing to upgrade, 7-3

queue tables, 7-33

recovery catalog, 7-34

user-defined datatypes, 7-34

specific components, 7-23

SQL*Plus scripts, 10-11

standby database, 8-6

statistics tables, 7-36

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-24

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-28

interoperability, 9-29

new format, 9-29

upgrading, 7-34

user-defined object identifiers

re-installing after downgrading, 13-61

downgrading, 13-29

UTL_REF package

downgrading, 13-40

UTLCHN1.SQL script, 9-31

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

UTLCONST.SQL script, 8-4

UTLEXPT1.SQL script, 9-31

UTLRP.SQL script, 4-33, 5-21, 7-36

VALUE$ view

VARCHAR2

maximum size

change, 9-16

varrays

removing incompatibilities, 13-31

stored as LOBs

compatibility, 9-29

varying-width character set

LOBs

downgrading, 13-26

version

defined, 1-2

version 6

Export/Import for migration, 6-2

versions

multiple, 1-4

views

mutually referencing

downgrading, 13-17

example of, 13-18

Visual Image Retrieval

compatibility, 9-15

word-size

changing, 1-12, 7-37

XA libraries