Oracle9i Database Migration -- Index

2 GB and larger files

operating system dependencies, 9-53

32-bit to 64-bit conversion. See word-size

active transactions

read-only tablespaces, 9-29

Ada. See SQL*Module for Ada

Advanced Queuing

compatibility, 9-17, 9-37

message streaming, 9-38

privileges, 9-37

rule based subscriptions, 9-38

interoperability, 9-37

sender's ID column, 9-37

removing incompatibilities

downgrading, 14-20

upgrading, 7-37

agent self-registration

compatibility, 9-16

AL24UTFFSS character set

desupported in Oracle9i, 4-8, 5-8, 7-3

ALTER DATABASE CONVERT statement, 4-3, 4-32

rerunning, A-9

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

ALTER DATABASE RESET COMPATIBILITY statement, 9-8, 9-9

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

ALTER TABLE statement

bitmap index invalidation, 9-30

ANALYZE TABLE VALIDATE STRUCTURE statement

change in release 8.1, 9-22

applications

application context

compatibility, 9-16

client/server configurations

upgrading, 10-3

compatibility, 9-20, 10-2

development

role during migration, 2-7

external initialized context

compatibility, 9-11

index-organized tables

compatibility, 9-21

interoperability, 9-20

linking with newer libraries, 10-6

OCI

compatibility, 9-22

interoperability, 9-22

physical ROWIDs and UROWIDs, 9-21

physical ROWIDs in version 8, 12-2

PL/SQL

compatibility, 9-24

interoperability, 9-24

precompiler

compatibility, 9-23

interoperability, 9-23

running against older server, 10-5

upgrading, 10-1

compatibility rules, 10-4

options, 10-7

relinking rules, 10-4

AQ. See Advanced Queuing

AQ_TM_PROCESSES initialization parameter, 7-20

archive log destination parameters

new in release 8.1, B-15

archived redo logs

analyzing

from other databases, 9-47

compatibility, 9-46

rearchiving, 9-46

archiving

error detection behavior, 9-46

AUDIT_TRAIL initialization parameter

migration, A-4

Automatic segment-space managed tablespaces

compatibility, 9-9

automatic undo managed tablespaces

compatibility, 9-9

AUTOMATIC_IPC networking parameter, F-4

autonomous transactions

compatibility, 9-17

backups

after migration or upgrade, 8-2

before migration, 4-26

compatibility, 9-16, 9-43

EBU, 9-44

preparing a strategy for migration, 3-22

Recovery Manager and EBU, 9-44

backward compatibility

of ROWIDs, 12-8

bitmap indexes

invalidations, 9-30

during migration, 8-15

bitmap secondary indexes

dropping from index-organized tables, 14-4

blocks

block size

DB_BLOCK_SIZE initialization parameter, 4-6, 5-6

minimums for migration, 4-6, 5-6

bulk binds

compatibility, 9-17

C language

C call specifications

compatibility, 9-17

cache reads

for LOBS

discontinue using, 14-16

CALL statement

compatibility, 9-17

CartridgeServices

installing, 8-5

CATALOG5.SQL script

obsolete, 9-30

CATALOG6.SQL script

obsolete, 9-30

CATALOG.SQL script, 4-4, 4-33, 7-23, 13-12

CATCLUST.SQL script, 4-33, 7-35

CATEXP7.SQL script, 9-52

downgrading to Oracle7, 15-5

CATPARR.SQL script, 13-12

CATPROC.SQL script, 4-4, 4-33, 7-23, 13-12

CATREP.SQL script, 13-12

change passwords

of oracle-supplied accounts, 8-2

CHAR

maximum size

change, 9-20

CHARACTER keyword

behavior differences, 9-27

character sets

migrating the database, 4-8, 5-8

upgrading the database, 7-2

varying-width

CLOBs and NCLOBs, 9-31

CHECK_ONLY

Migration utility option, 4-18, 4-21

ckpdom.ora file, F-23

ckpreg.ora file, F-23

ckptop.ora file, F-23

client-server configurations, 1-4

CLOBs

compatibility, 9-31

clusters

cluster tables

copying data, 3-16

collection locators

compatibility, 9-15

collections

collection columns

user-specified storage, 9-35

collection locators

compatibility, 9-35

command line

command-line options

Migration utility, 4-17

commands

COMMIT FORCE, 4-9, 5-8

ROLLBACK FORCE, 4-9, 5-8

comments

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

COMMIT command

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

COMMIT FORCE command, 4-9, 5-8

COMMIT keyword

behavior differences, 9-27

COMMUNITY parameter, F-4

compatibility, 9-1

8.1.0 compatibility level

features requiring, 9-12

9.0.0 compatibility level

features requiring, 9-9

Advanced Queuing, 9-17, 9-37

agent self-registration, 9-16

ALTER DATABASE RESET COMPATIBILITY statement, 9-8

ANALYZE VALIDATE STRUCTURE statement, 9-22

application context, 9-16

applications, 9-20, 10-2

index-organized tables, 9-21

physical ROWIDs and UROWIDs, 9-21

archived redo logs, 9-46

backup, 9-16, 9-43

change in maximum size

CHAR, 9-20

RAW, 9-20

VARCHAR2, 9-20

checking level for features, 9-9

compatibility level, 9-6

COMPATIBLE initialization parameter, 9-2

CREATE TABLE behavior change, 9-37

data dictionary, 9-29

database resource manager, 9-17

datafiles, 9-28

datatypes, 9-31

date columns in dynamic performance views, 9-32

DBMS_REPAIR package, 9-17

DISABLE VALIDATE constraints, 9-17

downgrading, 9-6

Export/Import, 9-51

extensible optimizer, 9-17

external initialized context, 9-11

fine-grained access control, 9-16

Heterogeneous Services agents, 9-49

indexes

key compression, 9-14

initialization parameters, B-9

LOB index clause, 9-31

LOBs, 9-10, 9-15, 9-31

CLOBS and NCLOBs, 9-31

LogMiner, 9-47

materialized views, 9-12, 9-18, 9-48

nested tables, 9-35

NLS and NCHAR environment variables, 9-33

n-tier authentication and authorization, 9-16

OCI, 9-22

link line, 9-22

thread safety, 9-22

optimization, 9-39

optimizer plan stability, 9-17

