Oracle8 Server Migration
Release 8.0
A54650_01

Library

Product

Contents


Prev


A

abandoning migration, 3-14
access
concurrent, F-3
account locking, A-30
ACCOUNT_LOCK_TIME
CREATE PROFILE command, A-31
Ada, SQL*Module, 6-4
ADD clause
ALTER SNAPSHOT LOG ON command, A-55
ADD PRIMARY KEY clause, A-55
ADD ROWID clause, A-55
administrative procedures
develop new, 5-3
migrated database and, 5-3
advanced queuing, A-38
ALL_INDICES view
LOGGING attribute, A-7
ALL_TABLES view
LOGGING attribute, A-6
ALTER DATABASE CONVERT command
migration utility, 3-3
ALTER DATABASE OPEN RESETLOGS command
Migration Utility, 3-3
ALTER INDEX command
REVERSE option, A-23
ALTER SESSION command
DISABLE PARALLEL DML clause, A-4
DISCONNECT SESSION ... POST_TRANSACTION clause, A-19
ENABLE PARALLEL DML clause, A-4
ALTER SNAPSHOT LOG ON command
ADD clause, A-55
ALTER TABLE
EXCHANGE PARTITION, A-12
ALTER TABLE command
CONSTRAINT NOT DEFERRABLE clause, A-21
DISABLE TABLE LOCK clause, A-9
EXCHANGE PARTITION clause, A-12
ALTER TABLESPACE command
MINIMUM EXTENT parameter, A-20
OFFLINE IMMEDIATE or OFFLINE TEMPORARY, 3-5
ALTER TYPE command, A-44
APPEND hint
INSERT command, A-3-A-4
application developer
role during migration, 1-4
applications
migrating, 6-1
testing, 2-12
architecture
migrating to a different architecture, 3-4
TWO-TASK, F-3
AS clause
space requirements, 2-9
associative interface
Oracle Call Interface, A-47
availability enhancements, A-40


B

backup
after migration, 1-3, 3-10, 5-2
backup sets, A-34
before migration, 3-9
EBU, 6-11
enhancements, A-35
image copies, A-34
Oracle8 enhancements, A-18
Recovery Manager, 6-11
target database, 3-10, 5-2
backwards migration, 8-2
BFILE keyword
behavior in Oracle8 and Oracle7, 6-9
BFILEs
references from database, A-26
BLOB keyword
behavior in Oracle8 and Oracle7, 6-9
BLOBs
PL/SQL, A-56
replication, A-29
storage, A-26
block size
DB_BLOCK_SIZE, 3-4
minimums, 3-4
blocksize and DB_BLOCK_SIZE, 3-4


C

CAST keyword
behavior in Oracle8 and Oracle7, 6-9
CAT8000.SQL script, 3-12
CATALOG.SQL script, 3-12
abandoning migration, 3-14
CATALOG5.SQL, obsolete with Oracle8, 6-6
CATALOG6.SQL, obsolete with Oracle8, 6-6
CATEXP.SQL script, 6-15
CATEXP7.SQL script
export a partitioned table, 6-14
CATPROC.SQL script, 3-12
abandoning migration, 3-14
CATREP.SQL script, 3-14
CATREP8M.SQL script, 3-12
CHAR
size, F-4
character encoding
CREATE DATABASE command, 3-5
CHARACTER keyword
behavior in Oracle8 and Oracle7, 6-8
character set
handling in Oracle8, A-23
migration utility uses, 3-5, D-2
CHARACTER_SET_NAME, 6-16
CHECK_ONLY
using option, 3-3
CHECK_ONLY migration parameter, 3-7
client-side object cache
Oracle Call Interface, A-47
CLOB keyword
behavior in Oracle8 and Oracle7, 6-9
CLOBs
PL/SQL, A-56
replication, A-29
cluster tables
COPY command, 2-9
command line options, 3-7
COMMIT keyword
behavior in Oracle8 and Oracle7, 6-8
comparison operators
spatial data, A-27
compatibility
conventional path export, 6-15
direct path export, 6-15
SQL scripts Oracle7-->Oracle8, 6-7
concurrent access, F-3
concurrent users, F-4
CONNECT INTERNAL, 3-8
connection manager
used by OCI-Net2 clients, 6-10
connections
local and remote, F-3
with multi_threaded shared server, F-3
TWO_TASK architecture with, F-3
with SQL*Net, F-3
with TP monitors, F-3
CONSTRAINT DEFERRABLE clause
ALTER TABLE command, A-21
CREATE TABLE command, A-21
CONSTRAINT NOT DEFERRABLE clause
CREATE TABLE command, A-21
constraints
deferred checking, A-21
conventional path
export, 6-15
SQL*Loader, A-26
conversion
of data definition, 2-8
COPY command
cluster tables, 2-9
copying data, 2-8
large cluster tables, 2-9
space requirements, 2-9
copying data
between versions and releases, 2-8
COPY command, 2-8
CREATE TABLE...AS, 2-8
database links, 2-8
INSERT INTO, 2-8
CPU enhancements
PL/SQL performance, A-61
CPU usage enhancements, A-60
CREATE DATABASE command
character encoding, 3-5
CREATE INDEX command
NOREVERSE option, A-23
REVERSE option, A-23
CREATE PROFILE command
ACCOUNT_LOCK_TIME, A-31
enhancements, A-31
FAILED_LOGIN_ATTEMPTS option, A-31
PASSWORD_GRACE_TIME, A-31
PASSWORD_LIFETIME option, A-31
PASSWORD_REUSE_... option, A-31
PASSWORD_VERIFY_FUNCTION option, A-31
CREATE TABLE
AS command, copying data, 2-8
CREATE TABLE command
CONSTRAINT DEFERRABLE clause, A-21
CREATE TABLESPACE command
MINIMUM EXTENT parameter, A-20
CREATE TYPE command, A-44
current user database link, A-22
cursors
number of open, F-4


