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, 9-53
- 32-bit to 64-bit conversion. See word-size
A
- active transactions
- read-only tablespaces, 9-29
- Ada. See SQL*Module for Ada
- Advanced Queuing
- compatibility, 9-17, 9-37
- message streaming, 9-38
- privileges, 9-37
- rule based subscriptions, 9-38
- interoperability, 9-37
- sender's ID column, 9-37
- removing incompatibilities
- downgrading, 14-20
- upgrading, 7-37
- agent self-registration
- compatibility, 9-16
- AL24UTFFSS character set
- desupported in Oracle9i, 4-8, 5-8, 7-3
- ALTER DATABASE CONVERT statement, 4-3, 4-32
- rerunning, A-9
- ALTER DATABASE OPEN RESETLOGS statement, 4-4, 4-32
- ALTER DATABASE RESET COMPATIBILITY statement, 9-8, 9-9
- ALTER DATABASE RESET LOGS statement, 4-9, 5-8
- ALTER TABLE statement
- bitmap index invalidation, 9-30
- ANALYZE TABLE VALIDATE STRUCTURE statement
- change in release 8.1, 9-22
- applications
- application context
- compatibility, 9-16
- client/server configurations
- upgrading, 10-3
- compatibility, 9-20, 10-2
- development
- role during migration, 2-7
- external initialized context
- compatibility, 9-11
- index-organized tables
- compatibility, 9-21
- interoperability, 9-20
- linking with newer libraries, 10-6
- OCI
- compatibility, 9-22
- interoperability, 9-22
- physical ROWIDs and UROWIDs, 9-21
- physical ROWIDs in version 8, 12-2
- PL/SQL
- compatibility, 9-24
- interoperability, 9-24
- precompiler
- compatibility, 9-23
- interoperability, 9-23
- running against older server, 10-5
- upgrading, 10-1
- compatibility rules, 10-4
- options, 10-7
- relinking rules, 10-4
- AQ. See Advanced Queuing
- AQ_TM_PROCESSES initialization parameter, 7-20
- archive log destination parameters
- new in release 8.1, B-15
- archived redo logs
- analyzing
- from other databases, 9-47
- compatibility, 9-46
- rearchiving, 9-46
- archiving
- error detection behavior, 9-46
- AUDIT_TRAIL initialization parameter
- migration, A-4
- Automatic segment-space managed tablespaces
- compatibility, 9-9
- automatic undo managed tablespaces
- compatibility, 9-9
- AUTOMATIC_IPC networking parameter, F-4
- autonomous transactions
- compatibility, 9-17
B
- backups
- after migration or upgrade, 8-2
- before migration, 4-26
- compatibility, 9-16, 9-43
- EBU, 9-44
- preparing a strategy for migration, 3-22
- Recovery Manager and EBU, 9-44
- backward compatibility
- of ROWIDs, 12-8
- bitmap indexes
- invalidations, 9-30
- during migration, 8-15
- bitmap secondary indexes
- dropping from index-organized tables, 14-4
- blocks
- block size
- DB_BLOCK_SIZE initialization parameter, 4-6, 5-6
- minimums for migration, 4-6, 5-6
- bulk binds
- compatibility, 9-17
C
- C language
- C call specifications
- compatibility, 9-17
- cache reads
- for LOBS
- discontinue using, 14-16
- CALL statement
- compatibility, 9-17
- CartridgeServices
- installing, 8-5
- CATALOG5.SQL script
- obsolete, 9-30
- CATALOG6.SQL script
- obsolete, 9-30
- CATALOG.SQL script, 4-4, 4-33, 7-23, 13-12
- CATCLUST.SQL script, 4-33, 7-35
- CATEXP7.SQL script, 9-52
- downgrading to Oracle7, 15-5
- CATPARR.SQL script, 13-12
- CATPROC.SQL script, 4-4, 4-33, 7-23, 13-12
- CATREP.SQL script, 13-12
- change passwords
- of oracle-supplied accounts, 8-2
- CHAR
- maximum size
- change, 9-20
- CHARACTER keyword
- behavior differences, 9-27
- character sets
- migrating the database, 4-8, 5-8
- upgrading the database, 7-2
- varying-width
- CLOBs and NCLOBs, 9-31
- CHECK_ONLY
- Migration utility option, 4-18, 4-21
- ckpdom.ora file, F-23
- ckpreg.ora file, F-23
- ckptop.ora file, F-23
- client-server configurations, 1-4
- CLOBs
- compatibility, 9-31
- clusters
- cluster tables
- copying data, 3-16
- collection locators
- compatibility, 9-15
- collections
- collection columns
- user-specified storage, 9-35
- collection locators
- compatibility, 9-35
- command line
- command-line options
- Migration utility, 4-17
- commands
- COMMIT FORCE, 4-9, 5-8
- ROLLBACK FORCE, 4-9, 5-8
- comments
- differences between Server Manager and SQL*Plus, 11-10
- COMMIT command
- differences between Server Manager and SQL*Plus, 11-16
- COMMIT FORCE command, 4-9, 5-8
- COMMIT keyword
- behavior differences, 9-27
- COMMUNITY parameter, F-4
- compatibility, 9-1
- 8.1.0 compatibility level
- features requiring, 9-12
- 9.0.0 compatibility level
- features requiring, 9-9
- Advanced Queuing, 9-17, 9-37
- agent self-registration, 9-16
- ALTER DATABASE RESET COMPATIBILITY statement, 9-8
- ANALYZE VALIDATE STRUCTURE statement, 9-22
- application context, 9-16
- applications, 9-20, 10-2
- index-organized tables, 9-21
- physical ROWIDs and UROWIDs, 9-21
- archived redo logs, 9-46
- backup, 9-16, 9-43
- change in maximum size
- CHAR, 9-20
- RAW, 9-20
- VARCHAR2, 9-20
- checking level for features, 9-9
- compatibility level, 9-6
- COMPATIBLE initialization parameter, 9-2
- CREATE TABLE behavior change, 9-37
- data dictionary, 9-29
- database resource manager, 9-17
- datafiles, 9-28
- datatypes, 9-31
- date columns in dynamic performance views, 9-32
- DBMS_REPAIR package, 9-17
- DISABLE VALIDATE constraints, 9-17
- downgrading, 9-6
- Export/Import, 9-51
- extensible optimizer, 9-17
- external initialized context, 9-11
- fine-grained access control, 9-16
- Heterogeneous Services agents, 9-49
- indexes
- key compression, 9-14
- initialization parameters, B-9
- LOB index clause, 9-31
- LOBs, 9-10, 9-15, 9-31
- CLOBS and NCLOBs, 9-31
- LogMiner, 9-47
- materialized views, 9-12, 9-18, 9-48
- nested tables, 9-35
- NLS and NCHAR environment variables, 9-33
- n-tier authentication and authorization, 9-16
- OCI, 9-22
- link line, 9-22
- thread safety, 9-22
- optimization, 9-39
- optimizer plan stability, 9-17
- Oracle Media Management API, 9-16
- Oracle Parallel Server
- instance affinity for jobs, 9-15
- packages
- DBMS_LOB, 9-38
- DBMS_REPAIR, 9-38
- partitioning, 9-10, 9-14
- PL/SQL, 9-24
- integrated SQL analysis, 9-25
- PLSQL_V2_COMPATIBILITY initialization parameter, 9-25
- precompilers, 9-23
- read-only tablespaces, 9-29
- recovery, 9-16, 9-43
- fast-start rollback, 9-16
- REFs, 9-15
- removing incompatibilities, 13-2, 14-1
- replication, 9-11, 9-16, 9-48
- resetting for database, 13-3
- ROWID issues, 12-8
- rowids, 9-32
- schema objects, 9-10, 9-14, 9-30
- collection locators, 9-15
- drop column, 9-14
- extensible indexing, 9-14
- external tables, 9-10
- function-based indexes, 9-14
- index segment coalesce, 9-14
- indexes, 9-10, 9-14
- index-organized tables, 9-10, 9-14
- length semantics, 9-10
- nested tables, 9-15
- online index (re)build, 9-14
- single-table hash clusters, 9-10, 9-14
- temporary tables, 9-14
- type evolution, 9-11
- scripts
- UTLCHN1.SQL, 9-17, 9-36
- UTLEXPT1.SQL, 9-17, 9-36
- Spatial, 9-18
- SQL and PL/SQL, 9-12, 9-17
- autonomous transactions, 9-17
- bulk binds, 9-17
- C call specifications, 9-17
- CALL statement, 9-17
- native dynamic SQL, 9-17
- nested transactions, 9-12
- NOCOPY parameter passing mode, 9-17
- parallel table functions, 9-12
- pipelined table functions, 9-12
- standby database, 9-45
- STARTUP, 9-27
- summary management, 9-12, 9-18
- tablespaces, 9-9, 9-13, 9-28
- automatic segment-space managed, 9-9
- automatic undo managed, 9-9
- default temporary tablespaces, 9-9
- locally managed tablespaces, 9-13
- online read-only tablespaces, 9-13
- transportable tablespaces, 9-13
- triggers, 9-17
- type inheritance, 9-11
- UROWIDs, 9-15
- user-defined aggregate functions, 9-11
- user-defined datatypes, 9-34
- user-defined object identifiers, 9-15
- varrays, 9-11, 9-15
- stored as LOBs, 9-35
- view constraints, 9-12
- Visual Image Retrieval, 9-18
- compatibility level
- checking, 13-2
- resetting, 9-9
- COMPATIBLE initialization parameter, 9-2
- 8.1.0 setting
- features requiring, 9-12
- 9.0.0 setting
- features requiring, 9-9
- checking the setting, 9-6
- database structures, 9-4
- setting, 9-7
- when to set, 9-7
- concurrent access, 3-18
- concurrent users, 3-19
- CONNECT_TIMEOUT_listener_name networking parameter, F-4
- connections
- load balancing in Net8, 9-50
- local and remote, 3-18
- with multithreaded shared server, 3-18
- connect-time failover
- GLOBAL_DBNAME networking parameter in listener.ora, F-14
- ConText
- migrating to Oracle Text, 4-8, 5-7
- control files
- renaming or removing for migration, 4-25, 7-18, 13-9
- copying data
- large cluster tables, 3-16
- migration method, 3-15
- space requirements, 3-16
- CREATE LIBRARY command
- differences between Server Manager and SQL*Plus, 11-16
- CREATE TABLE
- AS subquery
- behavior change, 9-37
- behavior change, 9-37
- CREATE TYPE command
- differences between Server Manager and SQL*Plus, 11-16
- cursors
- number of open, 3-19
D
- data definition conversion
- Import utility, 3-14
- data dictionary
- compatibility, 9-29
- protection, 9-30
- database
- failure to open after removing incompatibilities, 9-9
- database administrator
- role during migration, 2-7
- database resource manager
- compatibility, 9-17
- databases
- backing up for migration, 4-26
- downgrading, 13-4
- test migration results, 8-16
- tuning after migration, 8-17
- datafiles
- compatibility, 9-28
- offline during migration, 4-4
- datatypes
- compatibility, 9-31
- internal
- added in Oracle9i, E-2
- added in version 8, E-3
- date constraints
- checking for bad, 8-9
- DB_BLOCK_CHECKSUM
- new default value, B-9
- DB_BLOCK_CHECKSUM initialization parameter
- compatibility, B-9
- DB_BLOCK_SIZE initialization parameter
- migration, 4-6, 5-6
- DB_DOMAIN initialization parameter, F-14
- compatibility, B-11
- DB_NAME initialization parameter, F-14
- DBMS
- precompiler command line option, 9-24
- DBMS_APPLICATION_INFO package
- SET_SESSION_LONGOPS procedure
- syntax change, 9-38
- DBMS_LOB package
- NOCOPY syntax and compatibility, 9-38
- DBMS_REPAIR package
- compatibility, 9-17, 9-38
- DBMS_ROWID package, 12-3
- DBMS_STATS package
- upgrading statistics tables, 7-39
- DBMSLOB.SQL script
- compatibility, 9-38
- DBNAME
- Migration utility option, 4-18
- DBSNMP_START command, F-6
- DBSNMP_STATUS command, F-6
- DBSNMP_STOP command, F-6
- DEC keyword
- behavior differences, 9-27
- default temporary tablespaces
- compatibility, 9-9
- definitions. See terminology
- DEGREE keyword
- in PARALLEL clause, 9-39
- deinstalling, 1-13
- Developer/2000 Applications
- upgrading, 10-12
- DISABLE VALIDATE constraints
- compatibility, 9-17
- distributed databases
- preparing to migrate, 4-9, 5-8
- DML_LOCKS initialization parameter
- compatibility, B-11
- documentation
- roadmap for Migration utility, 4-2
- roadmap for Oracle Data Migration Assistant, 5-2
- DOMAIN_HINT command, F-6
- downgrading
- Advanced Queuing, 14-20
- CATALOG.SQL, 13-12
- CATPROC.SQL, 13-12
- Java, 13-12, 13-13
- locally managed tablespaces, 14-16
- Oracle9i Real Application Clusters, 13-12
- ORADIM, 13-8
- procedure for, 13-4
- removing incompatibilities, 13-2
- automatic segment-space managed tablespaces, 14-3
- automatic undo managed tablespaces, 14-4
- bitmap secondary indexes on index-organized tables, 14-4
- cache reads for LOBs, 14-16
- external tables, 14-4
- global users, 14-19
- indexes with large keys, 14-5
- LOBs in partitioned index-organized tables, 14-11
- migrated tablespaces, 14-15
- non-final types, 14-13
- parallel table functions, 14-14
- partitioning, 14-6
- pipelined table functions, 14-13
- SQL and PL/SQL, 14-13
- subtypes, 14-13
- transient segments, 14-15
- triggers, 14-18
- type evolution, 14-12
- user-defined aggregate functions, 14-12
- varrays in partitioned index-organized tables, 14-13
- view constraints, 14-14
- replication, 13-12
- regenerating, 13-14
- resetting database compatibility, 13-3
- scripts, 13-5
- errors while running, 1-11
- JISD817.SQL, 13-13
- JSPD817.SQL, 13-13
- JVMD815.SQL, 13-12
- JVMD816.SQL, 13-13
- JVMD817.SQL, 13-13
- rerunning, 13-6
- XMLD817.SQL, 13-13
- to Oracle7, 15-1
- alternative methods, 15-6
- CATEXP7.SQL script, 15-5
- to release 8.0, 15-1
- alternative methods, 15-3
- to release 8.1, 13-1
- to release 8.1.5, 14-14
- to release 8.1.6, 14-3
- to release 8.1.7, 14-3
- triggers, 14-18
- view constraints, 14-14
- XML, 13-13
- drop column
- compatibility, 9-14
- DTYCHR type, 12-10
- DUMP_TNSNAMES command, F-18
- Dynamic Discovery Option for Oracle Names
- migration issues, F-18
- dynamic performance views
- added in Oracle9i, D-2
- added in version 8, D-8
- changed in Oracle9i
- dropped columns, D-5
- changed in version 8
- added columns, D-13
- dropped columns, D-14
- renamed columns, D-15
- changes in Oracle9i, D-1
- date columns
- compatibility, 9-32
- obsolete in Oracle9i, D-7
- obsolete in version 8, D-16
- renamed in Oracle9i, D-3
E
- EBU
- backup management, 9-44
- enterprise user management
- interoperability, 9-43
- environment variables
- compatibility
- NCHAR and NLS, 9-33
- ORA_NLS32, 9-33
- ORA_NLS33, 4-19, 9-33
- required for migration, 4-20, 4-23
- required for upgrading, 7-21
- errors
- during migration or upgrade. See troubleshooting
- Export utility
- migration, 3-10, 6-1
- Oracle9i using CATEXP7.SQL, 15-5
- requirements for migration, 6-2
- Export/Import
- advantages and disadvantages, 3-10
- basic steps for migration, 6-2
- benefits for migration, 3-13
- compatibility, 9-51
- data definition conversion, 3-14
- effects on migrated databases, 3-12
- incompatible data, 9-52
- limitations for migration, 3-13
- migration steps using, 6-3
- scripts
- CATEXP7.SQL, 9-52
- time requirements for migration, 3-14
- Trusted Oracle, 6-3
- extended ROWIDs, 12-8
- extensible indexing
- compatibility, 9-14
- external tables
- compatibility, 9-10
- dropping for downgrading, 14-4
F
- FAILOVER networking parameter, F-10
- failure to open database after removing incompatibilities, 9-9
- FALSE keyword
- behavior differences, 9-27
- fast-start parallel recovery
- compatibility, 9-45
- fast-start rollback
- compatibility, 9-16, 9-45
- feature compatibility, 9-9
- features
- new features, 9-9
- requiring migration, G-20
- filenames
- normalize, 8-13
- fine-grained access control
- compatibility, 9-16
- Forms
- upgrading Oracle Forms applications, 10-12
- function-based indexes
- compatibility, 9-14
- invalidations
- during upgrade, 8-17
- functions
- SQL
- added in Oracle9i, E-2
- added in version 8, E-4
G
- generating
- replication support and migration, G-5, G-14
- global database name, F-14
- global users
- downgrading, 14-19
- GLOBAL_DBNAME networking parameter, F-14
- glossary. See terminology
- GREATEST_LB function
- desupported, 9-35
H
- Heterogeneous Services
- agents
- compatibility, 9-49
- interoperability, 9-49
- multithreaded, 9-49
I
- identifying incompatibilities
- UTLINCMP.SQL, 14-2
- Identix authentication, F-2
- Import utility
- data definition conversion, 3-14
- migration, 3-10, 6-1
- requirements for migration, 6-2
- incompatibilities
- removing, 13-2, 14-1
- incremental migration, G-7
- index segment coalesce
- compatibility, 9-14
- indexes
- bitmap, 8-15
- compatibility, 9-10, 9-14
- function-based, 8-17
- key compression, 9-14
- on physical ROWID, 12-10
- rebuilding
- physical ROWIDs, 12-10
- index-organized tables
- compatibility, 9-10, 9-14
- removing hash partitions from, 14-6
- initialization parameters
- added in Oracle9i, B-2
- added in version 8, B-4
- adjusting for Oracle9i, 4-29, 5-12, 7-19, 8-12
- AQ_TM_PROCESSES, 7-20
- archive log destination
- switching to new, B-15
- changes in Oracle9i, B-1
- compatibility, B-9
- DB_BLOCK_CHECKSUM, B-9
- DB_DOMAIN, B-11
- DML_LOCKS, B-11
- LOG_CHECKPOINT_TIMEOUT, B-11
- O7_DICTIONARY_ACCESSIBILITY, B-11
- ORACLE_TRACE_ENABLE, B-9
- SERIALIZABLE, B-10
- SORT_AREA_SIZE, B-10
- SORT_DIRECT_WRITES, B-10
- COMPATIBLE, 9-2
- JOB_QUEUE_PROCESSES, 4-30, 5-13, 7-20
- LARGE_POOL_SIZE
- parallel execution allocation, B-12
- obsolete in Oracle9i, B-3
- obsolete in version 8, B-6
- REMOTE_LOGIN_PASSWORDFILE, 7-20
- renamed in Oracle9i, B-3
- renamed in version 8, B-6
- SHARED_POOL_SIZE
- parallel execution allocation, B-12
- INIT.ORA parameters. See initialization parameters
- installation
- Oracle9i software, 4-15, 5-15, 6-3
- INSTANCE_NAME initialization parameter, F-11
- INSTANCES keyword
- removed from PARALLEL clause, 9-39
- INT keyword
- behavior differences, 9-27
- interMedia
- upgrading, 7-31
- internal datatypes
- added in Oracle9i, E-2
- added in version 8, E-3
- interoperability, 9-1, 9-18
- Advanced Queuing, 9-37
- applications, 9-20
- Heterogeneous Services agents, 9-49
- native dynamic SQL, 9-36
- OCI, 9-22
- Oracle7 clients, 9-22
- shared structures, 9-22
- PL/SQL, 9-24
- precompilers, 9-23
- type evolution, 9-34
- UROWIDs, 9-33
- user-defined datatypes, 9-35
J
- Java
- compatibility, 9-13
- downgrading, 13-12, 13-13
- installing CartridgeServices, 8-5
- installing ODCI, 8-5
- installing Oracle Change Data Capture, 8-5
- installing SQLJ, 8-5
- installing Summary Advisor, 8-5
- upgrading, 7-25, 7-26, 7-29, 7-31
- JISD817.SQL script, 13-13
- JISU815.SQL script, 7-29
- JISU816.SQL script, 7-29
- JISU817.SQL script, 7-29
- JOB_QUEUE_PROCESSES initialization parameter, 4-30, 5-13, 7-20
- JServer
- upgrading, 7-25
- JSPD817.SQL script, 13-13
- JSPU815.SQL script, 7-31
- JSPU816.SQL script, 7-31
- JSPU817.SQL script, 7-31
- JVMD815.SQL script, 13-12
- JVMD816.SQL script, 13-13
- JVMD817.SQL script, 13-13
- JVMU815.SQL script, 7-26
- JVMU816.SQL script, 7-26
- JVMU817.SQL script, 7-26
K
- keywords
- behavior differences, 9-27
L
- large files
- operating system dependencies, 9-53
- large key indexes
- removing, 14-5
- Large Objects. See LOBs
- LARGE_POOL_SIZE initialization parameter
- changes in behavior, 8-10
- parallel execution allocation, B-12
- LEAST_UB function
- desupported, 9-35
- length semantics
- compatibility, 9-10
- Listener Control utility
- SET CONNECT_TIMEOUT, F-6
- SHOW CONNECT_TIMEOUT, F-6
- unsupported commands
- DBSNMP_START, F-6
- DBSNMP_STATUS, F-6
- DBSNMP_STOP, F-6
- SET USE_PLUGANDPLAY, F-6
- SHOW USE_PLUGANDPLAY, F-6
- listener.ora file
- migrating, F-14
- modifying after migration, 8-10
- modifying after upgrading, 8-10
- parameters
- GLOBAL_DBNAME, F-14
- ORACLE_HOME, F-14
- SID_NAME, F-14
- unsupported parameters
- CONNECT_TIMEOUT_listener_name, F-4
- PRESPAWN_DESC, F-5
- PRESPAWN_LIST, F-5
- PRESPAWN_MAX, F-5
- USE_PLUG_AND_PLAY_listener_name, F-5
- upgrading, F-14
- listeners
- configuring for Oracle Enterprise Manager, F-14
- global database name, F-14
- Oracle System Identifier, F-14
- SID, F-14
- load balancing
- Net8, 9-50
- LOAD_BALANCE networking parameter, F-10
- LOAD_TNSNAMES command, F-19, F-22
- LOB datatype
- copying from LONG, 8-7
- LOB index clause
- compatibility, 9-31
- LOBs
- compatibility, 9-10, 9-15, 9-31
- removing from partitioned index-organized tables, 14-11
- local connections
- multithreaded shared servers, 3-18
- locally managed tablespaces
- compatibility, 9-13
- locks
- DML lock limit, DML_LOCKS, B-11
- LOG_CHECKPOINT_TIMEOUT
- new default value, B-11
- LOG_CHECKPOINT_TIMEOUT initialization parameter
- compatibility, B-11
- LogMiner
- compatibility, 9-47
- LONG datatype
- copying to LOB, 8-7
M
- master sites
- incremental migration of, G-12
- migration, G-4
- materialized views
- compatibility, 9-12, 9-18, 9-48
- upgrading, 7-36
- memory requirements
- concurrent access, 3-18
- migration, 3-16, 4-5, 5-5
- migprep utility
- running, 4-18
- MIGRATE user
- avoid, 4-12, 5-11
- MIGRATE.BSQ script, 4-26
- migrated tablespaces
- correcting transient segments, 14-15
- removing migrated tablespaces, 14-15
- migration
- abandoning, 4-35, 5-24
- after migrating, 8-1, 8-15
- ALTER DATABASE CONVERT statement, 4-3, 4-32
- rerunning, A-9
- ALTER DATABASE OPEN RESETLOGS statement, 4-4, 4-32
- AUDIT_TRAIL initialization parameter, A-4
- avoiding common problems, 3-20
- backup strategy, 3-22
- block size minimums, 4-6, 5-6
- character set, 4-8, 5-8
- choosing a method, 3-3
- control files, 4-25, 7-18, 13-9
- copying data, 3-15
- definition, 1-3
- distributed database considerations, 4-9, 5-8
- dynamic performance views, D-1
- exclusive password file, A-8
- Export/Import, 3-10
- steps, 6-2
- features requiring, G-20
- incremental, G-7
- initialization parameters, 4-29, 5-12, B-1
- listener.ora file, 8-10
- master sites, G-4
- memory requirements, 3-16, 4-5, 5-5
- methods
- choosing, 3-3
- migprep utility, 4-18
- MIGRATE user, avoid, 4-12, 5-11
- MIGRATE.BSQ script, 4-26
- Migration utility, 3-6
- NCHAR and NLS, 9-33
- new administrative procedures, 8-12
- obsolete replication procedures, G-22
- offline datafiles, 4-4
- offline tablespaces, 4-11, 5-10
- OPTIMAL setting for SYSTEM rollback segment, A-5
- Oracle Data Migration Assistant, 3-8
- Oracle9i Real Application Clusters, 4-7
- rolling upgrade, 1-13
- ORADIM, 4-24, 7-18
- OUTLN user, avoid, 4-11, 5-11
- overview for replication, G-2
- overview of steps, 2-2
- parallel execution, 8-10
- post migration, 8-1, 8-15
- post-migration actions, 8-1, 11-1
- prepare the Oracle7 source database, 4-9, 5-9
- Windows platforms, 4-13, 5-13
- preparing to migrate, 3-2
- read-only tablespaces, 4-4
- replication, 4-7
- role of application developer, 2-7
- role of database administrator, 2-7
- rollback segments, 4-4
- ROWID compatibility, 12-8
- rowids, 12-1
- FAQ, 12-9
- scripts
- CATALOG.SQL, 4-4, 4-33
- CATCLUST.SQL, 4-33
- CATPROC.SQL, 4-4, 4-33
- errors while running, 1-11
- rerunning, 4-33, 5-22
- U0703040.SQL, 4-33
- UTLRP.SQL, 4-33, 5-22
- snapshot sites, G-9
- space requirements, 3-16, 4-5, 5-5
- SQL*Net requirement
- Windows platforms, 4-13, 5-13
- standby database, 8-10
- static data dictionary views, C-1
- system requirements, 3-16
- SYSTEM tablespace, A-4
- temporary tablespace, A-4
- terminology, 1-2
- testing, 3-22
- testing results, 8-16
- troubleshooting, A-1
- ALTER DATABASE CONVERT statement, A-6
- AUDIT_TRAIL initialization parameter, A-4
- database name mismatch, A-9
- datafile version integrity, A-10
- Migration utility error messages, A-11
- missing convert file, A-7
- MULTIPLIER option, A-6
- NOMOUNT database start mode, A-7
- OPTIMAL setting, A-5
- Oracle7 control file, A-7
- password file, A-8
- running the Migration utility, A-3
- running the Oracle Data Migration Assistant, A-3
- scripts run long, A-11
- SYSTEM tablespace, A-4
- temporary tablespace, A-4
- tuning after, 8-17
- upgrading to primary key snapshots, G-17
- Migration Assistant. See Oracle Data Migration Assistant
- Migration utility
- advantages and disadvantages, 3-6
- command-line options, 4-17
- differences from the Oracle Data Migration Assistant, 3-9
- documentation roadmap, 4-2
- errors and messages, A-11
- migrating to a different operating system, 4-8
- MULTIPLIER option, A-6
- options
- CHECK_ONLY, 4-18, 4-21
- DBNAME, 4-18
- MULTIPLIER, 4-18
- NEW_DBNAME, 4-18
- NO_SPACE_CHECK, 4-18
- PFILE, 4-18
- SPOOL, 4-18
- overview, 4-3
- privileges required, 4-20
- running, 4-22
- on UNIX, 4-22
- on Windows platforms, 4-24
- space required for SYSTEM tablespace, 4-5
- SYSTEM tablespace, 3-6
- using, 4-20
- MTS. See multi-threaded server
- MULTIPLIER
- Migration utility option, 4-18, A-6
- multi-threaded server
- shared, 3-18
- shared and local/remote connections, 3-18
- multiversioning, 1-4
N
- NAMES_DID table, F-16
- NAMES_DOM table for Oracle Names, F-16
- NAMES.ADMIN_REGION networking parameter, F-17, F-18
- NAMES.DEFAULT_DOMAIN networking parameter, F-4
- NAMES.DEFAULT_ZONE networking parameter, F-4
- NAMES.DOMAIN_HINTS networking parameter, F-6
- NAMES.DOMAINS networking parameter, F-16
- namesini.sql script for Oracle Names, F-24
- NAMES.NDS.NAME.CONTEXT networking parameter, F-4
- names.ora file
- unsupported parameters
- NAMES.DOMAIN_HINTS, F-6
- NAMES.USE_PLUG_AND_PLAY, F-5
- NAMES.PREFERRED_SERVERS networking parameter, F-4
- namesupg.sql script for Oracle Names, F-16, F-18, F-21, F-24
- NAMES.USE_PLUG_AND_PLAY networking parameter, F-5
- national character set
- in Oracle8i, 9-33
- native dynamic SQL
- compatibility, 9-17
- interoperability, 9-36
- NCHAR
- migration, 9-33
- use in Oracle8i, 9-33
- NCHAR and NLS environment variables
- compatibility, 9-33
- NCHAR columns
- upgrading, 8-3
- NCLOBs
- compatibility, 9-31
- nested tables
- compatibility, 9-15, 9-35
- nested transactions
- compatibility, 9-12
- Net8
- coexistence issues, F-7 to F-9
- Oracle9i databases, F-7
- using SERVICE_NAME networking parameter, F-7
- using SID networking parameter, F-8
- connection load balancing, 9-50
- service naming, 9-50
- SID networking parameter, F-8
- upgrading to Oracle Names release 1 (9.0.1), F-15
- upgrading to Oracle Net Services, F-11 to F-14
- configuration files, F-12
- listener.ora file, F-14
- software on client, F-12
- software on server, F-12
- tnsnames.ora file, F-13
- Net8 OPEN, F-2
- new features
- adding after migration or upgrade, 8-12
- requiring 9.0.0 compatibility, 9-9
- NEW_DBNAME
- Migration utility option, 4-18
- NLS
- migration, 9-33
- NLS and NCHAR environment variables
- compatibility, 9-33
- NLS_LANG environment variable
- compatibility, 9-33
- nmcbild.sql script, F-20
- nmcrgrnt.sql script, F-20
- NMO_INFORMATION table for Oracle Names, F-17
- NO_SPACE_CHECK
- Migration utility option, 4-18
- NOCOPY parameter passing mode
- compatibility, 9-17
- Novell Directory Services (NDS)
- authentication, F-2
- external naming, F-2
- n-tier authentication and authorization
- compatibility, 9-16
- NUMERIC keyword
- behavior differences, 9-27
O
- O7_DICTIONARY_ACCESSIBILITY initialization parameter
- compatibility, 9-30
- O7_DICTIONARY_ACCESSIBILITY parameter
- compatibility, B-11
- obsolete replication procedures, G-22
- OCI
- applications
- changing to use Oracle9i, 10-10
- compatibility, 9-22
- batch error mode, 9-23
- client notification, 9-13, 9-23
- link line, 9-22
- LISTEN call and AQ, 9-23
- thread safety, 9-22
- interoperability, 9-22
- Oracle7 clients, 9-22
- shared structures, 9-22
- OCIChangePassword call, 9-42
- OCISessionBegin call, 9-42
- upgrading applications to Oracle9i, 10-3
- OCI applications
- upgrading options, 10-7
- ODCI
- installing, 8-5
- OFA, 1-11
- offline datafiles
- migration, 4-4
- OLON calls
- obsolete, 9-22
- OLQP, 3-19
- OLSU817.SQL script, 7-34
- OLTP, 3-19
- online index (re)build
- compatibility, 9-14
- online read-only tablespaces
- compatibility, 9-13
- operating system
- migrating to a different, 4-8, 5-7
- OPS. See Oracle9i Real Application Clusters
- Optimal Flexible Architecture. See OFA
- OPTIMAL setting for SYSTEM rollback segment
- migration, A-5
- optimization
- compatibility, 9-39
- extensible optimizer, 9-17
- optimizer plan stability, 9-17
- optimizer
- plan stability
- compatibility, 9-17
- options
- deinstalling, 1-13
- for Migration utility, 4-17
- ORA_NLS32 environment variable
- compatibility, 9-33
- ORA_NLS33 environment variable, 4-19
- compatibility, 9-33
- Oracle Advanced Queuing. See Advanced Queuing
- Oracle AQ. See Advanced Queuing
- Oracle Call Interface. See OCI
- Oracle Change Data Capture
- installing Java classes, 8-5
- Oracle Data Migration Assistant
- advantages and disadvantages, 3-8
- differences from the Migration utility, 3-9
- documentation roadmap, 5-2
- migrating to a different operating system, 5-7
- Oracle9i Real Application Clusters
- does not support migration, 3-10
- does not support upgrading, 7-8
- overview, 5-4
- restrictions, 5-4
- running, 5-20, 7-8, 7-15
- space required for SYSTEM tablespace, 5-5
- Oracle Enterprise Manager
- static service information in listener.ora file, F-14
- Oracle home
- multiple, 1-5
- Oracle Label Security
- upgrading, 7-34
- Oracle Media Management API
- compatibility, 9-16
- proxy copy requirement, 9-47
- Oracle Names
- coexistence issues, F-9
- migrating
- ckreg.ora file to cktop.ora file, F-23
- Oracle Names version 2 using a database, F-16
- ROSFILES, F-20
- ROSFILES to a tnsnames.ora file, F-21
- ROSFILES to Oracle Names tables in database, F-20
- migrating to release 1 (9.0.1), F-15
- NAMES_DID table for Oracle Names, F-16
- NAMES_DOM table, F-16
- NAMES.ADMIN_REGION parameter in names.ora file, F-17, F-18
- NAMES.DOMAINS parameter in names.ora file, F-16
- namesini.sql script, F-24
- namesupg.sql script, F-16, F-18, F-21, F-24
- NMO_INFORMATION table, F-17
- Oracle Names Control utility
- commands
DUMP_TNSNAMES command, F-18LOAD_TNSNAMES, F-19, F-22REORDER_NS, F-23
- Oracle Names version 2 with Dynamic Discovery Option, F-18
- Oracle Net Manager
- discovering Oracle Names servers, F-23
- loading tnsnames.ora file into Oracle Names, F-19, F-22
- upgrading to release 1 (9.0.1), F-15
- Oracle Names Control utility
- commands
- LOAD_TNSNAMES, F-19, F-22
- REGISTER, F-5, F-6
- REORDER_NS, F-23
- unsupported commands
- DOMAIN_HINT, F-6
- Oracle Net
- migrating or upgrading to, 8-16, 9-49
- Oracle Net Services
- coexistence issues, F-7 to F-9
- Oracle release 8.0 clients, F-8
- Oracle release 8.0 databases, F-9
- third-party applications, F-8
- using Oracle Net Manager, F-10
- using SERVICE_NAME networking parameter, F-7
- using SID networking parameter, F-7
- FAILOVER networking parameter, F-10
- listener.ora file with Oracle Enterprise Manager, F-14
- LOAD_BALANCE networking parameter, F-10
- Oracle Net Manager
- Use Options Compatible with Net8 8.0 Clients option, F-10
- Use Oracle8 Release 8.0 Compatible Identification option, F-10
- SERVICE_NAME parameter, F-7
- SOURCE_ROUTE parameter, F-10
- unsupported features
- Identix authentication, F-2
- Net8 OPEN, F-2
- Novell Directory Services (NDS) authentication, F-2
- Novell Directory Services (NDS) external naming, F-2
- prespawned dedicated servers, F-3
- protocol.ora file, F-3
- SecurID authentication, F-2
- SPX, F-3
- Oracle Parallel Server
- instance affinity for jobs
- compatibility, 9-15
- Oracle Parallel Server. See Oracle9i Real Application Clusters
- Oracle precompilers. See precompilers
- Oracle Spatial
- upgrading, 7-31
- Oracle System Identifier, configuring on the listener, F-14
- Oracle Text
- migrating from ConText to, 4-8, 5-7
- upgrading, 7-31
- ORACLE_HOME initialization parameter, F-14
- ORACLE_TRACE_ENABLE initialization parameter
- compatibility, B-9
- Oracle7
- downgrading to, 15-1
- prepare for migration, 4-9, 5-9
- Windows platforms, 4-13, 5-13
- Oracle9i
- changes to dynamic performance views, D-1
- changes to initialization parameters, B-1
- changes to static data dictionary views, C-1
- new features
- adding after migration or upgrade, 8-12
- new internal datatypes, E-1
- new SQL functions, E-1
- Oracle9i Real Application Clusters
- compatibility requirements, 9-39
- downgrading, 13-12
- migration, 4-7
- not supported by the Oracle Data Migration Assistant, 3-10
- rolling upgrade, 1-13
- upgrading, 7-4, 7-35
- not supported by the Oracle Data Migration Assistant, 7-8
- oracle-supplied accounts
- change passwords, 8-2
- ORADIM
- downgrading, 13-8
- migration, 4-24, 7-18
- upgrading, 7-18
- ORLON calls
- obsolete, 9-22
- OSS.MY.WALLET networking parameter, F-4
- OUTLN user
- avoid, 4-11, 5-11, 7-5
P
- PARALLEL clause
- DEGREE keyword, 9-39
- INSTANCES keyword removed, 9-39
- parallel execution
- allocated from large pool, B-12
- avoiding problems with, 8-10
- parallel table functions
- compatibility, 9-12
- removing, 14-14
- parameters
- for Migration utility. See command-line options
- partition views
- migrate to partition tables, 8-16
- partitioned index-organized tables
- removing LOBs from, 14-11
- removing varrays from, 14-13
- partitioning
- compatibility, 9-10, 9-14
- downgrading, 14-6
- password file
- migration
- exclusive setting, A-8
- password management
- application changes required for Oracle8i, 9-42
- interoperability, 9-42
- password expiration, 9-42
- pending transactions
- and migration, 4-9, 5-8
- PFILE
- Migration utility option, 4-18
- pipelined table functions
- compatibility, 9-12
- removing, 14-13
- plan stability
- compatibility, 9-17
- PL/SQL
- backward compatibility, 9-24
- compatibility, 9-12, 9-17, 9-24
- functions
- desupported, 9-35
- integrated SQL analysis, 9-25
- interoperability, 9-24
- modules
- recompiling, 7-39
- PLSQL_V2_COMPATIBILITY initialization parameter, 9-25
- removing incompatibilities for downgrading, 14-13
- variables
- NCHAR and NLS, 9-33
- precompilers
- applications
- changing to use Oracle9i, 10-10
- upgrading options, 10-7
- compatibility, 9-23
- interoperability, 9-23
- PL/SQL backward compatibility, 9-24
- upgrading applications to Oracle9i, 10-3
- PRESPAWN_LIST networking parameter, F-5
- PRESPAWN_MAX networking parameter, F-5
- prespawned dedicated servers, F-3
- primary keys
- upgrading snapshots, G-17
- Pro*Ada
- upgrading to SQL*Module for Ada, 9-24
- Pro*C/C++
- connecting with SYSDBA privileges, 9-24
- Pro*COBOL
- connecting with SYSDBA privileges, 9-24
- Procedural Option
- required for migration, 4-9, 5-9
- PROPS$ view
- NCHAR and NLS, 9-33
- protocol.ora file, F-3
- proxy copy
- requirement, 9-47
Q
- queue tables
- upgrading, 7-37
R
- RAW
- maximum size
- change, 9-20
- read-only tablespaces
- active transactions, 9-29
- compatibility, 9-29
- migration, 4-4
- REAL keyword
- behavior differences, 9-27
- rebuilding indexes
- physical ROWIDs, 12-10
- recovery
- compatibility, 9-16, 9-43
- recovery catalog
- compatibility with Recovery Manager, 9-44
- upgrading, 7-38
- Recovery Manager
- backup management, 9-44
- commands
- compatibility, 9-44
- compatibility, 9-44
- normalize catalog, 8-13
- REFs
- compatibility, 9-15
- REGISTER command, F-5, F-6
- release
- definition, 1-2
- relinking with SQL*Net, 10-3
- remote connections
- multithreaded shared servers, 3-18
- REMOTE_LOGIN_PASSWORDFILE initialization parameter, 7-20
- migration, A-8
- remove incompatibilities
- with release 8.1, 14-1
- removing incompatibilities
- UTLPITL.SQL, 13-3
- REORDER_NS command, F-23
- replication
- compatibility, 9-11, 9-16, 9-48
- downgrading, 13-12
- regenerating after, 13-14
- migration, 4-7
- migration overview, G-2
- obsolete procedures, G-22
- upgrading, 7-3
- requirements
- export, 6-2
- import, 6-2
- resource manager. See database resource manager
- restricted ROWIDs, 12-8
- reverse migration
- not supported, 15-4
- ROLLBACK FORCE command, 4-9, 5-8
- rollback segments
- migration, 4-4
- rosbild.sql script, F-20
- ROSFILES
- nmcbild.sql script, F-20
- nmcgrnt.sql script, F-20
- rosbild.sql script, F-20
- rosgrnt.sql script, F-20
- rosgrnt.sql script, F-20
- ROWIDs
- extended, 12-8
- restricted, 12-8
- rowids
- compatibility, 9-32
- client access, 12-7
- conversion to version 8 format, 12-3
- examples, 12-6
- DBMS_ROWID compatibility package, 12-3
- indexes, 12-10
- migration, 12-1
- FAQ, 12-9
- questions and answers, 12-9
- snapshot refresh, 12-7
S
- SAVEPOINT keyword
- behavior differences, 9-27
- schema objects
- compatibility, 9-10, 9-14, 9-30
- scripts
- downgrading, 13-5
- errors while running, 1-11
- rerunning, 4-33, 5-22, 7-23, 13-6
- upgrading, 7-22
- SecurID authentication, F-2
- SERIALIZABLE initialization parameter
- compatibility, B-10
- Server Manager
- differences with SQL*Plus
- ampersands, 11-14
- blank lines, 11-12
- commands, 11-3
- comments, 11-10
- COMMIT command, 11-16
- CREATE LIBRARY command, 11-16
- CREATE TYPE command, 11-16
- hyphen continuation character, 11-13
- startup, 11-2
- syntax, 11-9
- migrating scripts to SQL*Plus, 11-1
- not supported in Oracle9i, 8-9, 11-1
- server parameter file
- migrating to, 8-4
- service naming
- Net8, 9-50
- SERVICE_NAME parameter, F-7
- SERVICE_NAMES initialization parameter, F-11
- SET COMPATIBILITY command
- SQL*Plus scripts, 10-11
- SET CONNECT_TIMEOUT command, F-6
- SET USE_PLUGANDPLAY command, F-6
- SET_SESSION_LONGOPS procedure
- syntax change, 9-38
- shadow processes
- open cursors and, 3-19
- shared server
- requirements for running, 9-49
- shared structures
- interoperability, 9-22
- SHARED_POOL_SIZE initialization parameter
- changes in behavior, 8-10
- parallel execution allocation, B-12
- SHOW CONNECT_TIMEOUT command, F-6
- SID networking parameter, F-8
- SID, configuring on the listener, F-14
- SID_NAME parameter, F-14
- single-table hash clusters
- compatibility, 9-10, 9-14
- snapshot sites
- migration, G-9
- snapshots
- refresh
- physical ROWIDs, 12-7
- upgrading to primary key, G-17
- SORT_AREA_SIZE initialization parameter
- compatibility, B-10
- SORT_DIRECT_WRITES initialization parameter
- compatibility, B-10
- source database
- definition, 1-3
- SOURCE_ROUTE parameter, F-10
- space requirements
- copying data, 3-16
- migration, 3-16, 4-5, 5-5
- Spatial
- compatibility, 9-18
- SPOOL
- Migration utility option, 4-18
- SPX protocol, F-3
- SQL
- compatibility, 9-12, 9-17
- functions
- added in Oracle9i, E-2
- added in version 8, E-4
- removing incompatibilities for downgrading, 14-13
- SQL commands
- COMMIT FORCE, 4-9, 5-8
- ROLLBACK FORCE, 4-9, 5-8
- SQL*Module
- for Ada, 9-24
- SQL*Net
- coexistence issues, F-7 to F-9
- Oracle9i databases, F-7
- using SERVICE_NAME networking parameter, F-7
- using SID networking parameter, F-8
- migrating to Oracle Names release 1 (9.0.1), F-15
- migrating to Oracle Net, 8-16, 9-49
- migrating to Oracle Net Services, F-11 to F-14
- configuration files, F-12
- listener.ora file, F-14
- software on client, F-12
- software on server, F-12
- tnsnames.ora file, F-13
- verifying service name and instance name, F-11
- relinking, 10-3
- requirement for migration
- Windows platforms, 4-13, 5-13
- SID networking parameter, F-8
- upgrading from V1 to V2, 9-49
- use with Oracle9i, 10-3
- SQL*Plus
- differences with Server Manager
- ampersands, 11-14
- blank lines, 11-12
- commands, 11-3
- comments, 11-10
- COMMIT command, 11-16
- CREATE LIBRARY command, 11-16
- CREATE TYPE command, 11-16
- hyphen continuation character, 11-13
- startup, 11-2
- syntax, 11-9
- migrating scripts from Server Manager, 11-1
- scripts
- upgrading, 10-11
- SQLJ
- installing, 8-5
- SQLNET.IDENTIX_FINGERPRINT_DATABASE networking parameter, F-4
- SQLNET.IDENTIX_FINGERPRINT_DATABASE_ PASSWORD networking parameter, F-4
- SQLNET.IDENTIX_FINGERPRINT_DATABASE_ USER networking parameter, F-4
- SQLNET.IDENTIX_FINGERPRINT_METHOD networking parameter, F-4
- sqlnet.ora file
- parameters
- NAMES.DEFAULT_DOMAIN, F-4
- NAMES.PREFERRED_SERVERS, F-4
- SQLNET.IDENTIX_FINGERPRINT_DATABASE_PASSWORD, F-4
- WALLET_LOCATION, F-4
- unsupported parameters
- AUTOMATIC_IPC, F-4
- NAMES.DEFAULT_ZONE, F-4
- NAMES.NDS.NAME.CONTEXT, F-4
- OSS.MY.WALLET, F-4
- SQLNET.IDENTIX_FINGERPRINT_DATABASE, F-4
- SQLNET.IDENTIX_FINGERPRINT_DATABASE_PASSWORD, F-4
- SQLNET.IDENTIX_FINGERPRINT_DATABASE_USER, F-4
- SQLNET.IDENTIX_FINGERPRINT_METHOD, F-4
- standby database
- compatibility, 9-45
- migrating, 8-10
- migrating to Oracle9i, 8-11
- upgrading, 8-10
- upgrading to Oracle9i, 8-11
- STARTUP
- compatibility, 9-27
- statements
- ALTER DATABASE RESET COMPATIBILITY, 9-9
- ALTER DATABASE RESET LOGS, 4-9, 5-8
- static data dictionary views
- added in Oracle9i, C-2
- added in version 8, C-7
- changed in Oracle9i
- added columns, C-4
- changed in VERSION 8
- dropped columns, C-15
- changed in version 8
- added columns, C-12
- columns that may return NULLs, C-17
- renamed columns, C-17
- changes in Oracle9i, C-1
- obsolete, 9-30
- obsolete in version 8, C-19
- renamed in Oracle9i, C-4
- statistics tables
- upgrading, 7-39
- SUBSTR operator, 9-20
- subtypes
- downgrading, 14-13
- Summary Advisor
- installing Java classes, 8-5
- summary management
- compatibility, 9-12, 9-18
- SYS schema
- user-created objects in, 9-30
- SYSDBA
- connecting in Pro*C/C++, 9-24
- connecting in Pro*COBOL, 9-24
- system requirements
- for migration, 3-16
- SYSTEM tablespace
- Migration utility, 3-6, 4-5
- Oracle Data Migration Assistant, 5-5
- space
- insufficient for migration, A-4
T
- tablespaces
- automatic segment-space managed
- removing, 14-3
- automatic undo managed
- removing, 14-4
- compatibility, 9-9, 9-13, 9-28
- migrating offline tablespaces, 4-11, 5-10
- target database
- definition, 1-3
- tempfiles
- data dictionary information, 9-29
- temporary tables
- compatibility, 9-14
- temporary tablespace
- space
- insufficient for migration, A-4
- terminology
- migration, 1-2
- testing
- applications for migration, 3-26
- developing a plan for migration, 3-22
- EXPLAIN PLAN, 3-25
- functional for migration, 3-23
- integration for migration, 3-23
- INTO clause, 3-25
- migration results, 8-16
- minimal for migration, 3-23
- performance for migration, 3-24
- pre- and post-migration, 3-25
- the migrated test database, 3-26
- the migration process, 3-26
- volume/load stress for migration, 3-24
- thread safety
- compatibility, 9-22
- tnsnames.ora file
- migrating, F-13
- parameters
- FAILOVER, F-10
- LOAD_BALANCE, F-10
- SERVICE_NAME, F-7
- SID, F-8
- SOURCE_ROUTE, F-10
- unsupported parameters
- COMMUNITY, F-4
- upgrading, F-13
- TO_LABEL function
- desupported, 9-35
- TO_LOB function, 8-7
- TP monitors, 3-19
- transactions
- pending, 4-9, 5-8
- Transparent Application Failover (TAF)
- GLOBAL_DBNAME networking parameter in listener.ora, F-14
- transportable tablespaces
- compatibility, 9-13
- triggers
- compatibility, 9-17
- troubleshooting
- database fails to open after removing incompatibilities, 9-9
- migration, A-1
- ALTER DATABASE CONVERT statement, A-6
- AUDIT_TRAIL initialization parameter, A-4
- database name mismatch, A-9
- datafile version integrity, A-10
- Migration utility error messages, A-11
- missing convert file, A-7
- MULTIPLIER option, A-6
- NOMOUNT database start mode, A-7
- OPTIMAL setting, A-5
- Oracle7 control file, A-7
- password file, A-8
- running the Migration utility, A-3
- running the Oracle Data Migration Assistant, A-3
- scripts run long, A-11
- SYSTEM tablespace, A-4
- temporary tablespace tablespace, A-4
- upgrading, A-1
- TRUE keyword
- behavior differences, 9-27
- Trusted Oracle
- Export/Import, 6-3
- tuning
- after migration, 8-17
- type DTYCHR, 12-10
- type evolution
- compatibility, 9-11
- interoperability, 9-34
- type inheritance
- compatibility, 9-11
- types
- evolved
- removing, 14-12
- non-final
- downgrading, 14-13
U
- U0703040.SQL script, 4-33
- Universal ROWIDs. See UROWIDs
- upgrading
- Advanced Queuing, 7-37
- after upgrading, 8-1, 8-17
- applications, 10-1
- compatibility rules, 10-4
- options, 10-7
- relinking, 10-4
- character set, 7-2
- definition, 1-3
- initialization parameters, 7-19
- interMedia, 7-31
- Java, 7-25, 7-26, 7-29, 7-31
- JServer, 7-25
- listener.ora file, 8-10
- manually, 7-15
- materialized views, 7-36
- NCHAR columns, 8-3
- new administrative procedures, 8-12
- Oracle Forms applications, 10-12
- Oracle Label Security, 7-34
- Oracle Spatial, 7-31
- Oracle Text, 7-31
- Oracle9i Real Application Clusters, 7-4, 7-35
- rolling upgrade, 1-13
- ORADIM, 7-18
- OUTLN user, avoid, 7-5
- parallel execution, 8-10
- paths, 7-2
- post upgrade, 8-1, 8-17
- post-upgrade actions, 8-1
- preparing to upgrade, 7-5
- queue tables, 7-37
- recovery catalog, 7-38
- replication, 7-3
- scripts, 7-22
- CATALOG.SQL, 7-23
- CATCLUST.SQL, 7-35
- CATPROC.SQL, 7-23
- errors while running, 1-11
- JISU815.SQL, 7-29
- JISU816.SQL, 7-29
- JISU817.SQL, 7-29
- JSPU815.SQL, 7-31
- JSPU816.SQL, 7-31
- JSPU817.SQL, 7-31
- JVMU815.SQL, 7-26
- JVMU816.SQL, 7-26
- JVMU817.SQL, 7-26
- OLSU817.SQL, 7-34
- rerunning, 7-23
- UTLRP.SQL, 7-39
- XMLU815.SQL, 7-28
- XMLU816.SQL, 7-28
- XMLU817.SQL, 7-28
- specific components, 7-24
- SQL*Plus scripts, 10-11
- standby database, 8-10
- statistics tables, 7-39
- steps, 7-2
- supported releases, 7-2
- troubleshooting, A-1
- using the Oracle Data Migration Assistant, 7-8
- XDK for Java, 7-27
- XML, 7-27, 7-28
- UROWIDs
- compatibility, 9-15
- interoperability, 9-33
- Use Options Compatible with Net8 8.0 Clients option, F-10
- Use Oracle8 Release 8.0 Compatible Identification option, F-10
- USE_PLUG_AND_PLAY_listener_name networking parameter, F-5
- user-created objects
- in SYS schema, 9-30
- user-defined aggregate functions
- compatibility, 9-11
- dropping for downgrading, 14-12
- user-defined datatypes
- compatibility, 9-34
- interoperability, 9-35
- new format, 9-34
- user-defined object identifiers
- compatibility, 9-15
- UTLCHN1.SQL script, 9-36
- compatibility, 9-17
- UTLCONST.SQL script, 8-9
- UTLEXPT1.SQL script, 9-36
- compatibility, 9-17
- UTLINCMP.SQL script, 14-2
- UTLPITL.SQL script, 13-3
- UTLRP.SQL script, 4-33, 5-22, 7-39
V
- VALUE$ view
- NCHAR and NLS, 9-33
- VARCHAR2
- maximum size
- change, 9-20
- varrays
- compatibility, 9-11, 9-15
- removing from partitioned index-organized tables, 14-13
- stored as LOBs
- compatibility, 9-35
- version
- definition, 1-2
- version 6
- Export/Import for migration, 6-2
- versions
- multiple, 1-4
- view constraints
- compatibility, 9-12
- Visual Image Retrieval
- compatibility, 9-18
W
- WALLET_LOCATION networking parameter, F-4
- word-size
- changing, 1-12, 7-40
X
- XDK for Java
- upgrading, 7-27
- XML
- downgrading, 13-13
- upgrading, 7-27, 7-28
- XMLD817.SQL script, 13-13
- XMLU815.SQL script, 7-28
- XMLU816.SQL script, 7-28
- XMLU817.SQL script, 7-28