Index

ALTER DATABASE CONVERT command, 3-4, 3-26

re-running, A-19

ALTER DATABASE OPEN RESETLOGS command, 3-4, 3-26

ALTER DATABASE RESET COMPATIBILITY, 8-7

ALTER TABLE command

bitmap index invalidation, 8-25

ANALYZE TABLE VALIDATE STRUCTURE command

change in release 8.1, 8-17

application context

role during migration, 1-10

downgrading, 12-36

application developer

applications

compatibility, 8-16

index-organized tables

compatibility, 8-16

interoperability, 8-16

OCI

physical ROWIDs and UROWIDs, 8-16

interoperability, 8-17

physical ROWIDs in Oracle8i, 11-2

PL/SQL

compatibility, 8-20

interoperability, 8-20

precompiler

compatibility, 8-18

interoperability, 8-18

Tuxedo applications

error detection behavior, 8-43

upgrading, 9-1

AQ. See Advanced Queuing

archive log destination parameters

new in release 8.1, B-13

archiving

associations

downgrading, 12-35

AUDIT_TRAIL initialization parameter

migration, A-3

autonomous transactions

preparing a strategy for migration, 2-18

backup

after migration, 6-2

before migration, 3-20

compatibility, 8-13, 8-39

EBU, 8-40

Recovery Manager and EBU, 8-40

bitmap indexes

invalidations, 8-25

during migration, 6-3

when downgrading, 12-12

block size

DB_BLOCK_SIZE initialization parameter, 3-6, 4-5

minimums for migration, 3-6, 4-5

BUILD DEFERRED clause

bulk binds

C call specifications

CALL statement

CATALOG.SQL script, 3-4, 3-27, 7-19, 12-49

CATALOG5.SQL, obsolete with Oracle8i, 8-24

CATALOG6.SQL, obsolete with Oracle8i, 8-24

CATEXP7.SQL script, 8-48

downgrading to Oracle7, 13-3

CATNOQUEUE.SQL script, 7-28

CATPARR.SQL script, 3-28, 7-24, 12-49

CATPROC.SQL script, 3-4, 3-27, 7-19, 12-49

CATQUEUE.SQL script, 7-28

CATREP.SQL script, 3-28, 4-17, 7-21, 12-49

chained row tables

dropping, 12-18

CHARACTER keyword

behavior in Oracle7 and Oracle8i, 8-22

character set

migrating the database, 3-8, 4-6

character sets

Migration utility, 3-8

Oracle Data Migration Assistant, 4-6

varying-width

CLOBs and NCLOBs, 8-25

CHECK_ONLY

Migration utility option, 3-14, 3-18

CLOBs

compatibility, 8-25

cluster tables

copying data, 2-15

collection columns

user-specified storage

compatibility, 8-29

collection locators

compatibility, 8-12, 8-29

columns

partially dropped

dropping, 12-8

unused

dropping, 12-8

command-line options

Migration utility, 3-14

comments

differences between Server Manager and SQL*Plus, 10-7

COMMIT command

differences between Server Manager and SQL*Plus, 10-14

COMMIT keyword

behavior in Oracle7 and Oracle8i, 8-22

compatibility, 8-1

8.1.0 compatibility level

features requiring, 8-9

Advanced Queuing, 8-14, 8-32

Advanced Replication, 8-13, 8-45

agent self-registration, 8-13

ALTER DATABASE RESET COMPATIBILITY, 8-7

ANALYZE VALIDATE STRUCTURE command, 8-17

application context, 8-13

applications, 8-16

index-organized tables, 8-16

physical ROWIDs and UROWIDs, 8-16

Tuxedo applications, 8-17

XA calls, 8-17

backup, 8-13, 8-39

compatibility level, 8-5

COMPATIBLE initialization parameter, 8-2

conventional path export, 8-48

CREATE TABLE behavior change, 8-31

database resource manager, 8-14

date columns in dynamic performance views, D-11

DBMS_REPAIR package, 8-14

direct path export, 8-48

DISABLE VALIDATE constraints, 8-14

Export/Import, 8-48

extensible optimizer, 8-14

fine-grained access control, 8-13

Heterogeneous Services agents, 8-45

indexes

key compression, 8-10

initialization parameters, B-8

LOBs, 8-11, 8-25