D

data
nonrelational, support for, A-42
data block address, A-14
data blocks
tablespace-relative addresses, A-14
data definition
conversion, 2-8
data definition conversion by Import, 2-8
data dictionary
Export/Import utility, 2-8
security enhancements, A-37
data manipulation language (DML)
parallel, A-2
recovery, A-4
uses, A-7
partition locks, A-9
data storage
enhancements, A-40
data subsetting in replication, A-28
database
backing up, 3-9
developing a test plan, 2-11
links and copying data, 2-8
prepare source database for migration, 3-5
shutting down, 3-8
specifying name, 3-7
specifying new name, 3-7
standby, A-40
test the migrated, 5-2
testing, 5-2
tune the migrated, 5-3
tuning, 5-3
very large, A-42
database administrator
role during migration, 1-4
database link
current user, A-22
datafile
backup types, A-34
limit per tablespace, F-4
datatypes
enhancements, A-43
large object, in PL/SQL, A-56
national character, A-43
national character varying, A-43
objects, A-43
DB_BLOCK_SIZE
blocksize consideration, 3-4
DB_NAME migration parameter, 3-7
DBA, 1-4
duties, 1-4
DBA_ views, A-15
DBA_EXTENTS view, A-15
DBA_FREE_SPACE view, A-15
DBA_INDICES view
LOGGING attribute, A-7
DBA_PROFILES view
RESOURCE_TYPE column, A-32
DBA_SEGMENTS view, A-15
DBA_TABLES view
LOGGING attribute, A-6
DBA_TABLESPACES view
LOGGING attribute, A-6
MIN_EXTLEN column, A-20
DBA_USERS view
new columns, A-32
DBMS
precompiler command line option, 6-4
DBMS_AQADM package, A-40
DBMS_BACKUP_RESTORE package, A-19
DBMS_LOB package
LOADFROMFILE procedure, 6-5
WRITE procedure, 6-6
DBMS_ROWID package
PL/SQL, A-14
DEC keyword
behavior in Oracle8 and Oracle7, 6-8
deferred constraint checking, A-21
deferred transactions
parallel propagation in replication, A-28
DEQUEUE command, A-39
DEREF keyword
behavior in Oracle8 and Oracle7, 6-9
Developer/2000 Applications
upgrading, 6-6
dictionary
migration, 3-14
dictionary tables
FILE$, A-15
UNDO$, A-16
dictionary views, A-36
direct path
export, 6-15
SQL*Loader, A-26
Direct Path Export
migration and compatibility issues, 6-15
direct-load INSERT, A-2
restrictions, A-3
DISABLE PARALLEL DML clause
ALTER SESSION command, A-4
DISABLE TABLE LOCK clause
ALTER TABLE command, A-9
DISCONNECT SESSION ... POST_TRANSACTION clause
ALTER SESSION command, A-19
DISJOINT comparison operator, A-27
Distributed Lock Manager (DLM), F-4
distributed option
installation, 3-12
DLM, F-4
DML locks, D-2
DML_LOCKS
in INIT.ORA, D-2
downgrade
to previous database, 8-2
DROP TYPE command, A-44
DTYCHR type, 7-8


