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