Oracle Media Management API, 9-16

Oracle Parallel Server

instance affinity for jobs, 9-15

packages

DBMS_LOB, 9-38

DBMS_REPAIR, 9-38

partitioning, 9-10, 9-14

PL/SQL, 9-24

integrated SQL analysis, 9-25

PLSQL_V2_COMPATIBILITY initialization parameter, 9-25

precompilers, 9-23

read-only tablespaces, 9-29

recovery, 9-16, 9-43

fast-start rollback, 9-16

REFs, 9-15

removing incompatibilities, 13-2, 14-1

replication, 9-11, 9-16, 9-48

resetting for database, 13-3

ROWID issues, 12-8

rowids, 9-32

schema objects, 9-10, 9-14, 9-30

collection locators, 9-15

drop column, 9-14

extensible indexing, 9-14

external tables, 9-10

function-based indexes, 9-14

index segment coalesce, 9-14

indexes, 9-10, 9-14

index-organized tables, 9-10, 9-14

length semantics, 9-10

nested tables, 9-15

online index (re)build, 9-14

single-table hash clusters, 9-10, 9-14

temporary tables, 9-14

type evolution, 9-11

scripts

UTLCHN1.SQL, 9-17, 9-36

UTLEXPT1.SQL, 9-17, 9-36

Spatial, 9-18

SQL and PL/SQL, 9-12, 9-17

autonomous transactions, 9-17

bulk binds, 9-17

C call specifications, 9-17

CALL statement, 9-17

native dynamic SQL, 9-17

nested transactions, 9-12

NOCOPY parameter passing mode, 9-17

parallel table functions, 9-12

pipelined table functions, 9-12

standby database, 9-45

STARTUP, 9-27

summary management, 9-12, 9-18

tablespaces, 9-9, 9-13, 9-28

automatic segment-space managed, 9-9

automatic undo managed, 9-9

default temporary tablespaces, 9-9

locally managed tablespaces, 9-13

online read-only tablespaces, 9-13

transportable tablespaces, 9-13

triggers, 9-17

type inheritance, 9-11

UROWIDs, 9-15

user-defined aggregate functions, 9-11

user-defined datatypes, 9-34

user-defined object identifiers, 9-15

varrays, 9-11, 9-15

stored as LOBs, 9-35

view constraints, 9-12

Visual Image Retrieval, 9-18

compatibility level

checking, 13-2

resetting, 9-9

COMPATIBLE initialization parameter, 9-2

8.1.0 setting

features requiring, 9-12

9.0.0 setting

features requiring, 9-9

checking the setting, 9-6

database structures, 9-4

setting, 9-7

when to set, 9-7

concurrent access, 3-18

concurrent users, 3-19

CONNECT_TIMEOUT_listener_name networking parameter, F-4

connections

load balancing in Net8, 9-50

local and remote, 3-18

with multithreaded shared server, 3-18

connect-time failover

GLOBAL_DBNAME networking parameter in listener.ora, F-14

ConText

migrating to Oracle Text, 4-8, 5-7

control files

renaming or removing for migration, 4-25, 7-18, 13-9

copying data

large cluster tables, 3-16

migration method, 3-15

space requirements, 3-16

CREATE LIBRARY command

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

CREATE TABLE

AS subquery

behavior change, 9-37

CREATE TYPE command

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

cursors

number of open, 3-19

data definition conversion

Import utility, 3-14

data dictionary

compatibility, 9-29

protection, 9-30

database

failure to open after removing incompatibilities, 9-9

database administrator

role during migration, 2-7

database resource manager

compatibility, 9-17

databases

backing up for migration, 4-26

downgrading, 13-4

test migration results, 8-16

tuning after migration, 8-17

datafiles

compatibility, 9-28

offline during migration, 4-4

datatypes

compatibility, 9-31

internal

added in Oracle9i, E-2

added in version 8, E-3

date constraints

checking for bad, 8-9

DB_BLOCK_CHECKSUM

new default value, B-9

DB_BLOCK_CHECKSUM initialization parameter

compatibility, B-9

DB_BLOCK_SIZE initialization parameter

migration, 4-6, 5-6

DB_DOMAIN initialization parameter, F-14

compatibility, B-11

DB_NAME initialization parameter, F-14

DBMS

precompiler command line option, 9-24

DBMS_APPLICATION_INFO package

SET_SESSION_LONGOPS procedure

syntax change, 9-38

DBMS_LOB package

NOCOPY syntax and compatibility, 9-38

DBMS_REPAIR package

compatibility, 9-17, 9-38

DBMS_ROWID package, 12-3

DBMS_STATS package

upgrading statistics tables, 7-39

DBMSLOB.SQL script

compatibility, 9-38

DBNAME

Migration utility option, 4-18

DBSNMP_START command, F-6

DBSNMP_STATUS command, F-6

DBSNMP_STOP command, F-6

DEC keyword

behavior differences, 9-27

default temporary tablespaces

compatibility, 9-9

definitions. See terminology

DEGREE keyword

in PARALLEL clause, 9-39

deinstalling, 1-13

Developer/2000 Applications

upgrading, 10-12

DISABLE VALIDATE constraints

compatibility, 9-17

distributed databases

preparing to migrate, 4-9, 5-8

DML_LOCKS initialization parameter

compatibility, B-11

documentation

roadmap for Migration utility, 4-2

roadmap for Oracle Data Migration Assistant, 5-2

DOMAIN_HINT command, F-6

downgrading

Advanced Queuing, 14-20

CATALOG.SQL, 13-12

CATPROC.SQL, 13-12

Java, 13-12, 13-13

locally managed tablespaces, 14-16

Oracle9i Real Application Clusters, 13-12

ORADIM, 13-8

procedure for, 13-4

removing incompatibilities, 13-2

automatic segment-space managed tablespaces, 14-3

automatic undo managed tablespaces, 14-4

bitmap secondary indexes on index-organized tables, 14-4

cache reads for LOBs, 14-16

external tables, 14-4

global users, 14-19

indexes with large keys, 14-5

LOBs in partitioned index-organized tables, 14-11

migrated tablespaces, 14-15

non-final types, 14-13

parallel table functions, 14-14

partitioning, 14-6

pipelined table functions, 14-13

SQL and PL/SQL, 14-13

