Oracle9i Database Migration -- Index

2 GB and larger files

operating system dependencies, 5-51

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

Ada. See SQL*Module for Ada

Advanced Queuing

compatibility, 5-38

privileges, 5-38

rule based subscriptions, 5-39

interoperability, 5-38

sender's ID column, 5-38

AL24UTFFSS character set

desupported in Oracle9i, 5-33

ALTER DATABASE CONVERT statement, 3-22, D-2

rerunning, D-30

ALTER DATABASE OPEN RESETLOGS MIGRATE statement, 3-22, D-3

ALTER DATABASE RESET COMPATIBILITY statement, 5-9, 5-10

ALTER DATABASE RESET LOGS statement, D-5

ALTER TABLE statement

bitmap index invalidation, 5-31

ANALYZE TABLE VALIDATE STRUCTURE statement

change in release 8.1, 5-21

applications

client/server configurations

upgrading, 6-3

compatibility, 5-19, 6-2

development

role during the upgrade, 1-8

index-organized tables

compatibility, 5-20

interoperability, 5-19

linking with newer libraries, 6-6

OCI

compatibility, 5-21

interoperability, 5-21

physical ROWIDs and UROWIDs, 5-20

PL/SQL

compatibility, 5-24

interoperability, 5-24

precompiler

compatibility, 5-23

interoperability, 5-23

running against older server, 6-5

upgrading, 6-1

compatibility rules, 6-4

options, 6-6

relinking rules, 6-4

archive log destination parameters

new in release 8.1, A-11

archived redo logs

analyzing

from other databases, 5-47

compatibility, 5-46

rearchiving, 5-46

archiving

error detection behavior, 5-47

AUDIT_TRAIL initialization parameter

for upgrading, D-26

automatic segment-space managed tablespaces

change in compatibility level, 5-16

automatic segment-space managed tablespaces with LOBs

downgrading, 7-7

backups

after upgrading, 4-2

before upgrading, D-14

compatibility, 5-44

EBU, 5-44

preparing a strategy, 2-8

Recovery Manager and EBU, 5-44

backward compatibility

of ROWIDs, D-38

bitmap indexes

invalidations, 5-31

during upgrade, 4-19

bitmap secondary indexes

dropping from index-organized tables, 7-10

blocks

block size

DB_BLOCK_SIZE initialization parameter, D-4

minimums for upgrading, D-4

CATALOG5.SQL script

obsolete, 5-31

CATALOG6.SQL script

obsolete, 5-31

CATALOG.SQL script, 3-24, 7-30, D-3

CATCLUST.SQL script, 7-31

CATEXP7.SQL script, 8-2

CATPARR.SQL script, 7-31

CATPROC.SQL script, 3-24, 7-30, D-3

CATREP.SQL script, 7-30

change passwords

for oracle-supplied accounts, 4-2

changes to initialization parameters, D-40

changes to static data dictionary views, D-41

CHAR

maximum size

change, 5-20

CHARACTER keyword

behavior differences, 5-27

character sets

upgrading the database, 3-10

varying-width

CLOBs and NCLOBs, 5-32

CHECK_ONLY

MIG utility option, D-9

ckpdom.ora file, B-19

ckpreg.ora file, B-19

ckptop.ora file, B-19

client-server configurations, 1-9

CLOBs

compatibility, 5-32

collections

collection columns

user-specified storage, 5-36

collection locators

compatibility, 5-36

command line

command-line options

MIG utility, D-9

commands

COMMIT FORCE, D-5

ROLLBACK FORCE, D-5

comments

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

COMMIT command

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

COMMIT FORCE command, D-5

COMMIT keyword

behavior differences, 5-27

compatibility, 5-1

Advanced Queuing, 5-38

ALTER DATABASE RESET COMPATIBILITY statement, 5-9

ANALYZE VALIDATE STRUCTURE statement, 5-21

applications, 5-19, 6-2

index-organized tables, 5-20

physical ROWIDs and UROWIDs, 5-20

archived redo logs, 5-46

automatic segment-space managed tablespaces, 5-16

backup, 5-44

change in maximum size

CHAR, 5-20

RAW, 5-20

VARCHAR2, 5-20

checking level for features, 5-10

compatibility level, 5-6

features requiring, 5-10

COMPATIBLE initialization parameter, 5-2

CREATE TABLE behavior change, 5-37

data dictionary, 5-30

datafiles, 5-28

datatypes, 5-31

date columns in dynamic performance views, 5-32

dictionary managed tablespaces, 5-16

downgrading, 5-6

Export/Import, 8-2

Heterogeneous Services agents, 5-49