CLOBS and NCLOBs, 8-25

materialized views, 8-13

NLS and NCHAR environment variables, 8-28

nested tables, 8-29

n-tier authentication and authorization, 8-13

OCI, 8-17

link line, 8-18

thread safety, 8-18

optimization, 8-34

optimizer plan stability, 8-14

Oracle Media Management API, 8-13

Oracle Parallel Server

instance affinity for jobs, 8-12

packages

PLSQL_V2_COMPATIBILITY initialization parameter, 8-20

precompilers, 8-18

recovery, 8-13, 8-39

fast-start rollback, 8-13

removing incompatibilities, 12-2

replication, 8-44

resetting for database, 12-42

schema objects, 8-10

collection locators, 8-12

drop column, 8-10

extensible indexing, 8-10

function-based indexes, 8-10

indexes, 8-10

index-organized tables, 8-10

nested tables, 8-12

online index (re)build, 8-10

single-table hash clusters, 8-10

temporary tables, 8-10

scripts

UTLCHAIN1.SQL, 8-14, 8-31

UTLEXCPT1.SQL, 8-14, 8-31

Spatial, 8-15

SQL and PL/SQL, 8-14

autonomous transactions, 8-14

bulk binds, 8-14

C call specifications, 8-14

CALL statement, 8-14

native dynamic SQL, 8-14

NOCOPY parameter passing mode, 8-14

standby database, 8-41

summary management, 8-13

tablespaces, 8-9

locally managed tablespaces, 8-9

online read-only tablespaces, 8-9

transportable tablespaces, 8-9

triggers, 8-14

UROWIDs, 8-11

user-defined object identifiers, 8-12

VARRAYs, 8-12

Visual Image Retrieval, 8-15

COMPATIBLE initialization parameter, 8-2

8.1.0 setting

features requiring, 8-9

checking the setting, 8-5

database structures, 8-3

setting the, 8-6

composite methods

partitioning and downgrading, 12-17

concurrent access, 2-16

concurrent users, 2-17

connections

load balancing in Net8, 8-47

local and remote, 2-16

with multithreaded shared server, 2-16

control files

renaming or removing for migration, 3-22

copying data

large cluster tables, 2-15

migration method, 2-14

space requirements, 2-15

CREATE LIBRARY command

differences between Server Manager and SQL*Plus, 10-13

CREATE TABLE

behavior change

Oracle7 to Oracle8i, 8-31

CREATE TYPE command

differences between Server Manager and SQL*Plus, 10-13

cursors

number of open, 2-17

data definition conversion

Import utility, 2-13

data dictionary

protection, 8-24

database administrator

role during migration, 1-10

database resource manager

backing up for migration, 3-20

databases

downgrading, 12-43

test migration results, 6-6

tuning after migration, 6-6

datafiles

offline during migration, 3-4

datatypes

internal

new in Oracle8i, E-2

date constraints

checking for bad, 6-2, 7-33

DB_BLOCK_SIZE initialization parameter

migration, 3-6, 4-5

DB_DOMAIN initialization parameter

compatibility, B-9

DBMS

precompiler command line option, 8-19

DBMS_LOB package

NOCOPY syntax and compatibility, 8-33

DBMS_REPAIR package

compatibility, 8-14, 8-33

DBMS_ROWID package, 11-3

DBMSLOB.SQL script

compatibility, 8-33

DBNAME

definitions. See terminology

DEC keyword

behavior in Oracle7 and Oracle8i, 8-22

DEGREE keyword

in PARALLEL clause, 8-35

deinstalling, 1-6

Developer/2000 Applications

upgrading, 9-6

dimensions

downgrading, 12-14

DISABLE VALIDATE constraints

roadmap for Migration utility, 3-2

downgrading, 12-34

DML_LOCKS initialization parameter

compatibility, B-8

documentation

roadmap for Oracle Data Migration Assistant, 4-2

domain indexes

dropping, 12-13

downgrading

Advanced Replication

regenerating, 12-51

advanced replication, 12-49

CATALOG.SQL, 12-49

CATPROC.SQL, 12-49

Oracle Parallel Server, 12-49

procedure for, 12-43

queue tables, 12-31

removing incompatibilities, 12-2

Advanced Replication, 12-38

application context, 12-36

