Skip Headers

Oracle® Database Upgrade Guide
10g Release 1 (10.1)

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

Go to previous page
Previous
View PDF

Index

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

Numerics

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

A

Advanced Queuing
compatibility, 5.6.8
rule based subscriptions, 5.6.8.2
interoperability, 5.6.8
sender's ID column, 5.6.8.1
AL24UTFFSS character set
desupported, 5.5.3.3
ALTER TABLE statement
bitmap index invalidation, 5.6.4.1
ANALYZE TABLE VALIDATE STRUCTURE statement
change in release 8.1, 5.6.1.1.2
applications
client/server configurations
upgrading, 6.2.1
compatibility, 5.6.1, 6.1.1
development
role during the upgrade, 1.1.2
index-organized tables
compatibility, 5.6.1.1.1
interoperability, 5.6.1
linking with newer libraries, 6.2.2.2.1
OCI
compatibility, 5.6.1.2
interoperability, 5.6.1.2
physical ROWIDs and UROWIDs, 5.6.1.1.1
PL/SQL
compatibility, 5.6.1.4
interoperability, 5.6.1.4
precompiler
compatibility, 5.6.1.3
interoperability, 5.6.1.3
running against older server, 6.2.2.1.2
upgrading, 6
compatibility rules, 6.2.2
options, 6.2.3
relinking rules, 6.2.2
archive log destination parameters
new, A.2.15
archived redo logs
analyzing
from other databases, 5.6.12.7.1
compatibility, 5.6.12.6
rearchiving, 5.6.12.6.1
archiving
error detection behavior, 5.6.12.6.2
automatic segment-space managed tablespaces
change in compatibility level, 5.4.4

B

backups
after upgrading, 4.1.1
compatibility, 5.6.12
preparing a strategy, 2.1.5
bitmap indexes
invalidations, 5.6.4.1

C

CATRELOD.SQL script, 7.4
change passwords
for oracle-supplied accounts, 4.1.2
character sets
upgrading the database, 5.5.3.2
varying-width
CLOBs and NCLOBs, 5.6.5.1.1
client-server configurations, 1.2.1
CLOBs
compatibility, 5.6.5.1.1
collections
collection columns
user-specified storage, 5.6.6.2
collection locators
compatibility, 5.6.6.2
command line options
for Database Upgrade Assistant, 3.3.2
comments
differences between Server Manager and SQL*Plus, B.3.1
COMMIT command
differences between Server Manager and SQL*Plus, B.3.6
compatibility, 5
Advanced Queuing, 5.6.8
ANALYZE VALIDATE STRUCTURE statement, 5.6.1.1.2
applications, 5.6.1, 6.1.1
index-organized tables, 5.6.1.1.1
physical ROWIDs and UROWIDs, 5.6.1.1.1
archived redo logs, 5.6.12.6
automatic segment-space managed tablespaces, 5.4.4
backup, 5.6.12
checking for incompatibilities, 7.2
compatibility level, 5.1.1.3
COMPATIBLE initialization parameter, 5.1.1
data dictionary, 5.6.3
datafiles, 5.5.2, 5.6.2
datatypes, 5.5.3, 5.6.5
dictionary managed tablespaces, 5.4.3
downgrading, 5.1.1.1
Heterogeneous Services agents, 5.6.13.3
initialization parameters, A.2
LOB index clause, 5.6.5.1.2
LOBs, 5.6.5.1
CLOBS and NCLOBs, 5.6.5.1.1
LogMiner, 5.6.12.7
materialized views, 5.6.13.1
nested tables, 5.6.6.2
Net8, 5.6.14
NLS and NCHAR environment variables, 5.6.5.3
object types, 5.4.5
OCI, 5.6.1.2
optimization, 5.6.9
Oracle Managed Files, 5.4.6
Oracle OLAP, 5.4.7
PL/SQL, 5.6.1.4
integrated SQL analysis, 5.6.1.4.1
PLSQL_V2_COMPATIBILITY initialization parameter, 5.6.1.4.4
precompilers, 5.6.1.3
recovery, 5.6.12
replication, 5.5.5, 5.6.13.2
rowids, 5.6.5.2
schema objects, 5.6.4
scripts
UTLCHN1.SQL, 5.6.7.2
UTLEXPT1.SQL, 5.6.7.3
standby database, 5.6.12.4
STARTUP, 5.5.1
tablespaces, 5.5.2, 5.6.2
user-defined datatypes, 5.5.4, 5.6.6
varrays
stored as LOBs, 5.6.6.3
COMPATIBLE initialization parameter, 5.1.1
checking, 5.1.1.4
database structures, 5.1.1.2
setting, 5.1.2
when to set, 5.1.1.5
connections
load balancing in Net8, 5.6.14.1
control files
renaming or removing for migration, 3.4.3
CREATE TYPE command
differences between Server Manager and SQL*Plus, B.3.5