initialization parameters, A-5

LOB index clause, 5-32

LOBs, 5-32

CLOBS and NCLOBs, 5-32

LogMiner, 5-47

materialized views, 5-48

nested tables, 5-36

NLS and NCHAR environment variables, 5-34

object types, 5-16

OCI, 5-21

link line, 5-22

thread safety, 5-22

optimization, 5-39

Oracle Managed Files, 5-16

Oracle OLAP, 5-17

PL/SQL, 5-24

integrated SQL analysis, 5-24

PLSQL_V2_COMPATIBILITY initialization parameter, 5-25

precompilers, 5-23

recovery, 5-44

removing incompatibilities, 7-2

replication, 5-48

resetting for database, 7-21

ROWID issues, D-38

rowids, 5-33

schema objects, 5-31

scripts

UTLCHN1.SQL, 5-37

UTLEXPT1.SQL, 5-37

standby database, 5-45

STARTUP, 5-27

tablespaces, 5-28

user-defined datatypes, 5-35

varrays

stored as LOBs, 5-36

compatibility level

checking, 7-2

resetting, 5-10

COMPATIBLE initialization parameter, 5-2

checking, 5-6

database structures, 5-3

setting, 5-7

features requiring, 5-10

when to set, 5-6

connections

load balancing in Net8, 5-50

connect-time failover

GLOBAL_DBNAME networking parameter in listener.ora, B-11

ConText

migrating to Oracle Text, D-5

control files

renaming or removing for migration, 3-17

renaming or removing for upgrading, 3-15

CREATE LIBRARY command

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

CREATE TABLE

AS subquery

behavior change, 5-37

CREATE TYPE command

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

data copying, 2-7

data dictionary

compatibility, 5-30

protection, 5-30

database

failure to open after removing incompatibilities, 5-10

database administrator

role during the upgrade, 1-7

database migration

definition, 1-3

overview, 1-3

overview for replication, E-2

terminology, 1-2

using Export/Import, 8-1

Database Upgrade Assistant

advantages, 2-4

running, 3-4

databases

backing up for upgrading, D-14

downgrading, 7-24

test upgrade results, 4-21

tuning after upgrading, 4-21

datafiles

compatibility, 5-28

offline during upgrade, D-3

datatypes

compatibility, 5-31

date constraints

checking for bad, 4-19

DB_BLOCK_CHECKSUM

new default value, A-5

DB_BLOCK_CHECKSUM initialization parameter

compatibility, A-5

DB_BLOCK_SIZE initialization parameter

for upgrading, D-4

DB_DOMAIN initialization parameter, B-11

compatibility, A-8

DB_NAME initialization parameter, B-11

DBMS

precompiler command line option, 5-24

DBMS_APPLICATION_INFO package

SET_SESSION_LONGOPS procedure

syntax change, 5-39

DBMS_ROWID package, D-34

DBMS_STATS package

upgrading statistics tables, 4-18

DBNAME

MIG utility option, D-9

DBUA. See Database Upgrade Assistant

DEC keyword

behavior differences, 5-27

definitions. See terminology

DEGREE keyword

in PARALLEL clause, 5-40

deinstalling, 1-12

deprecated dynamic performance views, A-20

deprecated features

dictionary managed tablespaces, 5-16

Oracle Dynamic Services, 5-17

Oracle Syndication Server, 5-18

deprecated initialization parameters, A-2

deprecated static data dictionary views, A-14

Developer/2000 Applications

upgrading, 6-10

dictionary managed tablespaces

compatibility, 5-16

deprecated, 5-16

interoperability, 5-16

distributed databases

preparing to upgrade, D-5

DML_LOCKS initialization parameter

compatibility, A-7

downgrading

CATALOG.SQL, 7-30

CATPARR.SQL, 7-31

CATPROC.SQL, 7-30

Java, 7-31, 7-32

Messaging Gateway, 7-32

Oracle Replication, 7-30

Oracle Workspace Manager, 7-32

Oracle9i Real Application Clusters, 7-31

ORADIM, 7-27

procedure for, 7-24

removing incompatibilities, 7-2

automatic segment-space managed tablespaces, 7-9

automatic segment-space managed tablespaces with LOBs, 7-7

bitmap secondary indexes on index-organized tables, 7-10

external tables, 7-9

hash partitioned index-organized tables, 7-11

indexes with large keys, 7-11

LOB retention, 7-7

non-final types, 7-19

parallel table functions, 7-20

partitioned index-organized tables with LOBs, 7-12

PDML ITL invariants, 7-12

pipelined table functions, 7-20

release 9.0 partitioning methods, 7-11