associations, 12-35

bitmap index invalidation, 12-12

chained row tables, 12-18

dimensions, 12-14

DISABLE VALIDATE constraints, 12-34

domain indexes, 12-13

exception tables, 12-18

extensible indexing, 12-13

fine-grained access control, 12-37

function-based indexes, 12-13

indextypes, 12-13

Java, 12-26

key compression on indexes and index-organized tables, 12-6

LOBs, 12-19

LOBs in index-organized tables, 12-7

locally managed tablespaces, 12-5

materialized views, 12-9

mutually referencing types, 12-24

mutually referencing views, 12-10

nested tables, 12-23

Net8 service naming, 12-41

operators, 12-14

optimizer, 12-35

partially dropped columns, 12-8

partitioning, 12-14

plan stability, 12-36

secondary indexes on index-organized tables, 12-8

security policies, 12-37

SET_SESSION_LONGOPS syntax change, 12-33

single-table hash clusters, 12-9

SQL and PL/SQL, 12-25

stored outlines, 12-36

temporary tables, 12-6

transported tablespaces, 12-5

triggers, 12-35

triggers on nested table view columns, 12-34

unused columns, 12-8

UROWIDs, 12-17

user-defined datatypes, 12-21

user-defined object identifiers, 12-22

UTL_REF package, 12-33

VARRAYs, 12-24

resetting database compatibility, 12-42

scripts, 12-45

rerunning, 12-46

to an older Oracle8i release, 12-1

to Oracle7, 13-1

alternative methods, 13-4

CATEXP7.SQL script, 13-3

drop column

required for migration, 3-16, 3-21

DTYCHR type, 11-8

dynamic performance views

added in Oracle8i, D-2

changed in Oracle8i

added columns, D-8

date columns

compatibility, D-11

obsolete in Oracle8i, D-11

renamed in Oracle8i, D-7

EBU

backup management, 8-40

enterprise directory service

interoperability, 8-38

environment variables

compatibility

NCHAR and NLS, 8-28

ORA_NLS32, 8-28

ORA_NLS33, 3-16, 8-28

required for upgrading, 7-16

TWO_TASK, 3-16

errors during migration. See troubleshooting

exception tables

dropping, 12-18

Export utility

migration, 2-10, 5-1

Oracle8i using CATEXP7.SQL, 13-3

requirements for migration, 5-2

Export/Import

advantages and disadvantages, 2-10

basic steps for migration, 5-2

benefits for migration, 2-12

compatibility, 8-48

data definition conversion, 2-13

direct and conventional path, 8-48

effects on migrated databases, 2-11

incompatible data, 8-49

limitations for migration, 2-12

migration steps using, 5-3

scripts

CATEXP7.SQL, 8-48

time requirements for migration, 2-13

Trusted Oracle, 5-3

extended address field

Advanced Queuing, 7-26

extensible indexing

downgrading, 12-13

FALSE keyword

behavior in Oracle7 and Oracle8i, 8-22

FAST REFRESH mode

compatibility, 8-13, 8-42

fast-start parallel recovery

compatibility, 8-42

fast-start rollback

features

new features, 8-9

fine-grained access control

upgrading Oracle Forms applications, 9-6

Forms

function-based indexes

glossary. See terminology

functions

SQL

new in Oracle8i, E-3

Heterogeneous Services

agents

compatibility, 8-45

interoperability, 8-45

multithreaded, 8-45

Import utility

data definition conversion, 2-13

migration, 2-10, 5-1

requirements for migration, 5-2

incompatibilities

removing, 12-2

system-defined, 12-4

incompatibilities, system-defined, 8-6

index

key compression, 8-10

index on physical ROWID, 11-8

index rebuilding

physical ROWIDs, 11-8

indexes

domain

function-based

index-organized tables

removing partitions from, 12-14

removing LOBs from, 12-7

indextypes

dropping, 12-13

initialization parameters

added in Oracle8i, B-2

adjusting for release 8.1, 3-24, 4-10, 7-15

archive log destination

switching to new, B-13

changes in Oracle8i, B-1

compatibility, B-8

DB_DOMAIN, B-9

DML_LOCKS, B-8

O7_DICTIONARY_ACCESSIBILITY, B-8

COMPATIBLE, 8-2

LARGE_POOL_SIZE