subtypes, 14-13

transient segments, 14-15

triggers, 14-18

type evolution, 14-12

user-defined aggregate functions, 14-12

varrays in partitioned index-organized tables, 14-13

view constraints, 14-14

replication, 13-12

regenerating, 13-14

resetting database compatibility, 13-3

scripts, 13-5

errors while running, 1-11

JISD817.SQL, 13-13

JSPD817.SQL, 13-13

JVMD815.SQL, 13-12

JVMD816.SQL, 13-13

JVMD817.SQL, 13-13

rerunning, 13-6

XMLD817.SQL, 13-13

to Oracle7, 15-1

alternative methods, 15-6

CATEXP7.SQL script, 15-5

to release 8.0, 15-1

alternative methods, 15-3

to release 8.1, 13-1

to release 8.1.5, 14-14

to release 8.1.6, 14-3

to release 8.1.7, 14-3

triggers, 14-18

view constraints, 14-14

XML, 13-13

drop column

compatibility, 9-14

DTYCHR type, 12-10

DUMP_TNSNAMES command, F-18

Dynamic Discovery Option for Oracle Names

migration issues, F-18

dynamic performance views

added in Oracle9i, D-2

added in version 8, D-8

changed in Oracle9i

dropped columns, D-5

changed in version 8

added columns, D-13

dropped columns, D-14

renamed columns, D-15

changes in Oracle9i, D-1

date columns

compatibility, 9-32

obsolete in Oracle9i, D-7

obsolete in version 8, D-16

renamed in Oracle9i, D-3

EBU

backup management, 9-44

enterprise user management

interoperability, 9-43

environment variables

compatibility

NCHAR and NLS, 9-33

ORA_NLS32, 9-33

ORA_NLS33, 4-19, 9-33

required for migration, 4-20, 4-23

required for upgrading, 7-21

errors

during migration or upgrade. See troubleshooting

Export utility

migration, 3-10, 6-1

Oracle9i using CATEXP7.SQL, 15-5

requirements for migration, 6-2

Export/Import

advantages and disadvantages, 3-10

basic steps for migration, 6-2

benefits for migration, 3-13

compatibility, 9-51

data definition conversion, 3-14

effects on migrated databases, 3-12

incompatible data, 9-52

limitations for migration, 3-13

migration steps using, 6-3

scripts

CATEXP7.SQL, 9-52

time requirements for migration, 3-14

Trusted Oracle, 6-3

extended ROWIDs, 12-8

extensible indexing

compatibility, 9-14

external tables

compatibility, 9-10

dropping for downgrading, 14-4

FAILOVER networking parameter, F-10

failure to open database after removing incompatibilities, 9-9

FALSE keyword

behavior differences, 9-27

fast-start parallel recovery

compatibility, 9-45

fast-start rollback

compatibility, 9-16, 9-45

feature compatibility, 9-9

features

new features, 9-9

requiring migration, G-20

filenames

normalize, 8-13

fine-grained access control

compatibility, 9-16

Forms

upgrading Oracle Forms applications, 10-12

function-based indexes

compatibility, 9-14

invalidations

during upgrade, 8-17

functions

SQL

added in Oracle9i, E-2

added in version 8, E-4

generating

replication support and migration, G-5, G-14

global database name, F-14

global users

downgrading, 14-19

GLOBAL_DBNAME networking parameter, F-14

glossary. See terminology

GREATEST_LB function

desupported, 9-35

Heterogeneous Services

agents

compatibility, 9-49

interoperability, 9-49

multithreaded, 9-49

identifying incompatibilities

UTLINCMP.SQL, 14-2

Identix authentication, F-2

Import utility

data definition conversion, 3-14

migration, 3-10, 6-1

requirements for migration, 6-2

incompatibilities

removing, 13-2, 14-1

incremental migration, G-7

index segment coalesce

compatibility, 9-14

indexes

bitmap, 8-15

compatibility, 9-10, 9-14

function-based, 8-17

key compression, 9-14

on physical ROWID, 12-10

rebuilding

physical ROWIDs, 12-10

index-organized tables

compatibility, 9-10, 9-14

removing hash partitions from, 14-6

initialization parameters

added in Oracle9i, B-2

added in version 8, B-4

adjusting for Oracle9i, 4-29, 5-12, 7-19, 8-12

AQ_TM_PROCESSES, 7-20

archive log destination

switching to new, B-15

changes in Oracle9i, B-1

compatibility, B-9

DB_BLOCK_CHECKSUM, B-9

DB_DOMAIN, B-11

DML_LOCKS, B-11

LOG_CHECKPOINT_TIMEOUT, B-11

O7_DICTIONARY_ACCESSIBILITY, B-11

ORACLE_TRACE_ENABLE, B-9

SERIALIZABLE, B-10

SORT_AREA_SIZE, B-10

SORT_DIRECT_WRITES, B-10

COMPATIBLE, 9-2

JOB_QUEUE_PROCESSES, 4-30, 5-13, 7-20

LARGE_POOL_SIZE

parallel execution allocation, B-12

obsolete in Oracle9i, B-3

obsolete in version 8, B-6

REMOTE_LOGIN_PASSWORDFILE, 7-20

renamed in Oracle9i, B-3

renamed in version 8, B-6

SHARED_POOL_SIZE

parallel execution allocation, B-12

INIT.ORA parameters. See initialization parameters

installation

Oracle9i software, 4-15, 5-15, 6-3

INSTANCE_NAME initialization parameter, F-11

INSTANCES keyword

removed from PARALLEL clause, 9-39

INT keyword

behavior differences, 9-27

interMedia

upgrading, 7-31

internal datatypes

added in Oracle9i, E-2

added in version 8, E-3

interoperability, 9-1, 9-18

Advanced Queuing, 9-37

applications, 9-20

Heterogeneous Services agents, 9-49

native dynamic SQL, 9-36

OCI, 9-22

Oracle7 clients, 9-22

shared structures, 9-22

PL/SQL, 9-24

precompilers, 9-23

type evolution, 9-34

UROWIDs, 9-33

user-defined datatypes, 9-35

Java

compatibility, 9-13

downgrading, 13-12, 13-13

installing CartridgeServices, 8-5

installing ODCI, 8-5

installing Oracle Change Data Capture, 8-5