release 9.2 DEFAULT partitions, 7-5

release 9.2 partitioning methods, 7-5

release 9.2 Streams, 7-6

release 9.2 subpartition templates, 7-6

SQL and PL/SQL, 7-20

subtypes, 7-19

type evolution, 7-19

undo tablespaces, 7-9

user-defined aggregate functions, 7-19

view constraints, 7-20

resetting database compatibility, 7-21

scripts, 7-24

JVMD817.SQL, 7-31

JVMD901.SQL, 7-31

MGWD901.SQL, 7-32

OWMD901.PLB, 7-32

rerunning, 7-25

XMLD817.SQL, 7-32

XMLD901.SQL, 7-32

view constraints, 7-20

DUMP_TNSNAMES command, B-15

Dynamic Discovery Option for Oracle Names

migration issues, B-15

dynamic performance views

changes in Oracle9i, A-19

date columns

compatibility, 5-32

deprecated, A-20

obsolete, A-22

with dropped columns, A-24

with renamed columns, A-22

EBU

backup management, 5-44

enterprise user management

interoperability, 5-43

environment variables

compatibility

NCHAR and NLS, 5-34

ORA_NLS32, 5-34

ORA_NLS33, 5-34, D-11

required for upgrading, 3-21

Export utility

database migration, 8-1

requirements for upgrading, 8-3

Export/Import

advantages and disadvantages, 2-6

benefits, 2-7

compatibility, 8-2

effects on upgraded databases, 2-6

incompatible data, 8-3

scripts

CATEXP7.SQL, 8-2

time requirements, 2-7

upgrade steps using, 8-3

extended ROWIDs, D-38

external tables

dropping for downgrading, 7-9

FAILOVER networking parameter, B-7

failure to open database after removing incompatibilities, 5-10

FALSE keyword

behavior differences, 5-27

fast-start parallel recovery

compatibility, 5-46

fast-start rollback

compatibility, 5-46

feature compatibility, 5-10

features

new features, 5-10

requiring an upgrade, E-18

filenames

normalize, 4-13

Forms

upgrading Oracle Forms applications, 6-10

function-based indexes

invalidations

during upgrade, 4-15

generating

replication support, E-5, E-13

global database name, B-11

GLOBAL_DBNAME networking parameter, B-11

glossary. See terminology

GREATEST_LB function

desupported, 5-36

hash partitioned index-organized tables

downgrading, 7-11

Heterogeneous Services

agents

compatibility, 5-49

interoperability, 5-49

multithreaded, 5-49

identifying incompatibilities

UTLINCMP.SQL, 7-4

Identix authentication, B-2

Import utility

database migration, 8-1

requirements for upgrading, 8-3

incompatibilities

removing, 7-2

incremental upgrade, E-6

indexes

bitmap, 4-19

function-based, 4-15

initialization parameters

adjusting for Oracle9i, 3-18, 4-10

archive log destination

switching to new, A-11

changes, D-40

changes in Oracle9i, A-2

compatibility, A-5

DB_BLOCK_CHECKSUM, A-5

DB_DOMAIN, A-8

DML_LOCKS, A-7

JOB_QUEUE_PROCESSES, A-5

LOG_CHECKPOINT_TIMEOUT, A-7

O7_DICTIONARY_ACCESSIBILITY, A-7

ORACLE_TRACE_ENABLE, A-6

SERIALIZABLE, A-6

SORT_AREA_SIZE, A-6

SORT_DIRECT_WRITES, A-6

COMPATIBLE, 5-2

deprecated, A-2

LARGE_POOL_SIZE

parallel execution allocation, A-8

obsolete, A-3

REMOTE_LOGIN_PASSWORDFILE, 3-20

renamed, D-40

SHARED_POOL_SIZE

parallel execution allocation, A-8

INIT.ORA parameters. See initialization parameters

installation

Oracle9i software, 3-2, 8-4

INSTANCE_NAME initialization parameter, B-8

INSTANCES keyword

removed from PARALLEL clause, 5-40

INT keyword

behavior differences, 5-27

interoperability, 5-1, 5-13

Advanced Queuing, 5-38

applications, 5-19

dictionary managed tablespaces, 5-16

Heterogeneous Services agents, 5-49

native dynamic SQL, 5-36

object types, 5-16

OCI, 5-21

Oracle7 clients, 5-22

shared structures, 5-21

Oracle Managed Files, 5-16

Oracle OLAP, 5-17

PL/SQL, 5-24

precompilers, 5-23

type evolution, 5-35

UROWIDs, 5-33

user-defined datatypes, 5-35

Java

