Index
A B C D E F I J L M N O P R S T U W
Numerics
- 32-bit to 64-bit conversion. See word size
A
- AL24UTFFSS character set
-
- desupported, 5.6.3.3
- applications
-
- client/server configurations
-
- upgrading, 6.2.1
- compatibility, 6.1.1
- linking with newer libraries, 6.2.2.2.1
- 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
- automatic segment-space managed tablespaces
-
- change in compatibility level, 5.5.4
B
- backups
-
- after upgrading, 4.1.1
- preparing a strategy, 2.1.6
C
- CATRELOD.SQL script, 7.4
- CATUPGRD.SQL script, 3.7.3
- change passwords
-
- for oracle-supplied accounts, 4.2.1
- character sets
-
- upgrading the database, 5.6.3.2
- client-server configurations, 1.2.1
- collecting optimizer statistics, C
- command line options
-
- for Database Upgrade Assistant, 3.6.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
-
- applications, 6.1.1
- automatic segment-space managed tablespaces, 5.5.4
- checking for incompatibilities, 7.2
- compatibility level, 5.1.1.3
- COMPATIBLE initialization parameter, 5.1.1
- datafiles, 5.6.2
- datatypes, 5.6.3
- dictionary managed tablespaces, 5.5.3
- downgrading, 5.1.1.1
- initialization parameters, A.2
- object types, 5.5.5
- Oracle Managed Files, 5.5.6
- Oracle OLAP, 5.5.7
- replication, 5.6.5
- STARTUP, 5.6.1
- tablespaces, 5.6.2
- user-defined datatypes, 5.6.4
- 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
- control files
-
- renaming or removing for migration, 3.7.3
- CREATE TYPE command
-
- differences between Server Manager and SQL*Plus, B.3.5
D
- data copying, 2.1.3.4
-
- using Export/Import, 8
- Database Upgrade Assistant
-
- advantages, 2.1.3.1
- command line options, 3.6.2
- registering the database in the listener.ora file, 3.5
- running, 3.6
- silent mode, 3.6.2
- starting, 3.6.1
- database upgrade process
-
- overview, 1.1
- databases
-
- downgrading, 7.4
- datafiles
-
- compatibility, 5.6.2
- datatypes
-
- compatibility, 5.6.3
- 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
- DBMS_STATS package
-
- upgrading statistics tables, 4.1.8
- DBMS_STATS procedure
-
- use when creating a statistics table, C.2
- DBUA. See Database Upgrade Assistant
- deprecated dynamic performance views, A.4.1
- deprecated features
-
- dictionary managed tablespaces, 5.5.3
- Oracle Dynamic Services, 5.5.9
- Oracle Syndication Server, 5.5.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.5.3
- dictionary managed tablespaces
-
- compatibility, 5.5.3
- deprecated, 5.5.3
- downgrading
-
- CATRELOD.SQL, 7.4
- checking for incompatibilities, 7.2
- 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
- environment variables
-
- required for upgrading, 3.7.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
- Forms
-
- upgrading Oracle Forms applications, 6.4
I
- Import utility
-
- data copying, 8
- requirements, 8.1
- incompatibilities
-
- checking for, 7.2
- incompatible data
-
- Export/Import, 8.1.1
- initialization parameters
-
- adjusting for Oracle Database 10g, 3.7.2, 4.2.5
- changes in Oracle Database 10g, A.1
- compatibility, A.2
-
- DB_BLOCK_CHECKSUM, A.2.8
- DB_BLOCK_SIZE, A.2.2
- JOB_QUEUE_PROCESSES, A.2.9
- LOG_CHECKPOINT_TIMEOUT, A.2.10
- O7_DICTIONARY_ACCESSIBILITY, A.2.11
- SESSION_CACHED_CURSORS, A.2.1
- COMPATIBLE, 5.1.1
-
- when to set, 5.1.1.5
- deprecated, A.1.1
- obsolete, A.1.2
- INIT.ORA parameters. See initialization parameters
- installation
-
- Oracle Database 10g software, 3.2
- Oracle9i software, 8.2
- interoperability, 5.2
-
- dictionary managed tablespaces, 5.5.3
- object types, 5.5.5
- Oracle Managed Files, 5.5.6
- Oracle OLAP, 5.5.7
- replication, 5.6.5
J
- JOB_QUEUE_PROCESSES
-
- maximum number of job queue processes, A.2.9
- JOB_QUEUE_PROCESSES initialization parameter
-
- compatibility, A.2.9
L
- listener.ora file
-
- modifying, 3.5
- listeners
-
- modifying with Oracle Net Configuration Assistant, 3.5
- LOG_CHECKPOINT_TIMEOUT
-
- new default value, A.2.10
- LOG_CHECKPOINT_TIMEOUT initialization parameter
-
- compatibility, A.2.10
- logical standby databases
-
- rolling upgrades, 1.5
M
- manual upgrade
-
- advantages, 2.1.3.2
- analyze the database, 3.4.1
- backup the database, 3.7.1
- OCR configuration, 4.2.4
- migrating data
-
- to a different operating system, 3.1.5
- migration
-
- control files, 3.7.3
- multiversioning, 1.2.1
N
- NCHAR columns
-
- upgrading, 4.3.1
- new features
-
- adding after upgrade, 4.1.15
O
- O7_DICTIONARY_ACCESSIBILITY initialization parameter
-
- compatibility, A.2.11
- object types
-
- compatibility, 5.5.5
- interoperability, 5.5.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.3.2
- upgrading applications, 6.2
- OCI applications
-
- upgrading options, 6.2.3
- OFA, 1.3
- opatch utility
-
- rolling upgrades, 1.5
- operating system
-
- migrating data to, 3.1.5
- Optimal Flexible Architecture. See OFA
- optimizer statistics
-
- collecting for dictionary objects, C
- creating a table to collect, C.2
- Oracle Cluster Registry (OCR)
-
- upgrading manually, 4.2.4
- Oracle Data Guard
-
- rolling upgrades, 1.5
- 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.15
- Oracle Dynamic Services
-
- deprecated, 5.5.9
- Oracle home
-
- multiple, 1.2.1.1
- Oracle Managed Files
-
- compatibility, 5.5.6
- interoperability, 5.5.6
- Oracle Net Configuration Assistant, 3.5
- Oracle Net Services
-
- relinking, 6.1.1
- Oracle OLAP
-
- compatibility, 5.5.7
- interoperability, 5.5.7
- Oracle release numbers, 1.2
- Oracle Streams
-
- rolling upgrades, 1.5
- Oracle Syndication Server
-
- deprecated, 5.5.10
- Oracle Universal Installer, 1.1
- oracle-supplied accounts
-
- change passwords, 4.2.1
- ORADIM
-
- downgrading, 7.4
- upgrading, 3.7.3
P
- precompilers
-
- applications
-
- changing, 6.2.3.3.1
- upgrading options, 6.2.3
- upgrading applications, 6.2
- preparing to upgrade, 2.1
-
- collecting optimizer statistics, C
R
- Real Application Clusters
-
- rolling upgrades with opatch, 1.5
- upgrading, 3.1.1
- recovery catalog
-
- upgrading, 4.1.7
- releases
-
- definition, 1.2
- multiple, 1.2.1
- relinking with Oracle Net Services, 6.1.1
- replication
-
- compatibility, 5.6.5
- interoperability, 5.6.5
- rolling upgrades, 1.5
-
- Real Application Clusters and opatch, 1.5
- with logical standby databases and SQL Apply, 1.5
- with Streams, 1.5
- running multiple Oracle releases on the same computer, 1.2.1
S
- S, B.3.5
- schemas
-
- collecting system component statistics, C.1
- scripts
-
- downgrading, 7.4
- rerunning, 7.4
- upgrading, 3.4.1, 3.7.3, 3.7.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.3.2, B
- server parameter file
-
- migrating to, 4.2.2
- SESSION_CACHED_CURSORS
-
- change in behavior, A.2.1
- SESSION_CACHED_CURSORS initialization parameter
-
- compatibility, A.2.1
- 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
- STARTUP
-
- compatibility, 5.6.1
- static data dictionary views
-
- changes in Oracle Database 10g, A.3
- deprecated, A.3.1
- obsolete, A.3.2
- with dropped columns, A.3.4
- with renamed columns, A.3.3
- statistics
-
- collecting for dictionary objects, C
- collecting for system component schemas, C.1
- creating a table for, C.2
- importing with DBMS_STATS PL/SQL procedure, C.2
- statistics tables
-
- upgrading, 4.1.8
- system component schemas
-
- collecting statistics for, C.1
T
- tablespaces
-
- compatibility, 5.6.2
- testing
-
- applications for upgrade, 2.3
- developing a plan, 2.1.5
- EXPLAIN PLAN, 2.1.5.7
- functional for upgrade, 2.1.5.3
- integration for upgrading, 2.1.5.4
- INTO clause, 2.1.5.7
- minimal for upgrade, 2.1.5.2
- performance for upgrade, 2.1.5.5
- pre-upgrade and post-upgrade, 2.1.5.7
- the upgrade process, 2.2
- the upgraded test database, 2.3
- volume/load stress for upgrade, 2.1.5.6
- troubleshooting
-
- upgrades, 3.7.4
U
- 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.7.5
- after upgrading, 4
- applications, 6
-
- compatibility rules, 6.2.2
- options, 6.2.3
- relinking, 6.2.2
- backup strategy, 2.1.6
- CATUPGRD.SQL, 3.7.3
- character sets, 5.6.3.2
- initialization parameters, 3.7.2
- NCHAR columns, 4.3.1
- new administrative procedures, 4.1.16
- Oracle Forms applications, 6.4
- ORADIM, 3.7.3
- post upgrade actions, 4
- Real Application Clusters, 3.1.1
- recovery catalog, 4.1.7
- rolling upgrades, 1.5
- scripts, 3.4.1, 3.7.3, 3.7.3
- SQL*Plus scripts, 6.3
- statistics tables, 4.1.8
- testing, 2.1.5
- troubleshooting, 3.7.4
- using the Database Upgrade Assistant, 3.6
- when to set the COMPATIBLE initialization parameter, 5.1.1.5
- upgrading a database
-
- choosing an upgrade method, 2.1.3
- manually, 3.7
-
- analyze the database, 3.4.1
- backing up the database, 3.7.1
- performing a manual upgrade, 1.1
- preparing to, 2.1
- using Export/Import, 8.2
- using silent mode, 3.6.2
- using the Database Upgrade Assistant, 1.1
- user-defined datatypes
-
- compatibility, 5.6.4
W
- word size
-
- 64-bit software, 1.4