E

EBU
backup management, 6-11
ENABLE PARALLEL DML clause
ALTER SESSION command, A-4
encapsulated interface, A-45
ENQUEUE command, A-39
environment variable
NLS character set, D-2
errors during migration, 3-13
estimating system requirements, 2-2
EXCHANGE PARTITION, A-12
executables
size of, F-2
space required, F-2
EXPLAIN PLAN
testing, 2-11
Export
Oracle7 with CATEXP7.SQL, 8-2
export
partition, A-11
export/import
basic steps for migrating the source database, 4-1
partitioned objects, 6-13
Export/Import utility
benefits, 2-6
compatibility issues, 6-15
data definition conversion, 2-8
data dictionary, 2-8
database object support, A-24
dump file compatibility between Oracle7 and Oracle8, 6-13
earlier versions, 2-8, 4-2
limitations, 2-6
limitations for migration, 2-7
migration utility or, 2-5
time requirements, 2-7
Trusted Oracle7 and, 4-2
using, 4-2
when to use, 2-5, 4-2
external binary format
ROWID, A-14
external character format
ROWID, A-14
external procedures
called with PL/SQL, A-56


F

FAILED_LOGIN_ATTEMPTS option
CREATE PROFILE command, A-31
failover, A-16
FALSE keyword
behavior in Oracle8 and Oracle7, 6-8
file number
relative or absolute, A-14
tablespace-relative, A-16
FILE$ dictionary table, A-15
Forms
migrating Oracle Forms applications, 6-6
Forms applications
upgrading, 6-6
forms applications
running on Oracle8, 6-6


G

global prefixed index, A-10


H

handles, A-45
Heterogeneous Services, A-17


I

image copies
backup, A-34
image storage
Server Image Cartridge, A-26
import
data definition conversion, 2-8
partition, A-11
index on ROWID, 7-8
index rebuilding, 7-8
indexes
global prefixed, A-10
local nonprefixed, A-10
local prefixed, A-10
partitioned, A-10
partitions, tables, A-8
range-partitioned, A-10
reverse-key, A-23
INIT.ORA parameters
DML_LOCKS, D-2
INSERT command
APPEND hint, A-3-A-4
direct load restrictions, A-3
direct-load, A-2
hints, A-4
NOAPPEND hint, A-5
PARALLEL clause, A-5
PARALLEL hint, A-5
INSERT INTO command
copying data, 2-8
INSIDE comparison operator, A-27
installing options, 3-12
installing Oracle7, 4-3
INT keyword
behavior in Oracle8 and Oracle7, 6-8
INTO parameter
testing, 2-11


K

key words, E-1
keywords
behavior differences
Oracle7 vs. Oracle8, 6-8
behavior in Oracle8, 6-9
new to Oracle8, 6-9


L

link line
for OCI applications, 6-5
LOADFROMFILE procedure
DBMS_LOB package, 6-5
LOB datatypes
converting LONG to, 6-5
PL/SQL, A-56
local connections
multi-threaded shared servers, F-3
local nonprefixed index, A-10
local prefixed index, A-10
locks
DML lock limit, DML_LOCKS, D-2
LOGGING clause, A-5
login sessions
Oracle Call Interface, A-46
LONG datatypes
upgrading to LOB datatype, 6-5


M