D

D0902000.SQL script, 7.4
data copying, 2.1.3.4
using Export/Import, 8
data dictionary
compatibility, 5.6.3
protection, 5.6.3.1
database administrator
role during the upgrade, 1.1.1
Database Upgrade Assistant
advantages, 2.1.3.1
command line options, 3.3.2
running, 3.3
silent mode, 3.3.4
starting, 3.3.1
database upgrade process
overview, 1.1
databases
downgrading, 7.4
test upgrade results, 4.4
tuning after upgrading, 4.4.1
datafiles
compatibility, 5.5.2, 5.6.2
datatypes
compatibility, 5.5.3, 5.6.5
DB_BLOCK_CHECKSUM
new default value, A.2.8
DB_BLOCK_CHECKSUM initialization parameter
compatibility, A.2.8
DB_BLOCK_SIZE
new default value, A.2.2
DB_BLOCK_SIZE initialization parameter
compatibility, A.2.2
DB_DOMAIN initialization parameter
compatibility, A.2.13
DBMS
precompiler command line option, 5.6.1.3.3
DBMS_STATS package
upgrading statistics tables, 4.3.7
DBUA. See Database Upgrade Assistant
DEGREE keyword
in PARALLEL clause, 5.6.10.1
deinstalling, 1.6
deprecated dynamic performance views, A.4.1
deprecated features
dictionary managed tablespaces, 5.4.3
Oracle Dynamic Services, 5.4.9
Oracle Syndication Server, 5.4.10
deprecated initialization parameters, A.1.1
deprecated static data dictionary views, A.3.1
Developer/2000 Applications
upgrading, 6.4
dictionary managed table, 5.4.3
dictionary managed tablespaces
compatibility, 5.4.3
deprecated, 5.4.3
downgrading
CATRELOD.SQL, 7.4
checking for incompatibilities, 7.2
D0902000.SQL, 7.4
ORADIM, 7.4
procedure for, 7.4
scripts, 7.4
rerunning, 7.4
dynamic performance views
changes in Oracle Database 10g, A.4
deprecated, A.4.1
obsolete, A.4.2
with dropped columns, A.4.4
with renamed columns, A.4.3

E

enterprise user management
interoperability, 5.6.11.1
environment variables
compatibility
NCHAR and NLS, 5.6.5.3
ORA_NLS33, 5.6.5.3
required for upgrading, 3.4.3
Export utility
data copying, 8
requirements, 8.1
Export/Import
advantages and disadvantages, 2.1.3.3
benefits, 2.1.3.3.2
effects on upgraded databases, 2.1.3.3.1
incompatible data, 8.1.1
time requirements, 2.1.3.3.3
upgrading, 8.2

F

fast-start parallel recovery
compatibility, 5.6.12.5
fast-start rollback
compatibility, 5.6.12.5
filenames
normalize, 4.3.2
Forms
upgrading Oracle Forms applications, 6.4
function-based indexes
invalidations
during upgrade, 4.3.3

G

GREATEST_LB function
desupported, 5.6.7.1

H

Heterogeneous Services
agents
compatibility, 5.6.13.3
interoperability, 5.6.13.3
multithreaded, 5.6.13.3.2

I

