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