obsolete in Oracle8i, B-6

renamed in Oracle8i, B-4

SHARED_POOL_SIZE

INIT.ORA parameters. See initialization parameters

installation

release 8.1 Oracle software, 3-12, 4-11, 5-3

INSTANCES keyword

removed from PARALLEL clause, 8-35

INT keyword

behavior in Oracle7 and Oracle8i, 8-22

internal datatypes

new in Oracle8i, E-2

interoperability, 8-1, 8-15

Advanced Queuing, 8-32

applications, 8-16

Heterogeneous Services agents, 8-45

native dynamic SQL, 8-30

user-defined datatypes, 8-29

OCI, 8-17

Oracle7 clients, 8-18

shared structures, 8-17

PL/SQL, 8-20

precompilers, 8-18

UROWIDs, 8-26

Java

removing incompatibilities for downgrading, 12-26

upgrading

drop Java objects, 7-36

export Java objects, 7-3

import Java objects, 7-36

key compression

discontinuing use of, 12-6

keywords

behavior differences

Oracle7 and Oracle8i, 8-22

large files

operating system dependencies, 8-50

Large Objects. See LOBs

LARGE_POOL_SIZE initialization parameter

changes in release 8.1, 6-3, 7-34

removing from index-organized tables, 12-7

load balancing

Net8, 8-47

LOBs

compatibility, 8-11, 8-25

downgrading, 12-19

removing from partitioned tables, 12-20

local connections

multithreaded shared servers, 2-16

locally managed tablespaces

converting to dictionary tablespaces, 12-5

locks

DML lock limit, DML_LOCKS, B-8

materialized views

BUILD DEFERRED clause, 12-10

downgrading, 12-9

FAST REFRESH mode, 12-10

NEVER REFRESH mode, 12-10

PREBUILT TABLE clause, 12-10

REFRESH ON COMMIT mode, 12-9

removing incompatibilities, 12-9

memory requirements

concurrent access, 2-16

migration, 2-15, 3-6, 4-4

MIGRATE user

avoid, 3-10, 4-8

MIGRATE.BSQ script, 3-19

migrating

from Server Manager to SQL*Plus, 10-1

migration

abandoning, 3-30, 4-20

advanced replication, 3-7

ALTER DATABASE CONVERT command, 3-4, 3-26

re-running, A-19

ALTER DATABASE OPEN RESETLOGS command, 3-4, 3-26

AUDIT_TRAIL initialization parameter, A-3

avoiding common problems, 2-18

backup strategy, 2-18

block size minimums, 3-6, 4-5

character set, 3-8, 4-6

choosing a method, 2-3

control files, 3-22

copying data, 2-14

exclusive password file, A-18

Export/Import, 2-10

steps, 5-2

initialization parameters, 3-24, 4-10, B-1

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

MIGRATE user, avoid, 3-10, 4-8

MIGRATE.BSQ script, 3-19

Migration utility, 2-6

new administrative procedures, 6-7

offline datafiles, 3-4

offline tablespaces, 3-10, 4-8

OPTIMAL setting for SYSTEM rollback segment, A-4

Oracle Data Migration Assistant, 2-8

Oracle Parallel Server, 3-7

rolling upgrade, 1-5

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

overview of steps, 1-6

parallel execution, 6-3

post-migration actions, 6-1, 10-1

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

preparing to migrate, 2-2

read-only tablespaces, 3-4

role of application developer, 1-10

role of database administrator, 1-10

rollback segments, 3-4

scripts

CATALOG.SQL, 3-4, 3-27

CATPARR.SQL, 3-28

CATPROC.SQL, 3-4, 3-27

CATREP.SQL, 3-28, 4-17

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

R0703040.SQL, 3-28, 4-17

rerunning, 3-27, 4-17

U0703040.SQL, 3-27

UTLRP.SQL, 3-28, 4-18

system requirements, 2-15

SYSTEM tablespace, A-2

temporary tablespace, A-2

ALTER DATABASE CONVERT command, 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

SYSTEM tablespace, A-2

temporary tablespace, A-2

tuning after, 6-6

Migration Assistant. See Oracle Data Migration Assistant

Migration utility

MULTIPLIER

Migration utility option, 3-14, A-4

multithreaded server

requirements for running, 8-46