Import utility
data copying, 8
requirements, 8.1
incompatibilities
checking for, 7.2
incompatible data
Export/Import, 8.1.1
indexes
function-based, 4.3.3
initialization parameters
adjusting for Oracle Database 10g, 3.4.3, 4.1.13
archive log destination
switching to new, A.2.15
changes in Oracle Database 10g, A.1
compatibility, A.2
DB_BLOCK_CHECKSUM, A.2.8
DB_BLOCK_SIZE, A.2.2
DB_DOMAIN, A.2.13
JOB_QUEUE_PROCESSES, A.2.9
LOG_CHECKPOINT_TIMEOUT, A.2.11
O7_DICTIONARY_ACCESSIBILITY, A.2.12
SESSION_CACHED_CURSORS, A.2.1
SORT_AREA_SIZE, A.2.10
SORT_DIRECT_WRITES, A.2.10
COMPATIBLE, 5.1.1
when to set, 5.1.1.5
deprecated, A.1.1
LARGE_POOL_SIZE
parallel execution allocation, A.2.14
obsolete, A.1.2
SHARED_POOL_SIZE
parallel execution alloc, A.2.14
INIT.ORA parameters. See initialization parameters
installation
Oracle Database 10g software, 3.2
Oracle9i software, 8.2
INSTANCES keyword
removed from PARALLEL clause, 5.6.10.1
interoperability, 5, 5.2
Advanced Queuing, 5.6.8
applications, 5.6.1
dictionary managed tablespaces, 5.4.3
Heterogeneous Services agents, 5.6.13.3
Net8, 5.6.14
object types, 5.4.5
OCI, 5.6.1.2
shared structures, 5.6.1.2.1
Oracle Managed Files, 5.4.6
Oracle OLAP, 5.4.7
PL/SQL, 5.6.1.4
precompilers, 5.6.1.3
replication, 5.5.5
UROWIDs, 5.6.5.2.1
user-defined datatypes, 5.6.6.1.1

J

JOB_QUEUE_PROCESSES
maximum number of job queue processes, A.2.9
JOB_QUEUE_PROCESSES initialization parameter
compatibility, A.2.9

L

LARGE_POOL_SIZE initialization parameter
changes in behavior, 4.3.1
parallel execution allocation, A.2.14
LEAST_UB function
desupported, 5.6.7.1
listener.ora file
modifying after upgrading, 4.1.8
load balancing
Net8, 5.6.14.1
LOB index clause
compatibility, 5.6.5.1.2
LOBs
compatibility, 5.6.5.1
LOG_CHECKPOINT_TIMEOUT
new default value, A.2.11
LOG_CHECKPOINT_TIMEOUT initialization parameter
compatibility, A.2.11
LogMiner
compatibility, 5.6.12.7

M

manual upgrade
advantages, 2.1.3.2
analyze the database, 3.4.1
backup the database, 3.4.2
materialized views
compatibility, 5.6.13.1
upgrading, 4.3.4
migrating data
to a different operating system, 3.1.4
migration
control files, 3.4.3
Oracle Managed Files file names, 4.1.5
parallel execution, 4.3.1
multiversioning, 1.2.1

N

NCHAR and NLS environment variables
compatibility, 5.6.5.3
NCHAR columns
upgrading, 4.2.1
NCLOBs
compatibility, 5.6.5.1.1
nested tables
compatibility, 5.6.6.2
Net8
compatibility, 5.6.14
connection load balancing, 5.6.14.1
interoperability, 5.6.14
service naming, 5.6.14.1
new features
adding after upgrade, 4.1.11
NLS and NCHAR environment variables
compatibility, 5.6.5.3
NLS_LANG environment variable
compatibility, 5.6.5.3

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter
compatibility, 5.6.3.1, A.2.12
object types
compatibility, 5.4.5
interoperability, 5.4.5
obsolete dynamic performance views, A.4.2
obsolete initialization parameters, A.1.2
obsolete static data dictionary views, A.3.2
OCI
applications
changing, 6.2.3.4.2
compatibility, 5.6.1.2
batch error mode, 5.6.1.2.2
client notification, 5.6.1.2.3
LISTEN call and AQ, 5.6.1.2.4
interoperability, 5.6.1.2
shared structures, 5.6.1.2.1
upgrading applications, 6.2
OCI applications
upgrading options, 6.2.3
OFA, 1.3
operating system
migrating data to, 3.1.4
Optimal Flexible Architecture. See OFA
optimization
compatibility, 5.6.9
options
deinstalling, 1.6
ORA_NLS33 environment variable
compatibility, 5.6.5.3
Oracle Database 10g
changes to dynamic performance views, A.4
changes to initialization parameters, A.1
changes to static data dictionary views, A.3
new features
adding after upgrade, 4.1.11
Oracle Dynamic Services
deprecated, 5.4.9
Oracle home
multiple, 1.2.1.1
Oracle Managed Files
compatibility, 5.4.6
interoperability, 5.4.6
migrating file names, 4.1.5
Oracle Media Management API
compatibility
proxy copy requirement, 5.6.12.8
Oracle Net Services
relinking, 6.1.1
Oracle OLAP
compatibility, 5.4.7
interoperability, 5.4.7
Oracle precompilers. See
Oracle release numbers, 1.2
Oracle Syndication Server
deprecated, 5.4.10
Oracle Universal Installer, 1.1
oracle-supplied accounts
change passwords, 4.1.2
ORADIM
downgrading, 7.4
upgrading, 3.4.3

