Skip Headers

Oracle9i Database Migration
Release 2 (9.2)

Part Number A96530-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
View PDF

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X 


Numerics

2 GB and larger files
operating system dependencies, 5-51
32-bit to 64-bit conversion. See word size

A

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

B

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

C

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
behavior change, 5-37
CREATE TYPE command
differences between Server Manager and SQL*Plus, C-13

D

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

E

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

F

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

G

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

H

hash partitioned index-organized tables
downgrading, 7-11
Heterogeneous Services
agents
compatibility, 5-49
interoperability, 5-49
multithreaded, 5-49

I

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

J

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

K

keywords
behavior differences, 5-27

L

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

M

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

N

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

O

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

P

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

Q

queue tables
upgrading, 4-16

R

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

S

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

T

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

U

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

V

VALUE$ view
NCHAR and NLS, 5-34
VARCHAR2
maximum size
change, 5-20
varrays
stored as LOBs
compatibility, 5-36

W

word size
changing, 1-11, 4-21

X

XMLD817.SQL script, 7-32
XMLD901.SQL script, 7-32