shared, 2-17

shared and local/remote connections, 2-16

multi-versioning, 8-50

national character set

in Oracle8i, 8-27

native dynamic SQL

interoperability, 8-30

NCHAR

compatibility, 8-27

interoperability, 8-27

migration, 8-27

use in Oracle8i, 8-27

NCHAR and NLS environment variables

compatibility, 8-12, 8-29

NCLOBs

compatibility, 8-25

nested tables

Net8

connection load balancing, 8-47

migrating or upgrading to, 6-4, 8-46

service naming, 8-47

downgrading, 12-41

NEVER REFRESH mode

adding after migration, 6-7

new features of Oracle8i

NEW_DBNAME

NLS

compatibility, 8-27

interoperability, 8-27

migration, 8-27

NLS and NCHAR environment variables

NLS_LANG environment variable

NLS_NCHAR

NO_SPACE_CHECK

NOCOPY parameter passing mode

n-tier authentication and authorization

NUMERIC keyword

behavior in Oracle7 and Oracle8i, 8-22

O7_DICTIONARY_ACCESSIBILITY parameter

compatibility, 8-24, B-8

object tables

partitioned

downgrading, 12-16

object-identifiers

user-defined

downgrading, 12-22

OCI

OCIChangePassword call, 8-37

client notification, 8-9

link line, 8-18

thread safety, 8-18

interoperability, 8-17

Oracle7 clients, 8-18

shared structures, 8-17

OCISessionBegin call, 8-37

upgrading applications to Oracle8i, 9-2

OFA, 1-5

offline datafiles

migration, 3-4

OLON calls

obsolete, 8-18

OLQP, 2-17

OLTP, 2-17

online index (re)build

online read-only tablespaces

migrating to a different, 3-7, 4-5

operating system

operators

dropping, 12-14

Optimal Flexible Architecture. See OFA

OPTIMAL setting for SYSTEM rollback segment

migration, A-4

optimization

compatibility, 8-34

extensible optimizer, 8-14

optimizer plan stability, 8-14

optimizer

downgrading, 12-35

plan stability

for Migration utility, 3-14

options

deinstalling, 1-6

ORA_NLS32 environment variable

ORA_NLS33 environment variable, 3-16

Oracle Call Interface. See OCI

Oracle Data Migration Assistant

advantages and disadvantages, 2-8

character set used, 4-6

differences from the Migration utility, 2-9

documentation roadmap, 4-2

migrating to a different operating system, 4-5

Oracle Parallel Server

does not support migration, 2-9, 4-3

does not support upgrading, 7-6

overview, 4-3

running, 4-16, 7-7, 7-12

space required for SYSTEM tablespace, 4-4

Oracle Media Management API

proxy copy requirement, 8-44

proxy copy and downgrading, 12-37

Oracle Parallel Server

compatibility requirements, 8-34

downgrading, 12-49

instance affinity for jobs

compatibility, 8-12

migration, 3-7

not supported by Oracle Data Migration Assistant, 2-9, 4-3

rolling upgrade, 1-5

upgrading, 7-1, 7-24

not supported by Oracle Data Migration Assistant, 7-6

Oracle7

downgrading to, 13-1

prepare for migration, 3-9, 4-7

upgrading applications to Oracle8i, 9-1

Oracle8i

changes to initialization parameters, B-1

new features

adding after migration, 6-7

new internal types, E-1

new SQL functions, E-1

ORLON calls

obsolete, 8-18

OUTLN user

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

change password, 6-4, 7-35

PARALLEL clause

DEGREE keyword, 8-35

INSTANCES keyword removed, 8-35

parallel execution

allocated from large pool, B-9

avoiding problems with, 6-3, 7-34

Parallel Server. See Oracle Parallel Server

parameters for Migration utility. See command-line options

partially dropped columns

partitioning

password file

migration

exclusive setting, A-18

password management

application changes required for Oracle8i, 8-37

interoperability, 8-38

password expiration, 8-38

PFILE

plan stability

backward compatibility, 8-19

downgrading, 12-36

PL/SQL

compatibility, 8-14, 8-20

functions

desupported in Oracle8i, 8-30

interoperability, 8-20

modules

recompiling, 7-32

PLSQL_V2_COMPATIBILITY initialization parameter, 8-20