P

PARALLEL clause
DEGREE keyword, 5.6.10.1
INSTANCES keyword removed, 5.6.10.1
parallel execution
allocated from large pool, A.2.14
avoiding problems with, 4.3.1
PL/SQL
backward compatibility, 5.6.1.3.3
compatibility, 5.6.1.4
functions
desupported, 5.6.7.1
integrated SQL analysis, 5.6.1.4.1
interoperability, 5.6.1.4
PLSQL_V2_COMPATIBILITY initialization parameter, 5.6.1.4.4
precompilers
applications
changing, 6.2.3.4.1
upgrading options, 6.2.3
compatibility, 5.6.1.3
interoperability, 5.6.1.3
PL/SQL backward compatibility, 5.6.1.3.3
upgrading applications, 6.2
preparing to upgrade, 2.1
Pro*C/C++
connecting with SYSDBA privileges, 5.6.1.3.1
Pro*COBOL
connecting with SYSDBA privileges, 5.6.1.3.2
proxy copy
requirement, 5.6.12.8

Q

queue tables
upgrading, 4.3.5

R

Real Application Clusters
compatibility requirements, 5.6.10
upgrading, 3.1.1
recovery
compatibility, 5.6.12
recovery catalog
compatibility with Recovery Manager, 5.6.12.1
upgrading, 4.3.6
Recovery Manager
commands
compatibility, 5.6.12.2
compatibility, 5.6.12.1
normalize catalog, 4.3.2
releases
definition, 1.2
multiple, 1.2.1
relinking with Oracle Net Services, 6.1.1
replication
compatibility, 5.5.5, 5.6.13.2
interoperability, 5.5.5
rolling upgrades
with Logical Standby Database, 1.5
with Streams, 1.5
rowids
compatibility, 5.6.5.2

S

S, B.3.5
schema objects
compatibility, 5.6.4
scripts
downgrading, 7.4
rerunning, 7.4
upgrading, 3.4.1, 3.4.3, 3.4.3
Server Manager
differences with SQL*Plus
ampersands, B.3.4
blank lines, B.3.2
commands, B.2
comments, B.3.1
COMMIT command, B.3.6
CREATE TYPE command, B.3.5
hyphen continuation character, B.3.3
startup, B.1
syntax, B.3
migrating scripts to SQL*Plus, B
not supported, 4.2.2, B
server parameter file
migrating to, 4.1.6
service naming
Net8, 5.6.14.1
SESSION_CACHED_CURSORS
change in behavior, A.2.1
SESSION_CACHED_CURSORS initialization parameter
compatibility, A.2.1
SET COMPATIBILITY command
SQL*Plus scripts, 6.3
shared structures
interoperability, 5.6.1.2.1
SHARED_POOL_SIZE initialization parameter
changes in behavior, 4.3.1
SORT_AREA_SIZE initialization parameter
compatibility, A.2.10
SORT_DIRECT_WRITES initialization parameter
compatibility, A.2.10
SQL*Plus
differences with Server Manager
ampersands, B.3.4
blank lines, B.3.2
commands, B.2
comments, B.3.1
COMMIT command, B.3.6
CREATE LIBRARY command, B.3.5
CREATE TYPE command, B.3.5
hyphen continuation character, B.3.3
startup, B.1
syntax, B.3
migrating scripts from Server Manager, B
scripts
upgrading, 6.3
standby database
compatibility, 5.6.12.4
upgrading, 4.1.9
STARTUP
compatibility, 5.5.1
static data dictionary views
changes in Oracle Database 10g, A.3
deprecated, A.3.1
obsolete, A.3.2
with columns that may return nulls, A.3.5
with dropped columns, A.3.4
with renamed columns, A.3.3
statistics tables
upgrading, 4.3.7
SYS schema
user-created objects in, 5.6.3.1
SYSDBA
connecting in Pro*C/C++, 5.6.1.3.1
connecting in Pro*COBOL, 5.6.1.3.2