master tables
reorganizint, A-29
memory requirements, F-2
concurrent access, F-3
migration, 3-3
memory utilization enhancements, A-58
migrate back (to previous database), 8-2
MIGRATE user dropped, 3-12
MIGRATE user, avoid, 3-5
MIGRATE.BSQ script, 3-9
migrating
applications, 6-1
errors during, 3-13
general comments, 1-2
OCI applications, 6-2, 6-4
offline tablespaces, 3-5
Oracle Forms applications, 6-6
precompiler applications, 6-2-6-3
preserve the source database, 3-5
process, 1-2
role of application developer, 1-4
role of database administrator, 1-4
SQL*Net, 6-9
SQL*Plus scripts, 6-6
steps for, 1-2
testing, 2-12
to a different computer architecture, 3-4
migration
choose a method, 2-3
NCHAR and NLS, 6-16
new administrative procedures, 5-3
Oracle Call Interface applications, A-51
space requirements, 3-3
using Export/Import, 2-5
migration and compatibility
thread safety, OCI, 6-14
migration and compatibility issues
standby database, 6-14
migration by Export/Import
data definition conversion, 2-8
migration parameters
CHECK_ONLY, 3-7
DB_NAME, 3-7
NEW_DBNAME, 3-7
NLS_NCHAR, 3-7
NO_SPACE_CHECK, 3-7
PFILE, 3-7
SPOOL, 3-7
migration steps
overview, 1-2
step 1, prepare to migrate, 2-2
step 2, test the migration, 2-12
step 3, test your applications, 2-12
step 4, preserve and prepare the source database, 1-3
step 4, preserve the source database, 3-5
step 5, migrate the source database, 1-3
step 6, make initial adjustments to the migrated database, 1-3, 5-1
testing, migration test plan, 2-9
migration utility
ALTER DATABASE CONVERT command, 3-3
ALTER DATABASE OPEN RESETLOGS, 3-3
character set used, 3-5, D-2
choosing, 2-3
command line options, 3-7
conversion of files, 3-2
errors and messages, B-1
Export/Import utility or, 2-5
installing, 3-6
migrating the source database, 2-6-2-7, 3-11
migrating to a different architecture, 3-4
overview, 2-3, 3-2
privileges needed, 3-8
privileges required, 3-8
space required for SYSTEM tablespace, 3-3
using, 3-8
when to use, 2-3
MIN_EXTLEN column
DBA_TABLESPACES view, A-20
USER_TABLESPACES view, A-20
MINIMUM EXTENT parameter
ALTER TABLESPACE command, A-20
CREATE TABLESPACE command, A-20
multi-threaded server
requirements for running, 6-9
shared, F-3
shared and local/remote connections, F-3


N

national character datatype, A-43
national character set
in Oracle8, 6-15
national character varying datatype, A-43
navigational interface
Oracle Call Interface, A-47
NCHAR, 6-15
compatibility and interoperability, 6-16
compatibility issues, 6-4
migration, 6-16
size, F-4
use in Oracle8, 6-15
NCHAR and NLS use, 6-15
NCHAR keyword
behavior in Oracle8 and Oracle7, 6-9
NCHAR VARYING
size, F-4
NCLOB keyword
behavior in Oracle8 and Oracle7, 6-9
NCLOBs
PL/SQL, A-56
replication, A-29
Net8
upgraded applications and, 6-9
network utilization enhancements, A-59
new features
adding, 5-3
NEW_DBNAME migration parameter, 3-7
NLS
compatibility and interoperability, 6-16
migration, 6-16
NLS character set, D-2
NLS use and NCHAR, 6-15
NLS_DATABASE_PARAMETERS view, A-36
NLS_LANG setting, D-2
NLS_NCHAR migration parameter, 3-7
NLS_NCHAR_CHARACTERSET, 6-16
NO_SPACE_CHECK migration parameter, 3-7
NOAPPEND hint
INSERT command, A-5
NOLOGGING clause, A-5
nonrelational data, A-42
nontransactional application failover, A-16
Oracle Parallel Server, A-16
NOREVERSE option
CREATE INDEX command, A-23
REBUILD INDEX command, A-23
NUMERIC keyword
behavior in Oracle8 and Oracle7, 6-8
NVARCHAR2 keyword
behavior in Oracle8 and Oracle7, 6-9


O