removing incompatibilities for downgrading, 12-25

variables

PREBUILT TABLE clause

PL/SQL backward compatibility, 8-19

precompilers

compatibility, 8-18

interoperability, 8-18

SQLLIB calls

relinking, 9-5

upgrading applications to Oracle8i, 9-2

Pro*Ada

upgrading to SQL*Module for Ada, 8-19

Pro*C/C++

connecting with SYSDBA privileges, 8-18

interoperability with Oracle7, 9-5

Pro*COBOL

connecting with SYSDBA privileges, 8-19

Procedural Option

required for migration, 3-9, 4-7

propagation

removing, 12-32

PROPS$ view

NCHAR character set, 3-14

proxy copy

requirement, 8-44

queue tables

downgrading, 12-31

upgrading, 7-29

R0703040.SQL script

replication, 3-28, 4-17

read-only tablespaces

active transactions, 8-23

compatibility, 8-23

migration, 3-4

REAL keyword

behavior in Oracle7 and Oracle8i, 8-22

rebuilding indexes

physical ROWIDs, 11-8

recovery

compatibility, 8-13, 8-39

recovery catalog

PL/SQL packages requirement, 8-39

upgrading, 7-30

Recovery Manager

backup management, 8-40

compatibility, 8-39

downgrading to 8.0.3

re-installing packages, 12-52

redo log files

re-archiving, 8-43

REFRESH ON COMMIT mode

materialized views and downgrading, 12-9

relinking with SQL*Net, 9-2

remote connections

multithreaded shared servers, 2-16

REMOTE_LOGIN_PASSWORDFILE initialization parameter

migration, A-18

removing incompatibilities for downgrading, 12-23

replication

compatibility, 8-44

requirements

export, 5-2

resource manager. See database resource manager

reverse migration

not supported, 13-2

rollback segments

migration, 3-4

ROWIDs

compatibility, client access, 11-7

conversion to Oracle8i format, 11-3

examples, 11-5

DBMS_ROWID compatibility package, 11-3

indexes, 11-8

migration

questions and answers, 11-7

snapshot refresh, 11-6

SAVEPOINT keyword

behavior in Oracle7 and Oracle8i, 8-22

schema objects

scripts

downgrading, 12-45

migrating from Server Manager to SQL*Plus, 10-1

rerunning, 3-27, 4-17, 7-19, 12-46

upgrading, 7-18

secondary indexes

dropping from index-organized tables, 12-8

security policies

downgrading, 12-37

fine-grained access control, 12-37

Server Manager

differences with SQL*Plus

COMMIT command, 10-14

CREATE LIBRARY command, 10-13

CREATE TYPE command, 10-13

hyphen continuation character, 10-10

startup, 10-2

syntax, 10-7

migrating to SQL*Plus, 10-1

service naming

Net8, 8-47

SET COMPATIBILITY command

SQL*Plus scripts, 9-6

SET_SESSION_LONGOPS procedure

syntax change, 8-33

shadow processes

open cursors and, 2-17

shared structures

interoperability, 8-17

SHARED_POOL_SIZE initialization parameter

changes in release 8.1, 6-3, 7-34

single-table hash clusters

snapshots. See Also materialized views

dropping, 12-9

snapshot refresh

physical ROWIDs, 11-6

snapshots

upgrading, 7-25

source database

migration, 2-15, 3-6, 4-4

space requirements

copying data, 2-15

Spatial

compatibility, 8-15

SPOOL

SQL

removing incompatibilities for downgrading, 12-25

SQL functions

new in Oracle8i, E-3

SQL scripts

migrating from Server Manager to SQL*Plus, 10-1

SQL*Module

for Ada, 8-19

SQL*Net

migrating to Net8, 6-4, 8-46

relinking, 9-2

SQL*Net V1

cannot use with Oracle8i, 9-2

upgrading from V1 to V2, 8-46

use with Oracle8i, 9-2

SQL*Plus

differences with Server Manager

COMMIT command, 10-14

CREATE LIBRARY command, 10-13

CREATE TYPE command, 10-13

hyphen continuation character, 10-10

startup, 10-2

syntax, 10-7

migrating from Server Manager to, 10-1

SQL*Plus scripts

upgrading, 9-6

SQLLIB calls

relinking, 9-5