T

tablespaces
compatibility, 5.5.2, 5.6.2
tempfiles
data dictionary information, 5.6.2.2
testing
applications for upgrade, 2.3
developing a plan, 2.1.6
EXPLAIN PLAN, 2.1.6.7
functional for upgrade, 2.1.6.3
integration for upgrading, 2.1.6.4
INTO clause, 2.1.6.7
minimal for upgrade, 2.1.6.2
performance for upgrade, 2.1.6.5
pre-upgrade and post-upgrade, 2.1.6.7
the upgrade process, 2.2
the upgraded test database, 2.3
upgrading results, 4.4
volume/load stress for upgrade, 2.1.6.6
TO_LABEL function
desupported, 5.6.7.1
troubleshooting
upgrades, 3.4.4
tuning
after upgrading, 4.4.1

U

U0800060.SQL script, 3.4.3, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1
U0801070.SQL script, 3.4.3
U0900010.SQL script, 3.4.3
U0902000.SQL script, 3.4.3
Upgrade Information Tool, 3.4.1
upgrade methods
choosing, 2.1.3
copying data, 2.1.3.4
Database Upgrade Assistant, 2.1.3.1
Export/Import, 2.1.3.3
manual upgrade, 2.1.3.2
upgrading
abandoning, 3.4.5
after upgrading, 4
applications, 6
compatibility rules, 6.2.2
options, 6.2.3
relinking, 6.2.2
backup strategy, 2.1.5
character sets, 5.5.3.2
initialization parameters, 3.4.3
listener.ora file, 4.1.8
materialized views, 4.3.4
NCHAR columns, 4.2.1
new administrative procedures, 4.1.12
Oracle Forms applications, 6.4
ORADIM, 3.4.3
parallel execution, 4.3.1
post upgrade actions, 4
queue tables, 4.3.5
Real Application Clusters, 3.1.1
recovery catalog, 4.3.6
rolling upgrades, 1.5
scripts, 3.4.1, 3.4.3, 3.4.3
SQL*Plus scripts, 6.3
standby database, 4.1.9
statistics tables, 4.3.7
testing, 2.1.6
testing results, 4.4
troubleshooting, 3.4.4
tuning after, 4.4.1
U0800060.SQL, 3.4.3, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1, 5.1.1
U0801070.SQL, 3.4.3
U0900010.SQL, 3.4.3
U0902000.SQL, 3.4.3
using the Database Upgrade Assistant, 3.3
when to set the COMPATIBLE initialization parameter, 5.1.1.5
upgrading a database
choosing an upgrade method, 2.1.3
manually, 3.4
analyze the database, 3.4.1
backing up the database, 3.4.2
performing a manual upgrade, 1.1
preparing to, 2.1
role of application developer, 1.1.2
role of database administrator, 1.1.1
using Export/Import, 8.2
using silent mode, 3.3.4
using the Database Upgrade Assistant, 1.1
UROWIDs
interoperability, 5.6.5.2.1
user-created objects
in SYS schema, 5.6.3.1
user-defined datatypes
compatibility, 5.5.4, 5.6.6
interoperability, 5.6.6.1.1
new format, 5.6.6.1
UTLCHN1.SQL script, 5.6.7.2
UTLEXPT1.SQL script, 5.6.7.3

V

varrays
stored as LOBs
compatibility, 5.6.6.3

W

word size
64-bit software, 1.4