downgrading, 7-31, 7-32

JOB_QUEUE_PROCESSES

maximum number of job queue processes, A-5

JOB_QUEUE_PROCESSES initialization parameter

compatibility, A-5

JVMD817.SQL script, 7-31

JVMD901.SQL script, 7-31

keywords

behavior differences, 5-27

large files

operating system dependencies, 5-51

large key indexes

removing, 7-11

LARGE_POOL_SIZE initialization parameter

changes in behavior, 4-13

parallel execution allocation, A-8

LEAST_UB function

desupported, 5-36

listener.ora file

migrating, B-11

modifying after upgrading, 4-8

parameters

GLOBAL_DBNAME, B-11

ORACLE_HOME, B-11

SID_NAME, B-11

upgrading, B-11

listeners

configuring for Oracle Enterprise Manager, B-11

global database name, B-11

Oracle System Identifier, B-11

SID, B-11

load balancing

Net8, 5-50

LOAD_BALANCE networking parameter, B-7

LOAD_TNSNAMES command, B-16, B-19

LOB index clause

compatibility, 5-32

LOB retention

downgrading, 7-7

LOBs

compatibility, 5-32

locks

DML lock limit, DML_LOCKS, A-7

LOG_CHECKPOINT_TIMEOUT

new default value, A-7

LOG_CHECKPOINT_TIMEOUT initialization parameter

compatibility, A-7

LogMiner

compatibility, 5-47

LU6.2 protocol, B-3

manual upgrade

advantages, 2-5

prepare the database, 3-12, D-5

master sites

incremental upgrade of, E-10

upgrading, E-3

materialized views

compatibility, 5-48

upgrading, 4-16

memory requirements

for MIG utility, D-3

Messaging Gateway

downgrading, 7-32

MGWD901.SQL script, 7-32

MIG utility

command-line options, D-9

error messages, D-15

memory requirements for, D-3

MULTIPLIER option, D-27

options

CHECK_ONLY, D-9

DBNAME, D-9

MULTIPLIER, D-9

NEW_DBNAME, D-10

NO_SPACE_CHECK, D-10

PFILE, D-10

SPOOL, D-10

overview, D-2

running, D-10

on UNIX operating systems, D-10

on Windows platforms, D-12

space required for SYSTEM tablespace, D-3

space requirements for, D-3

MIGRATE user

avoid, D-7

MIGRATE.BSQ script, D-13

migration

ALTER DATABASE CONVERT statement

rerunning, D-30

ALTER DATABASE OPEN RESETLOGS MIGRATE statement, 3-22

control files, 3-17

NCHAR and NLS, 5-34

Oracle Managed Files file names, 4-3

parallel execution, 4-13

ROWID compatibility, D-38

rowids, D-33

to a different operating system, 3-10

troubleshooting

datafile version integrity, D-31

MULTIPLIER

MIG utility option, D-9, D-27

multiversioning, 1-9

NAMES_DID table, B-13

NAMES_DOM table for Oracle Names, B-13

NAMES.ADMIN_REGION networking parameter, B-14, B-15

NAMES.DOMAINS networking parameter, B-13

namesini.sql script for Oracle Names, B-21

namesupg.sql script for Oracle Names, B-13, B-15, B-18, B-21

national character set

in Oracle8i, 5-34

native dynamic SQL

interoperability, 5-36

NCHAR

migration, 5-34

use in Oracle8i, 5-34

NCHAR and NLS environment variables

compatibility, 5-34

NCHAR columns

upgrading, 4-11

NCLOBs

compatibility, 5-32

nested tables

compatibility, 5-36

Net8

coexistence issues, B-4 to B-6

Oracle9i databases, B-4

using SERVICE_NAME networking parameter, B-4

using SID networking parameter, B-5

connection load balancing, 5-50

service naming, 5-50

SID networking parameter, B-5

upgrading to Oracle Names release 1 (9.0.1), B-12

upgrading to Oracle Net Services, B-8 to B-11

configuration files, B-9

listener.ora file, B-11

software on client, B-9

software on server, B-9

tnsnames.ora file, B-10

Net8 OPEN, B-2

new features

adding after upgrade, 4-10

requiring a compatibility level, 5-10

NEW_DBNAME

MIG utility option, D-10

NLS

migration, 5-34

NLS and NCHAR environment variables

compatibility, 5-34

NLS_LANG environment variable

compatibility, 5-34

nmcbild.sql script, B-17

nmcrgrnt.sql script, B-17

NMO_INFORMATION table for Oracle Names, B-14

NO_SPACE_CHECK

MIG utility option, D-10

Novell Directory Services (NDS)