installing SQLJ, 8-5

installing Summary Advisor, 8-5

upgrading, 7-25, 7-26, 7-29, 7-31

JISD817.SQL script, 13-13

JISU815.SQL script, 7-29

JISU816.SQL script, 7-29

JISU817.SQL script, 7-29

JOB_QUEUE_PROCESSES initialization parameter, 4-30, 5-13, 7-20

JServer

upgrading, 7-25

JSPD817.SQL script, 13-13

JSPU815.SQL script, 7-31

JSPU816.SQL script, 7-31

JSPU817.SQL script, 7-31

JVMD815.SQL script, 13-12

JVMD816.SQL script, 13-13

JVMD817.SQL script, 13-13

JVMU815.SQL script, 7-26

JVMU816.SQL script, 7-26

JVMU817.SQL script, 7-26

keywords

behavior differences, 9-27

large files

operating system dependencies, 9-53

large key indexes

removing, 14-5

Large Objects. See LOBs

LARGE_POOL_SIZE initialization parameter

changes in behavior, 8-10

parallel execution allocation, B-12

LEAST_UB function

desupported, 9-35

length semantics

compatibility, 9-10

Listener Control utility

SET CONNECT_TIMEOUT, F-6

SHOW CONNECT_TIMEOUT, F-6

unsupported commands

DBSNMP_START, F-6

DBSNMP_STATUS, F-6

DBSNMP_STOP, F-6

SET USE_PLUGANDPLAY, F-6

SHOW USE_PLUGANDPLAY, F-6

listener.ora file

migrating, F-14

modifying after migration, 8-10

modifying after upgrading, 8-10

parameters

GLOBAL_DBNAME, F-14

ORACLE_HOME, F-14

SID_NAME, F-14

unsupported parameters

CONNECT_TIMEOUT_listener_name, F-4

PRESPAWN_DESC, F-5

PRESPAWN_LIST, F-5

PRESPAWN_MAX, F-5

USE_PLUG_AND_PLAY_listener_name, F-5

upgrading, F-14

listeners

configuring for Oracle Enterprise Manager, F-14

global database name, F-14

Oracle System Identifier, F-14

SID, F-14

load balancing

Net8, 9-50

LOAD_BALANCE networking parameter, F-10

LOAD_TNSNAMES command, F-19, F-22

LOB datatype

copying from LONG, 8-7

LOB index clause

compatibility, 9-31

LOBs

compatibility, 9-10, 9-15, 9-31

removing from partitioned index-organized tables, 14-11

local connections

multithreaded shared servers, 3-18

locally managed tablespaces

compatibility, 9-13

locks

DML lock limit, DML_LOCKS, B-11

LOG_CHECKPOINT_TIMEOUT

new default value, B-11

LOG_CHECKPOINT_TIMEOUT initialization parameter

compatibility, B-11

LogMiner

compatibility, 9-47

LONG datatype

copying to LOB, 8-7

master sites

incremental migration of, G-12

migration, G-4

materialized views

compatibility, 9-12, 9-18, 9-48

upgrading, 7-36

memory requirements

concurrent access, 3-18

migration, 3-16, 4-5, 5-5

migprep utility

running, 4-18

MIGRATE user

avoid, 4-12, 5-11

MIGRATE.BSQ script, 4-26

migrated tablespaces

correcting transient segments, 14-15

removing migrated tablespaces, 14-15

migration

abandoning, 4-35, 5-24

after migrating, 8-1, 8-15

ALTER DATABASE CONVERT statement, 4-3, 4-32

rerunning, A-9

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

AUDIT_TRAIL initialization parameter, A-4

avoiding common problems, 3-20

backup strategy, 3-22

block size minimums, 4-6, 5-6

character set, 4-8, 5-8

choosing a method, 3-3

control files, 4-25, 7-18, 13-9

copying data, 3-15

definition, 1-3

distributed database considerations, 4-9, 5-8

dynamic performance views, D-1

exclusive password file, A-8

Export/Import, 3-10

steps, 6-2

features requiring, G-20

incremental, G-7

initialization parameters, 4-29, 5-12, B-1

listener.ora file, 8-10

master sites, G-4

memory requirements, 3-16, 4-5, 5-5

methods

choosing, 3-3

migprep utility, 4-18

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

MIGRATE.BSQ script, 4-26

Migration utility, 3-6

NCHAR and NLS, 9-33

new administrative procedures, 8-12

obsolete replication procedures, G-22

offline datafiles, 4-4

offline tablespaces, 4-11, 5-10

OPTIMAL setting for SYSTEM rollback segment, A-5

Oracle Data Migration Assistant, 3-8

Oracle9i Real Application Clusters, 4-7

rolling upgrade, 1-13

ORADIM, 4-24, 7-18

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

overview for replication, G-2

overview of steps, 2-2

parallel execution, 8-10

post migration, 8-1, 8-15

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

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

Windows platforms, 4-13, 5-13

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

rowids, 12-1

FAQ, 12-9

scripts

CATALOG.SQL, 4-4, 4-33

CATCLUST.SQL, 4-33

CATPROC.SQL, 4-4, 4-33

errors while running, 1-11

rerunning, 4-33, 5-22

U0703040.SQL, 4-33

UTLRP.SQL, 4-33, 5-22

snapshot sites, G-9

space requirements, 3-16, 4-5, 5-5

SQL*Net requirement

Windows platforms, 4-13, 5-13

standby database, 8-10

static data dictionary views, C-1

system requirements, 3-16

SYSTEM tablespace, A-4

temporary tablespace, A-4

terminology, 1-2

testing, 3-22

testing results, 8-16

troubleshooting, A-1

ALTER DATABASE CONVERT statement, A-6

AUDIT_TRAIL initialization parameter, A-4

database name mismatch, A-9

datafile version integrity, A-10

Migration utility error messages, A-11

missing convert file, A-7

MULTIPLIER option, A-6

NOMOUNT database start mode, A-7

OPTIMAL setting, A-5

Oracle7 control file, A-7

password file, A-8

running the Migration utility, A-3

running the Oracle Data Migration Assistant, A-3

scripts run long, A-11

SYSTEM tablespace, A-4

temporary tablespace, A-4

tuning after, 8-17

upgrading to primary key snapshots, G-17