O7_DICTIONARY_ACCESSIBILITY switch, 6-12
object cache
Oracle Call Interface, A-47
object support
Oracle Call Interface, A-47
Oracle8, A-24
object type support
Pro*C/C++, A-52
Object Type Translator (OTT), A-49
object-oriented enhancements, A-43
obsolete parameters, D-3
OCI
callback function, A-43
OCI application
link line, 6-5
OCI applications
Oracle8 link line, 6-5
OCI/UPI clients
relinking with Net8, 6-10
OCIChangePassword call, 6-12
OCILIB, OCI library, 6-4
OCILobLoadFromFile command, 6-5
OCILobWrite command, 6-6
OCI-Net2 clients
requirements, 6-10
OCISessionBegin call, 6-12
offline instantiation in replication, A-29
offline tablespaces, 3-5
OLQP, F-3
OLTP, F-3
opaque interface, A-45
Open Type System
object types, A-43
options
installing, 3-12
migration utility, 3-7
ORA_NLS32, D-2
ORA_NLS33, D-2
ORA_NLS33 variable, 3-8
Oracle Call Interface (OCI), A-44
associative interface, A-47
client-side object cache, A-47
login session types, A-46
migrating applications, 6-4
migration, A-51
navigational interface, A-47
object support, A-47
Oracle8 features, 6-10
password managment, A-45
performance, A-46
preparing to migrate applications, 6-2
run-time environment, A-48
scalability, A-46
thread safety compatibility issues, 6-14
transaction management, A-46
type management, A-49
type mapping, A-49
user authentication, A-45
Oracle Parallel Server
nontransactional application failover, A-16
Oracle6
Oracle Call Interface (OCI) library, 6-5
Oracle6 OCI library
not supported, 6-5
Oracle7
installing, 4-3
upgrading applications to Oracle8, 6-1
Oracle7 clients
with Oracle8 Server, 6-13
Oracle7 parameters
obsolete in 8.0.3, D-3
Oracle8
dictionary changes, A-15
Oracle8 client
with Oracle7 server, 6-13
Oracle8 Objects Expansion, A-44
Oracle8 Open Type System, A-43
Oracle8 Oracle Call Interface (OCI)
enhancements, A-44
Oracle8 Pro*C/C++, A-52
Oracle8 Pro*COBOL precompiler, A-55
Oracle8 Server Image Cartridge, A-26
Oracle8 Server Spatial Cartridge, A-27
geometric forms supported, A-27
Oracle8 SQL Type Data Definition Language, A-44
Oracle8 SQL*Module for Ada 8.0, A-54
OVERLAP comparison operator, A-27


P

PARALLEL clause
INSERT command, A-5
parallel data manipulation language (DML), A-2
uses, A-7
parallel direct path
SQL*Loader, A-26
PARALLEL hint
INSERT command, A-5
Parallel Server, F-4
system requirements, F-4
parameter files (INIT.ORA)
obsolete parameters, 3-11
specifying filename, 3-7
parameters
migration utility, 3-7
obsolete in 8.0.3, D-3
PARTITION clause, A-8
partition exchange operator, A-12
partition locks, A-9
partition views, A-13
partitioned index
replication, A-29
partitioned indexes, A-8, A-10
partitioned objects
export/import, 6-13
SQL*Loader support of, A-26
partitioned table
replication, A-29
partitioned tables, A-8, A-10
partitioning key, A-8
partitions
attributes, A-8
export, A-11
import, A-11
maintenance operations, A-8
parallel load, A-12
range, A-8
password expiration, 6-13
password management
application changes required for Oracle8, 6-12
PASSWORD_GRACE_TIME option
CREATE PROFILE command, A-31
PASSWORD_LIFETIME option
CREATE PROFILE command, A-31
PASSWORD_REUSE_... option
CREATE PROFILE command, A-31
PASSWORD_VERIFY_FUNCTION option
CREATE PROFILE command, A-31
passwords
complexity verification, A-30
expiration, A-30
history, A-30
lifetime, A-30
management, A-30
backwards compatibility, A-32
Oracle Call Interface, A-45
performance
enhancements, A-41
Oracle Call Interface, A-46
performance testing, 2-10
SQL_TRACE, 2-10
TKPROF, 2-10
persistent queuing, A-38
PFILE migration parameter, 3-7
PL/SQL
backward compatibility, 6-4
collections, A-56
compatibility between V2 and V8.0.3, 6-7
DBMS_ROWID package, A-14
external procedures, A-56
installation, 3-12
large object (LOB) datatypes, A-56
object type support, A-56
performance enhancements, A-61
V2 compatibility mode, 6-7
PL/SQL variables
NCHAR and NLS, 6-15
PLSQL_V2_COMPATIBILITY flag, 6-4, 6-7
point-in-time recovery
tablespace, A-18
precompiler applications
migrating, 6-3
upgrading from Oracle7 to Oracle8, 6-4
upgrading to Oracle8, 6-2
using with Oracle8, 6-3
precompilers
compatibility between Oracle8 and Oracle7, 6-3
prepare source database for migration, 3-5
previous database
downgrading to, 8-2
primary key
field limit, F-4
primary-key snapshots, A-29
privileges
migration utility requirements, 3-8
Pro*Ada
upgrading to SQL*Module for Ada, 6-4
Pro*C 3, 6-3
Pro*C/C++
arrays of structs in, A-52
integration testing, 2-10
object type support, A-52
Pro*C/C++ 2.2
compatibility with Oracle8 server, 6-3
Pro*C/C++ 3.0
compatibility with Oracle7, 6-3
Pro*COBOL precompiler, A-55
DB2 compatibility, A-55
nested programs, A-55
props$ view, 3-7
NCHAR and NLS, 6-16