authentication, B-2

external naming, B-2

NUMERIC keyword

behavior differences, 5-27

O7_DICTIONARY_ACCESSIBILITY initialization parameter

compatibility, 5-30, A-7

object types

compatibility, 5-16

interoperability, 5-16

obsolete

replication procedures, E-20

obsolete dynamic performance views, A-22

obsolete initialization parameters, A-3

obsolete replication procedures, E-20

obsolete static data dictionary views, A-16

OCI

applications

changing to use Oracle9i, 6-9

compatibility, 5-21

batch error mode, 5-22

client notification, 5-23

link line, 5-22

LISTEN call and AQ, 5-23

thread safety, 5-22

interoperability, 5-21

Oracle7 clients, 5-22

shared structures, 5-21

OCIChangePassword call, 5-42

OCISessionBegin call, 5-42

upgrading applications to Oracle9i, 6-3

OCI applications

upgrading options, 6-6

OFA, 1-10

offline datafiles

upgrading, D-3

OLON calls

obsolete, 5-22

operating system

migrating to a different, 3-10

Optimal Flexible Architecture. See OFA

OPTIMAL setting for SYSTEM rollback segment

for upgrading, D-26

optimization

compatibility, 5-39

options

deinstalling, 1-12

for MIG utility, D-9

ORA_NLS32 environment variable

compatibility, 5-34

ORA_NLS33 environment variable, D-11

compatibility, 5-34

Oracle Call Interface. See OCI

Oracle Dynamic Services

deprecated, 5-17

Oracle Enterprise Manager

static service information in listener.ora file, B-11

Oracle home

multiple, 1-9

Oracle interMedia

upgrading, 3-27

Oracle Managed Files

compatibility, 5-16

interoperability, 5-16

migrating file names, 4-3

Oracle Media Management API

compatibility

proxy copy requirement, 5-48

Oracle Names

coexistence issues, B-6

migrating

ckreg.ora file to cktop.ora file, B-19

Oracle Names version 2 using a database, B-13

ROSFILES, B-17

ROSFILES to a tnsnames.ora file, B-18

ROSFILES to Oracle Names tables in database, B-17

NAMES_DID table for Oracle Names, B-13

NAMES_DOM table, B-13

NAMES.ADMIN_REGION parameter in names.ora file, B-14, B-15

NAMES.DOMAINS parameter in names.ora file, B-13

namesini.sql script, B-21

namesupg.sql script, B-13, B-15, B-18, B-21

NMO_INFORMATION table, B-14

Oracle Names Control utility commands

DUMP_TNSNAMES command, B-15

LOAD_TNSNAMES, B-16, B-19

REORDER_NS, B-20

Oracle Names version 2 with Dynamic Discovery Option, B-15

Oracle Net Manager

discovering Oracle Names servers, B-20

loading tnsnames.ora file into Oracle Names, B-16, B-19

upgrading to release 1 (9.0.1), B-12

Oracle Names Control utility

commands

LOAD_TNSNAMES, B-16, B-19

REORDER_NS, B-20

Oracle Net

migrating or upgrading to, 5-49

Oracle Net Services

coexistence issues, B-4 to B-6

Oracle release 8.0 clients, B-5

Oracle release 8.0 databases, B-6

third-party applications, B-5

using Oracle Net Manager, B-7

using SERVICE_NAME networking parameter, B-4

using SID networking parameter, B-4

FAILOVER networking parameter, B-7

listener.ora file with Oracle Enterprise Manager, B-11

LOAD_BALANCE networking parameter, B-7

Oracle Net Manager

Use Options Compatible with Net8 8.0 Clients option, B-7

Use Oracle8 Release 8.0 Compatible Identification option, B-7

SERVICE_NAME parameter, B-4

SOURCE_ROUTE parameter, B-7

unsupported features

Identix authentication, B-2

LU6.2, B-3

Net8 OPEN, B-2

Novell Directory Services (NDS) authentication, B-2

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

prespawned dedicated servers, B-3

protocol.ora file, B-3

SecurID authentication, B-2

SPX, B-3

upgrading to, 4-20

Oracle OLAP

compatibility, 5-17

interoperability, 5-17

Oracle precompilers. See precompilers

Oracle Replication

downgrading, 7-30

Oracle Spatial

upgrading, 3-27

Oracle Syndication Server

deprecated, 5-18

Oracle System Identifier, configuring on the listener, B-11

Oracle Text

migrating from ConText to, D-5

upgrading, 3-27

Oracle Ultra Search

upgrading, 3-29

Oracle Universal Installer, 2-4

Oracle Visual Information Retrieval