Migration Assistant. See Oracle Data Migration Assistant

Migration utility

advantages and disadvantages, 3-6

command-line options, 4-17

differences from the Oracle Data Migration Assistant, 3-9

documentation roadmap, 4-2

errors and messages, A-11

migrating to a different operating system, 4-8

MULTIPLIER option, A-6

options

CHECK_ONLY, 4-18, 4-21

DBNAME, 4-18

MULTIPLIER, 4-18

NEW_DBNAME, 4-18

NO_SPACE_CHECK, 4-18

PFILE, 4-18

SPOOL, 4-18

overview, 4-3

privileges required, 4-20

running, 4-22

on UNIX, 4-22

on Windows platforms, 4-24

space required for SYSTEM tablespace, 4-5

SYSTEM tablespace, 3-6

using, 4-20

MTS. See multi-threaded server

MULTIPLIER

Migration utility option, 4-18, A-6

multi-threaded server

shared, 3-18

shared and local/remote connections, 3-18

multiversioning, 1-4

NAMES_DID table, F-16

NAMES_DOM table for Oracle Names, F-16

NAMES.ADMIN_REGION networking parameter, F-17, F-18

NAMES.DEFAULT_DOMAIN networking parameter, F-4

NAMES.DEFAULT_ZONE networking parameter, F-4

NAMES.DOMAIN_HINTS networking parameter, F-6

NAMES.DOMAINS networking parameter, F-16

namesini.sql script for Oracle Names, F-24

NAMES.NDS.NAME.CONTEXT networking parameter, F-4

names.ora file

unsupported parameters

NAMES.DOMAIN_HINTS, F-6

NAMES.USE_PLUG_AND_PLAY, F-5

NAMES.PREFERRED_SERVERS networking parameter, F-4

namesupg.sql script for Oracle Names, F-16, F-18, F-21, F-24

NAMES.USE_PLUG_AND_PLAY networking parameter, F-5

national character set

in Oracle8i, 9-33

native dynamic SQL

compatibility, 9-17

interoperability, 9-36

NCHAR

migration, 9-33

use in Oracle8i, 9-33

NCHAR and NLS environment variables

compatibility, 9-33

NCHAR columns

upgrading, 8-3

NCLOBs

compatibility, 9-31

nested tables

compatibility, 9-15, 9-35

nested transactions

compatibility, 9-12

Net8

coexistence issues, F-7 to F-9

Oracle9i databases, F-7

using SERVICE_NAME networking parameter, F-7

using SID networking parameter, F-8

connection load balancing, 9-50

service naming, 9-50

SID networking parameter, F-8

upgrading to Oracle Names release 1 (9.0.1), F-15

upgrading to Oracle Net Services, F-11 to F-14

configuration files, F-12

listener.ora file, F-14

software on client, F-12

software on server, F-12

tnsnames.ora file, F-13

Net8 OPEN, F-2

new features

adding after migration or upgrade, 8-12

requiring 9.0.0 compatibility, 9-9

NEW_DBNAME

Migration utility option, 4-18

NLS

migration, 9-33

NLS and NCHAR environment variables

compatibility, 9-33

NLS_LANG environment variable

compatibility, 9-33

nmcbild.sql script, F-20

nmcrgrnt.sql script, F-20

NMO_INFORMATION table for Oracle Names, F-17

NO_SPACE_CHECK

Migration utility option, 4-18

NOCOPY parameter passing mode

compatibility, 9-17

Novell Directory Services (NDS)

authentication, F-2

external naming, F-2

n-tier authentication and authorization

compatibility, 9-16

NUMERIC keyword

behavior differences, 9-27

O7_DICTIONARY_ACCESSIBILITY initialization parameter

compatibility, 9-30

O7_DICTIONARY_ACCESSIBILITY parameter

compatibility, B-11

obsolete replication procedures, G-22

OCI

applications

changing to use Oracle9i, 10-10

compatibility, 9-22

batch error mode, 9-23

client notification, 9-13, 9-23

link line, 9-22

LISTEN call and AQ, 9-23

thread safety, 9-22

interoperability, 9-22

Oracle7 clients, 9-22

shared structures, 9-22

OCIChangePassword call, 9-42

OCISessionBegin call, 9-42

upgrading applications to Oracle9i, 10-3

OCI applications

upgrading options, 10-7

ODCI

installing, 8-5

OFA, 1-11

offline datafiles

migration, 4-4

OLON calls

obsolete, 9-22

OLQP, 3-19

OLSU817.SQL script, 7-34

OLTP, 3-19

online index (re)build

compatibility, 9-14

online read-only tablespaces

compatibility, 9-13

operating system

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

OPS. See Oracle9i Real Application Clusters

Optimal Flexible Architecture. See OFA

OPTIMAL setting for SYSTEM rollback segment

migration, A-5

optimization

compatibility, 9-39

extensible optimizer, 9-17

optimizer plan stability, 9-17

optimizer

plan stability

compatibility, 9-17

options

deinstalling, 1-13

for Migration utility, 4-17

ORA_NLS32 environment variable

compatibility, 9-33

ORA_NLS33 environment variable, 4-19

compatibility, 9-33

Oracle Advanced Queuing. See Advanced Queuing

Oracle AQ. See Advanced Queuing

Oracle Call Interface. See OCI

Oracle Change Data Capture

installing Java classes, 8-5

Oracle Data Migration Assistant

advantages and disadvantages, 3-8

differences from the Migration utility, 3-9

documentation roadmap, 5-2

migrating to a different operating system, 5-7

Oracle9i Real Application Clusters

does not support migration, 3-10

does not support upgrading, 7-8

overview, 5-4

restrictions, 5-4

running, 5-20, 7-8, 7-15

space required for SYSTEM tablespace, 5-5

Oracle Enterprise Manager

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

Oracle home

multiple, 1-5

Oracle Label Security

upgrading, 7-34

Oracle Media Management API

compatibility, 9-16

proxy copy requirement, 9-47

Oracle Names

coexistence issues, F-9

migrating

ckreg.ora file to cktop.ora file, F-23

Oracle Names version 2 using a database, F-16

ROSFILES, F-20

ROSFILES to a tnsnames.ora file, F-21

ROSFILES to Oracle Names tables in database, F-20