Q

queuing
advanced, A-38
DBMS_AQADM package, A-40
persistent, A-38
views, A-40


R

range partitioning, A-8
range-partitioned indexes, A-10
REAL keyword
behavior in Oracle8 and Oracle7, 6-8
REBUILD INDEX command
NOREVERSE option, A-23
rebuilding indexes, 7-8
recovery
parallel data manipulation language (DML), A-4
point-in-time tablespace, A-18
server-managed, A-33
Recovery Manager, A-19, A-33
backup management, 6-11
command language interpreter, A-34
commands, A-35
REF keyword
behavior in Oracle8 and Oracle7, 6-9
relative file number, A-15-A-16
reliability enhancements, A-40
relinking with SQL*Net, 6-2
remote connections
multi-threaded shared servers, F-3
replication
data propagation, A-28
data subsetting, A-28
database management for, A-29
fine-grained quiesce, A-29
large object datatype support, A-29
offline instantiation for, A-29
parallel propagation of deferred transactions, A-28
partitioned indexes, A-29
partitioned tables, A-29
primary-key snapshots, A-29
reorganizing master tables, A-29
security, A-29
snapshot registration, A-29
validate procedure, A-29
replication triggers, A-28
reserved words, E-1
restore
enhancements, A-35
Oracle8 enhancements, A-18
reverse migration support, 8-2
REVERSE option
ALTER INDEX command, A-23
CREATE INDEX command, A-23
reverse-key index, A-23
RMCLI, A-34
role
of application developer, 1-4
of database administrator, 1-4
rollback segments
conversion of, 3-3
ROWID
compatibility, client access, 7-6
extended disk format, A-13
external binary format, A-14
external character format, A-14
migration
questions and answers, 7-7
restricted disk format, A-13
snapshot refresh, 7-6
ROWID conversion, 7-3-7-4
examples, 7-5
ROWID feature enhancements, A-13
ROWID in indexes, 7-8
ROWID use
DBMS_ROWID compatibility package, 7-2
ROWIDs for Oracle8
partitioned tables and tablespace-relative data block addresses, 7-1
run-time environment
Oracle Call Interface, A-48


S

SAVEPOINT keyword
behavior in Oracle8 and Oracle7, 6-8
scalability
Oracle Call Interface, A-46
scalability enhancements
Oracle8 Server, A-57
security
enhancements in Oracle8, A-20
for replication, A-29
password management, A-30
SELECT list
keyword behavior differences
Oracle7 vs. Oracle8, 6-8
SERIALIZABLE=TRUE
desupported, D-4
Server Image Cartridge, A-26
server process enhancements, A-57
Server Spatial Cartridge, A-27
geometric forms supported, A-27
server-managed recovery, A-33
SET COMPATIBILITY command, 6-6-6-7
SET CONSTRAINTS command, A-21
shadow processes
open cursors and, F-4
SHUTDOWN ABORT, avoid, 3-13
SHUTDOWN TRANSACTION command, A-19
shutting down the database, 3-8
snapshot compatibility
ROWID, 7-7
snapshot refresh, ROWID, 7-6
snapshot registration, A-29
space required
executables, F-2
space requirements
COPY command, 2-9
migration, 3-3
Migration Utility, 3-3
spatial data
comparison operators, A-27
storage, A-27
special characters, E-1
SPOOL migration parameter, 3-7
SQL
key words, E-1
reserved words, E-1
special characters, E-1
SQL performance enhancements, A-60
SQL scripts
compatibility Oracle7-->Oracle8, 6-7
running on Oracle8, 6-7
SQL syntax changes, A-55
SQL*Loader
modes, A-26
partitioned object support, A-26
partitioned table support, A-12
SQL*Module
array interface, A-54
for Ada, 6-4
SQL*Module for Ada, 6-4
SQL*Net
migrating, 6-9
relinking, 6-2
SQL*Net V1 not used with Oracle8, 6-2
SQL*Net V2 and Net8 used with Oracle8, 6-2
upgraded applications and, 6-9
upgrading from Version 1 to Version 2, 6-9
SQL*Plus
upgrading scripts to Oracle8, 6-6
SQL*Plus scripts
migrating, 6-6
SQL_TRACE
performance testing, 2-10
SQLLIB calls
relinking, 6-4
work against Oracle8, 6-3
SQLLIB runtime library, 6-3
standby database, A-40
compatibility and upgrade, 6-14
compatibility issues, 6-14
migration and compatibility, 6-14
STARTUP command
NOMOUNT option and blocksize, 3-11
SYS schema
user-created objectst in, 6-12
SYS_OP_NTCIMG$ keyword
behavior in Oracle8 and Oracle7, 6-9
system requirements
estimating, 2-2
parallel server, F-4
SYSTEM tablespace
Migration Utility, 2-5, 3-3