work against Oracle8i, 9-5

standby database

compatibility, 8-41

migrating to Oracle8i, 8-41

static data dictionary views

added in Oracle8i, C-2

changed in Oracle8i

added columns, C-7

columns that may return NULLs, C-14

dropped columns, C-11

renamed columns, C-13

obsolete in Oracle8i, 8-24, C-15

stored outlines

downgrading, 12-36

summary management

user-created objects in, 8-24

SYS schema

SYSDBA

connecting in Pro*C/C++, 8-18

connecting in Pro*COBOL, 8-19

system requirements

for migration, 2-15

SYSTEM tablespace

Migration utility, 2-6, 3-6

Oracle Data Migration Assistant, 4-4

space

insufficient for migration, A-2

tablespaces

migrating offline tablespaces, 3-10, 4-8

target database

data dictionary information, 8-23

tempfiles

temporary tables

dropping for downgrading, 12-6

temporary tablespace

space

insufficient for migration, A-2

terminology

migration, 1-2

testing

applications for migration, 2-23

developing a plan for migration, 2-19

EXPLAIN PLAN, 2-22

functional for migration, 2-20

integration for migration, 2-20

INTO clause, 2-22

migration results, 6-6

minimal for migration, 2-19

performance for migration, 2-20

pre- and post-migration, 2-21

the migrated test database, 2-23

the migration process, 2-22

volume/load stress for migration, 2-21

thread safety

compatibility, 8-18

TP monitors, 2-17

transportable tablespaces

removing transported tablespaces, 12-5

triggers

dropped automatically when downgrading, 12-35

on nested table view columns

downgrading, 12-34

troubleshooting

migration, A-1

ALTER DATABASE CONVERT command, 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

SYSTEM tablespace, A-2

temporary tablespace tablespace, A-2

TRUE keyword

behavior in Oracle7 and Oracle8i, 8-22

Trusted Oracle

Export/Import, 5-3

tuning

after migration, 6-6

Tuxedo applications

compatibility with Oracle8i XA libraries, 8-17

TWO_TASK environment variable, 3-16

type DTYCHR, 11-8

types

mutually referencing

downgrading, 12-24

U0703040.SQL script, 3-27

Universal ROWIDs. See UROWIDs

unused columns

dropping, 12-8

upgrading

Advanced Queuing, 7-26

Advanced Replication, 7-21

applications, 9-1

initialization parameters, 7-15

drop Java objects, 7-36

export Java objects, 7-3

import Java objects, 7-36

manually, 7-13

Oracle Forms applications, 9-6

Oracle Parallel Server, 7-1, 7-24

rolling upgrade, 1-5

OUTLN user, avoid, 7-4

parallel execution, 7-34

paths, 7-2

post-upgrading actions, 7-33

precompiler applications, 9-4

queue tables, 7-29

recovery catalog, 7-30

user-defined datatypes, 7-30

rerunning, 7-19

UTLCONST.SQL script, 7-33

UTLRP.SQL, 7-32

snapshots, 7-25

specific components, 7-21

SQL*Plus scripts, 9-6

steps, 7-3

supported releases, 7-2

using the Oracle Data Migration Assistant, 7-7

UROWIDs

compatibility, 8-11

downgrading, 12-17

interoperability, 8-26

user-created objects

in SYS schema, 8-24

user-defined datatypes

downgrading, 12-21

interoperability, 8-29

new format, 8-29

upgrading, 7-30

user-defined object identifiers

compatibility, 8-12

downgrading, 12-22

UTL_REF package

downgrading, 12-33

re-installing after downgrading, 12-51

UTLCHAIN1.SQL script, 8-31

UTLCONST.SQL script, 6-2, 7-33

UTLDST.SQL, 8-6, 12-4

UTLEXCPT1.SQL script, 8-31

utljavarm.sql script, 7-36

UTLRP.SQL script, 3-28, 4-18, 7-32

VALUE$ view

removing incompatibilities, 12-24

VARRAYs

compatibility, 8-12

varying-width character set

LOBs

downgrading, 12-19

version 6

Export/Import for migration, 5-2

views

mutually referencing

downgrading, 12-10

example of, 12-11

Visual Image Retrieval

compatibility, 8-15

word-size

changing, 1-4, 7-37

XA libraries