migrating to release 1 (9.0.1), F-15

NAMES_DID table for Oracle Names, F-16

NAMES_DOM table, F-16

NAMES.ADMIN_REGION parameter in names.ora file, F-17, F-18

NAMES.DOMAINS parameter in names.ora file, F-16

namesini.sql script, F-24

namesupg.sql script, F-16, F-18, F-21, F-24

NMO_INFORMATION table, F-17

Oracle Names Control utility

commands

Oracle Names Control utility

commands

LOAD_TNSNAMES, F-19, F-22

REGISTER, F-5, F-6

REORDER_NS, F-23

unsupported commands

DOMAIN_HINT, F-6

Oracle Net

migrating or upgrading to, 8-16, 9-49

Oracle Net Services

coexistence issues, F-7 to F-9

Oracle release 8.0 clients, F-8

Oracle release 8.0 databases, F-9

third-party applications, F-8

using Oracle Net Manager, F-10

using SERVICE_NAME networking parameter, F-7

using SID networking parameter, F-7

FAILOVER networking parameter, F-10

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

LOAD_BALANCE networking parameter, F-10

Oracle Net Manager

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

Use Oracle8 Release 8.0 Compatible Identification option, F-10

SERVICE_NAME parameter, F-7

SOURCE_ROUTE parameter, F-10

unsupported features

Identix authentication, F-2

Net8 OPEN, F-2

Novell Directory Services (NDS) authentication, F-2

Novell Directory Services (NDS) external naming, F-2

prespawned dedicated servers, F-3

protocol.ora file, F-3

SecurID authentication, F-2

SPX, F-3

Oracle Parallel Server

instance affinity for jobs

compatibility, 9-15

Oracle Parallel Server. See Oracle9i Real Application Clusters

Oracle precompilers. See precompilers

Oracle Spatial

upgrading, 7-31

Oracle System Identifier, configuring on the listener, F-14

Oracle Text

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

upgrading, 7-31

ORACLE_HOME initialization parameter, F-14

ORACLE_TRACE_ENABLE initialization parameter

compatibility, B-9

Oracle7

downgrading to, 15-1

prepare for migration, 4-9, 5-9

Windows platforms, 4-13, 5-13

Oracle9i

changes to dynamic performance views, D-1

changes to initialization parameters, B-1

changes to static data dictionary views, C-1

new features

adding after migration or upgrade, 8-12

new internal datatypes, E-1

new SQL functions, E-1

Oracle9i Real Application Clusters

compatibility requirements, 9-39

downgrading, 13-12

migration, 4-7

not supported by the Oracle Data Migration Assistant, 3-10

rolling upgrade, 1-13

upgrading, 7-4, 7-35

not supported by the Oracle Data Migration Assistant, 7-8

oracle-supplied accounts

change passwords, 8-2

ORADIM

downgrading, 13-8

migration, 4-24, 7-18

upgrading, 7-18

ORLON calls

obsolete, 9-22

OSS.MY.WALLET networking parameter, F-4

OUTLN user

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

PARALLEL clause

DEGREE keyword, 9-39

INSTANCES keyword removed, 9-39

parallel execution

allocated from large pool, B-12

avoiding problems with, 8-10

parallel table functions

compatibility, 9-12

removing, 14-14

parameters

for Migration utility. See command-line options

partition views

migrate to partition tables, 8-16

partitioned index-organized tables

removing LOBs from, 14-11

removing varrays from, 14-13

partitioning

compatibility, 9-10, 9-14

downgrading, 14-6

password file

migration

exclusive setting, A-8

password management

application changes required for Oracle8i, 9-42

interoperability, 9-42

password expiration, 9-42

pending transactions

and migration, 4-9, 5-8

PFILE

Migration utility option, 4-18

pipelined table functions

compatibility, 9-12

removing, 14-13

plan stability

compatibility, 9-17

PL/SQL

backward compatibility, 9-24

compatibility, 9-12, 9-17, 9-24

functions

desupported, 9-35

integrated SQL analysis, 9-25

interoperability, 9-24

modules

recompiling, 7-39

PLSQL_V2_COMPATIBILITY initialization parameter, 9-25

removing incompatibilities for downgrading, 14-13

variables

NCHAR and NLS, 9-33

precompilers

applications

changing to use Oracle9i, 10-10

upgrading options, 10-7

compatibility, 9-23

interoperability, 9-23

PL/SQL backward compatibility, 9-24

upgrading applications to Oracle9i, 10-3

PRESPAWN_LIST networking parameter, F-5

PRESPAWN_MAX networking parameter, F-5

prespawned dedicated servers, F-3

primary keys

upgrading snapshots, G-17

Pro*Ada

upgrading to SQL*Module for Ada, 9-24

Pro*C/C++

connecting with SYSDBA privileges, 9-24

Pro*COBOL

connecting with SYSDBA privileges, 9-24

Procedural Option

required for migration, 4-9, 5-9

PROPS$ view

NCHAR and NLS, 9-33

protocol.ora file, F-3

proxy copy

requirement, 9-47

queue tables

upgrading, 7-37

RAW

maximum size

change, 9-20

read-only tablespaces

active transactions, 9-29

compatibility, 9-29

migration, 4-4

REAL keyword

behavior differences, 9-27

rebuilding indexes

physical ROWIDs, 12-10

recovery

compatibility, 9-16, 9-43

recovery catalog

compatibility with Recovery Manager, 9-44

upgrading, 7-38

Recovery Manager

backup management, 9-44

commands

compatibility, 9-44

normalize catalog, 8-13

REFs

compatibility, 9-15

REGISTER command, F-5, F-6

release

definition, 1-2

relinking with SQL*Net, 10-3

remote connections

multithreaded shared servers, 3-18

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 7-20

migration, A-8

remove incompatibilities

with release 8.1, 14-1

removing incompatibilities

UTLPITL.SQL, 13-3

REORDER_NS command, F-23

replication

compatibility, 9-11, 9-16, 9-48

downgrading, 13-12

regenerating after, 13-14

migration, 4-7

migration overview, G-2

obsolete procedures, G-22

upgrading, 7-3

requirements

export, 6-2

import, 6-2

resource manager. See database resource manager

restricted ROWIDs, 12-8

reverse migration

not supported, 15-4