upgrading, 3-27

Oracle Workspace Manager

downgrading, 7-32

ORACLE_HOME initialization parameter, B-11

ORACLE_TRACE_ENABLE initialization parameter

compatibility, A-6

Oracle9i

changes to dynamic performance views, A-19

changes to initialization parameters, A-2

changes to static data dictionary views, A-13

new features

adding after upgrade, 4-10

Oracle9i Real Application Clusters

compatibility requirements, 5-39

downgrading, 7-31

upgrading, 3-9

oracle-supplied accounts

change passwords, 4-2

ORADIM

downgrading, 7-27

upgrading, 3-16

ORLON calls

obsolete, 5-22

OUTLN user

avoid, 3-12

OWMD901.PLB script, 7-32

PARALLEL clause

DEGREE keyword, 5-40

INSTANCES keyword removed, 5-40

parallel execution

allocated from large pool, A-8

avoiding problems with, 4-13

parallel table functions

removing, 7-20

parameters

for MIG utility. See command-line options

partition views

migrate to partition tables, 4-19

partitioned index-organized tables with LOBs

downgrading, 7-12

password file

upgrades

exclusive setting, D-29

password management

application changes required for Oracle8i, 5-42

interoperability, 5-43

password expiration, 5-42

PDML ITL invariants

downgrading, 7-12

pending transactions

and upgrading, D-5

PFILE

MIG utility option, D-10

pipelined table functions

removing, 7-20

PL/SQL

backward compatibility, 5-24

compatibility, 5-24

functions

desupported, 5-36

integrated SQL analysis, 5-24

interoperability, 5-24

PLSQL_V2_COMPATIBILITY initialization parameter, 5-25

removing incompatibilities for downgrading, 7-20

variables

NCHAR and NLS, 5-34

precompilers

applications

changing to use Oracle9i, 6-9

upgrading options, 6-6

compatibility, 5-23

interoperability, 5-23

PL/SQL backward compatibility, 5-24

upgrading applications to Oracle9i, 6-3

preparing to upgrade, 2-2

prespawned dedicated servers, B-3

primary keys

upgrading snapshots, E-15

Pro*Ada

upgrading to SQL*Module for Ada, 5-24

Pro*C/C++

connecting with SYSDBA privileges, 5-23

Pro*COBOL

connecting with SYSDBA privileges, 5-23

Procedural Option

required for upgrading, D-5

PROPS$ view

NCHAR and NLS, 5-34

protocol.ora file, B-3

proxy copy

requirement, 5-48

queue tables

upgrading, 4-16

RAW

maximum size

change, 5-20

read-only tablespaces

upgrading, D-3

REAL keyword

behavior differences, 5-27

recovery

compatibility, 5-44

recovery catalog

compatibility with Recovery Manager, 5-44

upgrading, 4-17

Recovery Manager

backup management, 5-44

commands

compatibility, 5-44

normalize catalog, 4-13

release

definition, 1-2

release 9.0 partitioning methods

downgrading, 7-11

release 9.2 DEFAULT partitions

downgrading, 7-5

release 9.2 partitioning methods

downgrading, 7-5

release 9.2 Streams

downgrading, 7-6

release 9.2 subpartition templates

downgrading, 7-6

releases

multiple, 1-9

relinking with SQL*Net, 6-3

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 3-20

upgrading, D-29

renamed initialization parameters, D-40

REORDER_NS command, B-20

replication

compatibility, 5-48

database migration overview, E-2

obsolete procedures, E-20

upgrading, 3-11, D-5

requirements

Export utility, 8-3

import utility, 8-3

restricted ROWIDs, D-38

ROLLBACK FORCE command, D-5

rollback segments

upgrading, D-3

rosbild.sql script, B-17

ROSFILES

nmcbild.sql script, B-17

nmcgrnt.sql script, B-17

rosbild.sql script, B-17

rosgrnt.sql script, B-17

ROWIDs

extended, D-38

restricted, D-38

rowids

compatibility, 5-33

client access, D-38

conversion from Oracle7 format, D-34

examples, D-37

DBMS_ROWID compatibility package, D-34

migration, D-33

snapshot refresh, D-38

SAVEPOINT keyword

behavior differences, 5-27

schema objects

compatibility, 5-31

scripts

downgrading, 7-24

rerunning, 7-25

upgrading, 3-23

SecurID authentication, B-2

SERIALIZABLE initialization parameter

compatibility, A-6

Server Manager

differences with SQL*Plus

ampersands, C-12

blank lines, C-9

commands, C-3

comments, C-7

COMMIT command, C-14

CREATE LIBRARY command, C-13