T

table
column limit, F-4
tables
partitioned, A-10
tablespace number, A-16
tablespace point-in-time recovery (PITR), A-18
tablespace-relative data block addresses, A-14
tablespace-relative DBA, A-14
tablespace-relative file number, A-16
tablespaces
migrating offline tablespaces, 3-5
offline, 3-5
testing, 2-11
applications, 2-12
before migrating, 2-9
comparing results, 5-2
develop a plan, 2-9
EXPLAIN PLAN, 2-11
functional, 2-10
integration, 2-10
INTO parameter, 2-11
migration, 2-9
minimal, 2-9
performance
SQL_TRACE, 2-10
volume/load stress, 2-10
thread safety, OCI
compatibility and migration, 6-14
time required for Export/Import, 2-7
time requirements
export/import, 2-7
TKPROF
performance testing, 2-10
TOUCH comparison operator, A-27
TP monitors, F-3
transaction management
Oracle Call Interface, A-46
triggers
replication, A-28
TRUE keyword
behavior in Oracle8 and Oracle7, 6-8
Trusted Oracle7
migrating with Export/Import utility, 4-2
TS#, A-16
tuning, 5-3
migrated database, 5-3
Tuxedo applications
compatibility with Oracle8 XA libraries, 6-2
relink, 6-2
Tuxedo TP monitor interface, A-40
TWO_TASK, F-3
TWO_TASK variable, 3-8
type auditing, A-44
Type DDL, A-44
type DTYCHR, 7-8
type management
Oracle Call Interface, A-49
type mapping
Oracle Call Interface, A-49
types
new to Oracle8, 6-9
user-defined, A-44


U

UNDO$ dictionary table, A-16
updatable snapshot
constratins, A-29
US7ASCII, 3-7
user authentication
Oracle Call Interface, A-45
USER_INDICES
LOGGING attribute, A-6
USER_PASSWORDS_LIMITS view, A-32
USER_TABLES view
LOGGING attribute, A-6
USER_TABLESPACES view
LOGGING attribute, A-6
MIN_EXTLEN column, A-20
USER_USERS view
new columns, A-32
user-created objects
in SYS schema, 6-12
user-defined types, A-44
utilities
Export, 2-5
Import, 2-5
Migration Utility, 2-3
Recovery Manager, A-33


V

V$LOCK, A-9
V$NLS_PARAMETERS, A-36
V$PQ_SESSTAT
DML Parallelized row, A-7
V$PQ_SYSSTAT
DML Initiated row, A-7
V$SESSION
ENABLE PARALLEL DML column, A-7
V$SESSION_FAILOVER, A-42
V$SORT_SEGMENT, A-16
V$TRANSACTION
STATUS column values, A-7
V_$NLS_PARAMETERS, A-36
validate procedure
replication, A-29
VALUE keyword
behavior in Oracle8 and Oracle7, 6-9
VALUE$
NCHAR and NLS, 6-16
VARCHAR
size, F-4
VARCHAR2
size, F-4
version 6
Export/Import utility and, 4-2
very large database
support, A-42
views
dictionary, A-36
partition, A-13
volume/load stress testing, 2-10


W

W52DEC, 3-7
WITH PRIMARY KEY clause, A-55
WITH ROWID clause, A-55
WRITE procedure
DBMS_LOB package, 6-6


X

XA
calls, 6-2
libraries, 6-2
XA libraries
compatibility between Oracle7 and Oracle8, 6-2




Prev

Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library

Product

Contents