ROLLBACK FORCE command, 4-9, 5-8

rollback segments

migration, 4-4

rosbild.sql script, F-20

ROSFILES

nmcbild.sql script, F-20

nmcgrnt.sql script, F-20

rosbild.sql script, F-20

rosgrnt.sql script, F-20

ROWIDs

extended, 12-8

restricted, 12-8

rowids

compatibility, 9-32

client access, 12-7

conversion to version 8 format, 12-3

examples, 12-6

DBMS_ROWID compatibility package, 12-3

indexes, 12-10

migration, 12-1

FAQ, 12-9

questions and answers, 12-9

snapshot refresh, 12-7

SAVEPOINT keyword

behavior differences, 9-27

schema objects

compatibility, 9-10, 9-14, 9-30

scripts

downgrading, 13-5

errors while running, 1-11

rerunning, 4-33, 5-22, 7-23, 13-6

upgrading, 7-22

SecurID authentication, F-2

SERIALIZABLE initialization parameter

compatibility, B-10

Server Manager

differences with SQL*Plus

ampersands, 11-14

blank lines, 11-12

commands, 11-3

comments, 11-10

COMMIT command, 11-16

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

not supported in Oracle9i, 8-9, 11-1

server parameter file

migrating to, 8-4

service naming

Net8, 9-50

SERVICE_NAME parameter, F-7

SERVICE_NAMES initialization parameter, F-11

SET COMPATIBILITY command

SQL*Plus scripts, 10-11

SET CONNECT_TIMEOUT command, F-6

SET USE_PLUGANDPLAY command, F-6

SET_SESSION_LONGOPS procedure

syntax change, 9-38

shadow processes

open cursors and, 3-19

shared server

requirements for running, 9-49

shared structures

interoperability, 9-22

SHARED_POOL_SIZE initialization parameter

changes in behavior, 8-10

parallel execution allocation, B-12

SHOW CONNECT_TIMEOUT command, F-6

SID networking parameter, F-8

SID, configuring on the listener, F-14

SID_NAME parameter, F-14

single-table hash clusters

compatibility, 9-10, 9-14

snapshot sites

migration, G-9

snapshots

refresh

physical ROWIDs, 12-7

upgrading to primary key, G-17

SORT_AREA_SIZE initialization parameter

compatibility, B-10

SORT_DIRECT_WRITES initialization parameter

compatibility, B-10

source database

definition, 1-3

SOURCE_ROUTE parameter, F-10

space requirements

copying data, 3-16

migration, 3-16, 4-5, 5-5

Spatial

compatibility, 9-18

SPOOL

Migration utility option, 4-18

SPX protocol, F-3

SQL

compatibility, 9-12, 9-17

functions

added in Oracle9i, E-2

added in version 8, E-4

removing incompatibilities for downgrading, 14-13

SQL commands

COMMIT FORCE, 4-9, 5-8

ROLLBACK FORCE, 4-9, 5-8

SQL*Module

for Ada, 9-24

SQL*Net

coexistence issues, F-7 to F-9

Oracle9i databases, F-7

using SERVICE_NAME networking parameter, F-7

using SID networking parameter, F-8

migrating to Oracle Names release 1 (9.0.1), F-15

migrating to Oracle Net, 8-16, 9-49

migrating to Oracle Net Services, F-11 to F-14

configuration files, F-12

listener.ora file, F-14

software on client, F-12

software on server, F-12

tnsnames.ora file, F-13

verifying service name and instance name, F-11

relinking, 10-3

requirement for migration

Windows platforms, 4-13, 5-13

SID networking parameter, F-8

upgrading from V1 to V2, 9-49

use with Oracle9i, 10-3

SQL*Plus

differences with Server Manager

ampersands, 11-14

blank lines, 11-12

commands, 11-3

comments, 11-10

COMMIT command, 11-16

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

upgrading, 10-11

SQLJ

installing, 8-5

SQLNET.IDENTIX_FINGERPRINT_DATABASE networking parameter, F-4

SQLNET.IDENTIX_FINGERPRINT_DATABASE_ PASSWORD networking parameter, F-4

SQLNET.IDENTIX_FINGERPRINT_DATABASE_ USER networking parameter, F-4

SQLNET.IDENTIX_FINGERPRINT_METHOD networking parameter, F-4

sqlnet.ora file

parameters

NAMES.DEFAULT_DOMAIN, F-4

NAMES.PREFERRED_SERVERS, F-4

SQLNET.IDENTIX_FINGERPRINT_DATABASE_PASSWORD, F-4

WALLET_LOCATION, F-4

unsupported parameters

AUTOMATIC_IPC, F-4

NAMES.DEFAULT_ZONE, F-4

NAMES.NDS.NAME.CONTEXT, F-4

OSS.MY.WALLET, F-4

SQLNET.IDENTIX_FINGERPRINT_DATABASE, F-4

SQLNET.IDENTIX_FINGERPRINT_DATABASE_PASSWORD, F-4

SQLNET.IDENTIX_FINGERPRINT_DATABASE_USER, F-4

SQLNET.IDENTIX_FINGERPRINT_METHOD, F-4

standby database

compatibility, 9-45

migrating, 8-10

migrating to Oracle9i, 8-11

upgrading, 8-10

upgrading to Oracle9i, 8-11

STARTUP

compatibility, 9-27

statements

ALTER DATABASE RESET COMPATIBILITY, 9-9

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

static data dictionary views

added in Oracle9i, C-2

added in version 8, C-7

changed in Oracle9i

added columns, C-4

changed in VERSION 8

dropped columns, C-15

changed in version 8

added columns, C-12

columns that may return NULLs, C-17

renamed columns, C-17

changes in Oracle9i, C-1

obsolete, 9-30

obsolete in version 8, C-19

renamed in Oracle9i, C-4

statistics tables

upgrading, 7-39

SUBSTR operator, 9-20

subtypes

downgrading, 14-13

Summary Advisor

installing Java classes, 8-5

summary management

compatibility, 9-12, 9-18

SYS schema

user-created objects in, 9-30

SYSDBA

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

connecting in Pro*COBOL, 9-24

system requirements

for migration, 3-16

SYSTEM tablespace

Migration utility, 3-6, 4-5

Oracle Data Migration Assistant, 5-5

space