CREATE TYPE command, C-13

hyphen continuation character, C-10

startup, C-2

syntax, C-7

migrating scripts to SQL*Plus, C-1

not supported in Oracle9i, 4-12, C-1

server parameter file

migrating to, 4-6

service naming

Net8, 5-50

SERVICE_NAME parameter, B-4

SERVICE_NAMES initialization parameter, B-8

SET COMPATIBILITY command

SQL*Plus scripts, 6-10

SET_SESSION_LONGOPS procedure

syntax change, 5-39

shared server

requirements for running, 5-50

shared structures

interoperability, 5-21

SHARED_POOL_SIZE initialization parameter

changes in behavior, 4-13

parallel execution allocation, A-8

SID networking parameter, B-5

SID, configuring on the listener, B-11

SID_NAME parameter, B-11

snapshot sites

upgrading, E-8

snapshots

refresh

physical ROWIDs, D-38

upgrading to primary key, E-15

SORT_AREA_SIZE initialization parameter

compatibility, A-6

SORT_DIRECT_WRITES initialization parameter

compatibility, A-6

SOURCE_ROUTE parameter, B-7

space requirements

for MIG utility, D-3

SPOOL

MIG utility option, D-10

SPX protocol, B-3

SQL

removing incompatibilities for downgrading, 7-20

SQL commands

COMMIT FORCE, D-5

ROLLBACK FORCE, D-5

SQL*Module

for Ada, 5-24

SQL*Net

coexistence issues, B-4 to B-6

Oracle9i databases, B-4

using SERVICE_NAME networking parameter, B-4

using SID networking parameter, B-5

migrating to Oracle Net, 5-49

migrating to Oracle Net Services, B-8 to B-11

configuration files, B-9

listener.ora file, B-11

software on client, B-9

software on server, B-9

tnsnames.ora file, B-10

verifying service name and instance name, B-8

relinking, 6-3

SID networking parameter, B-5

upgrading from V1 to V2, 5-50

upgrading to Oracle Names release 1 (9.0.1), B-12

upgrading to Oracle Net Services, 4-20

use with Oracle9i, 6-3

SQL*Plus

differences with Server Manager

ampersands, C-12

blank lines, C-9

commands, C-3

comments, C-7

COMMIT command, C-14

CREATE LIBRARY command, C-13

CREATE TYPE command, C-13

hyphen continuation character, C-10

startup, C-2

syntax, C-7

migrating scripts from Server Manager, C-1

scripts

upgrading, 6-9

standby database

compatibility, 5-45

upgrading, 4-8

STARTUP

compatibility, 5-27

statements

ALTER DATABASE RESET COMPATIBILITY, 5-10

ALTER DATABASE RESET LOGS, D-5

static data dictionary views

changes, D-41

changes in Oracle9i, A-13

deprecated, A-14

obsolete, 5-31, A-16

with columns that may return nulls, A-18

with dropped columns, A-16

with renamed columns, A-16

statistics tables

upgrading, 4-18

SUBSTR operator, 5-20

subtypes

downgrading, 7-19

SYS schema

user-created objects in, 5-30

SYSDBA

connecting in Pro*C/C++, 5-23

connecting in Pro*COBOL, 5-23

SYSTEM tablespace

MIG utility, D-3

space

insufficient for upgrading, D-25

tablespaces

automatic segment-space managed

removing, 7-9

compatibility, 5-28

upgrading offline tablespaces, D-6

tempfiles

data dictionary information, 5-29

temporary tablespace

space

insufficient for upgrading, D-25

terminology

database migration, 1-2

testing

applications for upgrade, 2-12

developing a plan, 2-8

EXPLAIN PLAN, 2-11

functional for upgrade, 2-9

integration for upgrading, 2-9

INTO clause, 2-11

minimal for upgrade, 2-9

performance for upgrade, 2-10

pre-upgrade and post-upgrade, 2-11

the upgrade process, 2-12

the upgraded test database, 2-12

upgrading results, 4-21

volume/load stress for upgrade, 2-10

thread safety

compatibility, 5-22

tnsnames.ora file

migrating, B-10

parameters

FAILOVER, B-7

LOAD_BALANCE, B-7

SERVICE_NAME, B-4

SID, B-5

SOURCE_ROUTE, B-7

upgrading, B-10

TO_LABEL function

desupported, 5-36

transactions

pending, D-5

Transparent Application Failover (TAF)

GLOBAL_DBNAME networking parameter in listener.ora, B-11

troubleshooting

database fails to open after removing incompatibilities, 5-10

migration

datafile version integrity, D-31

upgrades