insufficient for migration, A-4

tablespaces

automatic segment-space managed

removing, 14-3

automatic undo managed

removing, 14-4

compatibility, 9-9, 9-13, 9-28

migrating offline tablespaces, 4-11, 5-10

target database

definition, 1-3

tempfiles

data dictionary information, 9-29

temporary tables

compatibility, 9-14

temporary tablespace

space

insufficient for migration, A-4

terminology

migration, 1-2

testing

applications for migration, 3-26

developing a plan for migration, 3-22

EXPLAIN PLAN, 3-25

functional for migration, 3-23

integration for migration, 3-23

INTO clause, 3-25

migration results, 8-16

minimal for migration, 3-23

performance for migration, 3-24

pre- and post-migration, 3-25

the migrated test database, 3-26

the migration process, 3-26

volume/load stress for migration, 3-24

thread safety

compatibility, 9-22

tnsnames.ora file

migrating, F-13

parameters

FAILOVER, F-10

LOAD_BALANCE, F-10

SERVICE_NAME, F-7

SID, F-8

SOURCE_ROUTE, F-10

unsupported parameters

COMMUNITY, F-4

upgrading, F-13

TO_LABEL function

desupported, 9-35

TO_LOB function, 8-7

TP monitors, 3-19

transactions

pending, 4-9, 5-8

Transparent Application Failover (TAF)

GLOBAL_DBNAME networking parameter in listener.ora, F-14

transportable tablespaces

compatibility, 9-13

triggers

compatibility, 9-17

troubleshooting

database fails to open after removing incompatibilities, 9-9

migration, A-1

ALTER DATABASE CONVERT statement, A-6

AUDIT_TRAIL initialization parameter, A-4

database name mismatch, A-9

datafile version integrity, A-10

Migration utility error messages, A-11

missing convert file, A-7

MULTIPLIER option, A-6

NOMOUNT database start mode, A-7

OPTIMAL setting, A-5

Oracle7 control file, A-7

password file, A-8

running the Migration utility, A-3

running the Oracle Data Migration Assistant, A-3

scripts run long, A-11

SYSTEM tablespace, A-4

temporary tablespace tablespace, A-4

upgrading, A-1

TRUE keyword

behavior differences, 9-27

Trusted Oracle

Export/Import, 6-3

tuning

after migration, 8-17

type DTYCHR, 12-10

type evolution

compatibility, 9-11

interoperability, 9-34

type inheritance

compatibility, 9-11

types

evolved

removing, 14-12

non-final

downgrading, 14-13

U0703040.SQL script, 4-33

Universal ROWIDs. See UROWIDs

upgrading

Advanced Queuing, 7-37

after upgrading, 8-1, 8-17

applications, 10-1

compatibility rules, 10-4

options, 10-7

relinking, 10-4

character set, 7-2

definition, 1-3

initialization parameters, 7-19

interMedia, 7-31

Java, 7-25, 7-26, 7-29, 7-31

JServer, 7-25

listener.ora file, 8-10

manually, 7-15

materialized views, 7-36

NCHAR columns, 8-3

new administrative procedures, 8-12

Oracle Forms applications, 10-12

Oracle Label Security, 7-34

Oracle Spatial, 7-31

Oracle Text, 7-31

Oracle9i Real Application Clusters, 7-4, 7-35

rolling upgrade, 1-13

ORADIM, 7-18

OUTLN user, avoid, 7-5

parallel execution, 8-10

paths, 7-2

post upgrade, 8-1, 8-17

post-upgrade actions, 8-1

preparing to upgrade, 7-5

queue tables, 7-37

recovery catalog, 7-38

replication, 7-3

scripts, 7-22

CATALOG.SQL, 7-23

CATCLUST.SQL, 7-35

CATPROC.SQL, 7-23

errors while running, 1-11

JISU815.SQL, 7-29

JISU816.SQL, 7-29

JISU817.SQL, 7-29

JSPU815.SQL, 7-31

JSPU816.SQL, 7-31

JSPU817.SQL, 7-31

JVMU815.SQL, 7-26

JVMU816.SQL, 7-26

JVMU817.SQL, 7-26

OLSU817.SQL, 7-34

rerunning, 7-23

UTLRP.SQL, 7-39

XMLU815.SQL, 7-28

XMLU816.SQL, 7-28

XMLU817.SQL, 7-28

specific components, 7-24

SQL*Plus scripts, 10-11

standby database, 8-10

statistics tables, 7-39

steps, 7-2

supported releases, 7-2

troubleshooting, A-1

using the Oracle Data Migration Assistant, 7-8

XDK for Java, 7-27

XML, 7-27, 7-28

UROWIDs

compatibility, 9-15

interoperability, 9-33

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

Use Oracle8 Release 8.0 Compatible Identification option, F-10

USE_PLUG_AND_PLAY_listener_name networking parameter, F-5

user-created objects

in SYS schema, 9-30

user-defined aggregate functions

compatibility, 9-11

dropping for downgrading, 14-12

user-defined datatypes

compatibility, 9-34

interoperability, 9-35

new format, 9-34

user-defined object identifiers

compatibility, 9-15

UTLCHN1.SQL script, 9-36

compatibility, 9-17

UTLCONST.SQL script, 8-9

UTLEXPT1.SQL script, 9-36

compatibility, 9-17

UTLINCMP.SQL script, 14-2

UTLPITL.SQL script, 13-3

UTLRP.SQL script, 4-33, 5-22, 7-39

VALUE$ view

NCHAR and NLS, 9-33

VARCHAR2

maximum size

change, 9-20

varrays

compatibility, 9-11, 9-15

removing from partitioned index-organized tables, 14-13

stored as LOBs

compatibility, 9-35

version

definition, 1-2

version 6

Export/Import for migration, 6-2

versions

multiple, 1-4

view constraints

compatibility, 9-12

Visual Image Retrieval

compatibility, 9-18

WALLET_LOCATION networking parameter, F-4

word-size

changing, 1-12, 7-40

XDK for Java

upgrading, 7-27

XML

downgrading, 13-13

upgrading, 7-27, 7-28

XMLD817.SQL script, 13-13

XMLU815.SQL script, 7-28

XMLU816.SQL script, 7-28

XMLU817.SQL script, 7-28

Index

Numerics

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X