ALTER DATABASE CONVERT statement, D-28

missing convert file, D-28

MULTIPLIER option, D-27

NOMOUNT database start mode, D-28

Oracle7 control file, D-28

upgrading

AUDIT_TRAIL initialization parameter, D-26

database name mismatch, D-30

MIG utility error messages, D-15

OPTIMAL setting, D-26

password file, D-29

running the MIG utility, D-25

SYSTEM tablespace, D-25

temporary tablespace, D-25

TRUE keyword

behavior differences, 5-27

tuning

after upgrading, 4-21

type evolution

interoperability, 5-35

types

evolved

removing, 7-19

non-final

downgrading, 7-19

undo tablespaces

removing, 7-9

upgrade

troubleshooting

MIG utility error messages, D-15

upgrade methods

choosing, 2-3

copying data, 2-7

Database Upgrade Assistant, 2-4

Export/Import, 2-6

manual upgrade, 2-5

upgrading

abandoning, D-32

after upgrading, 4-1

ALTER DATABASE CONVERT statement, 3-22

applications, 6-1

compatibility rules, 6-4

options, 6-6

relinking, 6-4

AUDIT_TRAIL initialization parameter, D-26

backup strategy, 2-8

character set, 3-10

control files, 3-15

exclusive password file, D-29

features requiring, E-18

incremental, E-6

initialization parameters, 3-18

listener.ora file, 4-8

master sites, E-3

materialized views, 4-16

MIGRATE user, avoid, D-7

MIGRATE.BSQ script, D-13

NCHAR columns, 4-11

new administrative procedures, 4-10

offline datafiles, D-3

offline tablespaces, D-6

OPTIMAL setting for SYSTEM rollback segment, D-26

Oracle Forms applications, 6-10

Oracle interMedia, 3-27

Oracle Spatial, 3-27

Oracle Text, 3-27

Oracle Ultra Search, 3-29

Oracle Visual Information Retrieval, 3-27

Oracle9i Real Application Clusters, 3-9

ORADIM, 3-16

OUTLN user, avoid, 3-12

parallel execution, 4-13

post upgrade actions, 4-1

queue tables, 4-16

read-only tablespaces, D-3

recovery catalog, 4-17

replication, 3-11, D-5

rolling upgrades, 1-12

scripts, 3-23

CATALOG.SQL, 3-24, D-3

CATPROC.SQL, 3-24, D-3

snapshot sites, E-8

specific components, 3-27

SQL*Plus scripts, 6-9

standby database, 4-8

statistics tables, 4-18

SYSTEM tablespace, D-25

temporary tablespace, D-25

testing, 2-8

testing results, 4-21

to primary key snapshots, E-15

troubleshooting

ALTER DATABASE CONVERT statement, D-28

AUDIT_TRAIL initialization parameter, D-26

database name mismatch, D-30

missing convert file, D-28

MULTIPLIER option, D-27

NOMOUNT database start mode, D-28

OPTIMAL setting, D-26

Oracle7 control file, D-28

password file, D-29

running the MIG utility, D-25

SYSTEM tablespace, D-25

temporary tablespace, D-25

tuning after, 4-21

using the Database Upgrade Assistant, 3-4

upgrading a database

ALTER DATABASE CONVERT statement, D-2

ALTER DATABASE OPEN RESETLOGS MIGRATE statement, D-3

block size minimums, D-4

choosing an upgrade method, 2-3

distributed database considerations, D-5

manually, 3-9

prepare the database, 3-12, D-5

overview of steps, 1-4

overview of the MIG utility, D-2

performing a manual upgrade, 2-4

preparing to, 2-2

role of application developer, 1-8

role of database administrator, 1-7

rollback segments, D-3

using Export/Import, 8-3

using the Database Upgrade Assistant, 2-3

UROWIDs

interoperability, 5-33

Use Options Compatible with Net8 8.0 Clients option, B-7

Use Oracle8 Release 8.0 Compatible Identification option, B-7

user-created objects

in SYS schema, 5-30

user-defined aggregate functions

dropping for downgrading, 7-19

user-defined datatypes

compatibility, 5-35

interoperability, 5-35

new format, 5-35

UTLCHN1.SQL script, 5-37

UTLCONST.SQL script, 4-19

UTLEXPT1.SQL script, 5-37

UTLINCMP.SQL script, 7-4

VALUE$ view

NCHAR and NLS, 5-34

VARCHAR2

maximum size

change, 5-20

varrays

stored as LOBs

compatibility, 5-36

word size

changing, 1-11, 4-21

XMLD817.SQL script, 7-32

XMLD901.SQL script, 7-32

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