Oracle7 Server Migration Guide
Library
Product
Contents
Index
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
Y
Z
@
access, concurrent
accessing tables, INDEX statement
access, resource limit
ADD_MASTER_DATABASE, new RepCatLog request in 7.3
administration enhancements
in release 7.0
in release 7.2
administrative procedures, develop new
[
2
]
migrated database and
[
2
]
Advanced Replication option
compatibility between release 7.3 and earlier releases
downgrading and
general description of
object groups
release 7.3 replication triggers and packages
replicated table comparison
synchronous propagation
upgrading
ALERT filenames
alerts, PL/SQL
allocation, context areas
ALLOW_OFFLINE, migration parameter
[
2
]
using
ALTER CLUSTER command, syntax
ALTER DATABASE ACTIVATE STANDBY command
ALTER DATABASE BACKUP CONTROLFILE TO TRACE command, downgrading
ALTER DATABASE BACKUP CONTROLFILE TO TRACE, downgrading from 7.3 to 7.1
ALTER DATABASE CLEAR command
ALTER DATABASE CLEAR LOGFILE, downgrading from 7.3 to 7.1
ALTER DATABASE command
migration utility
syntax
ALTER DATABASE CONVERT command, migration utility
[
2
]
ALTER DATABASE MOUNT STANDBY command
ALTER DATABASE OPEN command, downgrading
ALTER DATABASE RECOVER STANDBY DATABASE command
ALTER DATABASE RESET COMPATIBILITY command, downgrading
ALTER DATABASE RESET COMPATIBILITY, downgrading from 7.3 to 7.1
ALTER DATABASE STANDBY CONTROLFILE AS command
ALTER INDEX command
ALTER SESSION command
hash join
syntax
ALTER SNAPSHOT command
ALTER SYSTEM command
ALTER SYSTEM DISABLE RESTRICTED SESSION
downgrading
upgrading
ALTER TABLE command, syntax
ALTER TABLESPACE command, syntax
ALTER USER command, QUOTA
ALTER_MASTER_PROPAGATION
ALTER_TABLESPACE command, online backup
American National Standards Institute (ANSI), integrity constraint compliance of
ANALYZE command
managing indexes
[
2
]
ANALYZE TABLE, histograms
ANALYZE_DATABASE procedure, histograms
ANALYZE_OBJECT procedure, histograms
ANALYZE_SCHEMA procedure, histograms
ANSI SQL92, FIPS flagger
ANSI/ISO
standards and compliance
string comparison
antijoins
invoking
restrictions on use
application developer, role during migration
application registration
applications, migrating
[
2
]
OCI applications
testing
Trusted Oracle7
architecture, TWO-TASK
ARCHIVLOG, online backup
arrays, binding and defining in OCI
AS clause, space requirements
audience for this manual
auditing changes
AUTOEXTEND ON command, downgrading
backup
after migration
before migration
[
2
]
offline
online
ALTER_TABLESPACE command
ARCHIVLOG
BEGIN/END BACKUP command
release 7.0 enhancements
using step 6
batch allocate at insert
BEGIN/END BACKUP command, online backup
block size
DB_BLOCK_SIZE
desktop platforms
blocksize, STARTUP command
blocks, rollback segments
bottlenecks, I/O
buffer cache
DB_BLOCK_BUFFERS
DB_BLOCK_SIZE
redo log
C structs, Pro*C
C++, Pro*C/C++
calendar utility, NLS
call by reference, PL/SQL
CASE applications, migrating
CAT70101.SQL
CAT70102.SQL
parallel query option
CAT7102D.SQL
CAT7103.SQL
CAT7106.SQL
CAT712.SQL
CAT712D.SQL
CAT713.SQL
CAT714.SQL
CAT7201.SQL
CAT7202.SQL
CAT7203.SQL
CAT7301.SQL
CAT7301D.SQL
CAT7302.SQL
CAT7302D.SQL
catalog compatibility, object groups
catalog views, updatable join views
CATALOG.SQL
[
2
]
migration utility
upgrading
CATALOG6.SQL
[
2
]
CATEXP6.SQL, migration utility
CATPARR.SQL, upgrading
CATPROC.SQL, PL/SQL
[
2
]
upgrading
CATREP.SQL, upgrading
CATSVRMG.SQL, Server Manager
CDE
CFILE, migration parameter
[
2
]
CHAR datatype
programmatic interfaces
SQL scripts
character encoding, CREATE DATABASE command
character set, migration utility and
CHECK_ONLY, migration parameter
[
2
]
using option
checkpoint process
checksums, recovery
choose a migration method
choosing a freelist group for inserts
closing database links, distributed option
cluster tables, COPY command
CNVFILE, migration parameter
[
2
]
compatibility
backward in release 7.0
backward in release 7.1
backward in release 7.2
CREATE TABLE...AS SELECT command
master sites
release 7.3
sort direct writes
SQL in version 6
SQL92 and version 7
version 6
COMPATIBLE, disabling 7.2 features and
[
2
]
disabling release 7.2 features
disabling release 7.3 features
downgrading from 7.3 to 7.1
enabling release 7.1 features
enabling release 7.2 features
enabling release 7.3 features
release 7.0 backward compatibility
release 7.1 backward compatibility
release 7.2 backward compatibility
setting at a master definition site
setting at snapshot sites
standby database
compilation of procedural objects, PL/SQL
compiled triggers, changes to data dictionary tables
concurrent users
concurrent, access
configuration utility, NLS
CONNECT command, in 7.0
CONNECT INTERNAL command, downgrading
[
2
]
upgrading
CONNECT privilege
export/import
migration utility
connections
local and remote
with multi_threaded shared server
TWO_TASK architecture with
with SQL*Net
with TP monitors
CONSTRAINT, move constraint identifier
[
2
]
programmatic interfaces
constraints
backward compatibility
enabling
enforced integrity
integrity constraints
location of constraint clause
[
2
]
unique
context areas
allocation of
old terminology
continuous operation, disk capacity, input/output
control file
CONVERT.ORA
migration utility
conventional path
conventions used in this manual
conversion, of data definition
[
2
]
CONVERT.ORA
control file creation
migration utility
specifying filename
[
2
]
Cooperative Development Environment (CDE)
COPY command
copying data
export/import utility vs.
large cluster tables
space requirements
copying data
between versions and releases
COPY command
CREATE TABLE...AS
database links
INSERT INTO
upgrading
cost-based optimization
covert channels, preventing
CPU, resources
[
2
]
CREATE CLUSTER command
HASH IS option
programmatic interfaces
CREATE CONTROLFILE command, downgrading
CREATE DATABASE command, character encoding scheme
CREATE INDEX command
[
2
]
accessing tables
syntax
CREATE ROLLBACK SEGMENT, PCTINCREASE and
CREATE SNAPSHOT command
CREATE TABLE...AS SELECT command
[
2
]
COMPATIBILITY
CREATE TABLE
AS command, copying data
constraint identifier
[
2
]
programmatic interfaces
syntax
CREATE USER command
[
2
]
QUOTA
creating users, 7.0 security enhancements
cursor variables
[
2
]
PL/SQL
cursors
INSERT, DELETE, UPDATE, SELECT
number of open
data definition, conversion
[
2
]
data dictionary
changes in release 7.0
changes in release 7.3
changes in tables for compiled triggers
changes, in release 7.2
conversion of
creation of base tables using Migrate.BSQ
export/import utility
[
2
]
new Trusted Oracle views
views, in release 7.1
views, in release 7.3
data installation utility, NLS
database administrator
fine grained locking
role during migration
database, backing up
[
2
]
crash and media recovery
developing a test plan
links
[
2
]
links and copying data
migrate the production
preserve source
shutting down
[
2
]
specifying name
[
2
]
specifying new name
[
2
]
standby
test the migrated
testing
tune the migrated
[
2
]
tuning
[
2
]
updating link names
[
2
]
datatype
changes, in release 7.0
changes, in release 7.2
character
conversion
LONG and LONG RAW
update
DB_BLOCK_BUFFERS
and shared global area
buffer cache
DB_BLOCK_CHECKSUM
DB_BLOCK_SIZE
blocksize consideration
buffer cache
shared global area
DB_DOMAIN, distributed option
DB_FILE_MULTIBLOCK_READ_COUNT, hash join
DB_VERIFY
DBA
DBA privilege
export/import
migration utility
DBA_SEGMENTS view, space requirements for export/import
DBLINK_ENCRYPT_LOGIN parameter
DBMS_SPACE
space information
DBMS_UTILITY package, histograms
DBMSDFRD.SQL
DBMSJOB.SQL
DBMSSNAP.SQL
DBMSSPEXP.SQL
DBMSSQL.SQL
DBMSUTIL.SQL
DBMSUTIL, space information
DBNAME, migration parameter
[
2
]
deadlock detection, distributed option
deallocation of unused space, space management
default values, enforced
deferred database calls, Oracle Call Interface
deferred RPC
modification to views in Release 7.3
modifications to API in Release 7.3
modifications to tables in Release 7.3
defines, string data
delayed-logging block cleanout, parallel server
delete cascade
DELETE command, SELECT privilege
DELETE cursor
delete rule, updatable join views
DESCRIBE command
programmatic interfaces
SQL*DBA
DIRECT parameter, Direct Path Export
direct path
Direct Path Export
DIRECT parameter
EXP command
migration and compatibility issues
PARAMETER file
DISABLE RESTRICTED SESSION option
disk capacity
and input/output (I/O)
continuous operation
mirroring
Distributed Lock Manager (DLM)
distributed option
closing database links
DB_DOMAIN
deadlock detection
distributed query processing
distributed systems
global naming
installation
[
2
]
LONGs
multi-node read consistency
release 7.0
resolution
snapshot capability
standards compliance
two-phase commit
distributed query processing, distributed option
distributed statements, sequences
distributed systems, distributed option
distributed transaction processing (DTP)
network considerations
distributed transactions (DTP), SQL*Net
DLM
downgrading
Advanced Replication option
ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
ALTER DATABASE OPEN command
ALTER DATABASE RESET COMPATIBILITY
ALTER SYSTEM DISABLE RESTRICTED SESSION
AUTOEXTEND ON
CONNECT INTERNAL
CONNECT INTERNAL command
considerations
copying data
CREATE CONTROLFILE command
from PL/SQL release 2.3
hash clusters
master definition site
master site
PL/SQL Wrapper code
release 7.3 to 7.1
repschemas
resizeable datafiles
RESTRICT_REFERENCES pragma
SHUTDOWN NORMAL
[
2
]
snapshot site
STARTUP NOMOUNT RESTRICT command
STARTUP RESTRICT
synchronous propagation
to previous database
[
2
]
to previous release
UNRECOVERABLE
DROPCAT5.SQL, version 5
DTP
DUMPCF, migration parameter
[
2
]
dynamic initialization parameters
HASH_AREA_SIZE
HASH_JOIN_ENABLED
HASH_JOIN_MULTIBLOCK_IO_COUNT
dynamic performance tables
changes in release 7.3
data dictionary changes
in release 7.1
dynamic SQL
ECHO, migration parameter
[
2
]
embedded statements, SQL
enabling and disabling, release 7.x
enabling constraints
encryption, encrypted passwords
errors during migration
estimating system requirements
EXEC TOOLS, Oracle Forms, Oracle Reports, Oracle Graphics
executables, size of Oracle7
EXP command, Direct Path Export
EXPLAIN PLAN
enhancements to
testing
upgrading
EXPOB6.SQL
EXPORT path
conventional
direct
export/import utility
[
2
]
advantages
[
2
]
changes in 7.0
data dictionary
[
2
]
limitations
[
2
]
migration utility or
[
2
] [
3
] [
4
]
resizeable datafiles
space requirements
[
2
]
time requirements for
Trusted Oracle7 and
using
[
2
]
version 5
when to use
[
2
]
EXPTAB, version 5
EXPVEW6.SQL
EXPVEW, version 5
extents, unlimited
fast access, V$ views
fast recreate index
FCLOSE procedure, PL/SQL file I/O operations
FCLOSE_ALL procedure, PL/SQL I/O operations
fetch from cursor variable, PL/SQL
FFLUSH procedure, PL/SQL file I/O operations
file I/O, PL/SQL
filenames, ALERT
FILEXT$
export utility
resizeable datafiles
fine grained locking
FIPS flagger, interactive SQL statements and
FIPS option, SQL*Module
FOPEN function, PL/SQL file I/O operations
Forms
EXEC TOOLS
migrating Oracle Forms applications
freelist group size determination
functionality enhancements
in release 7.0
in release 7.1
in release 7.2
GENERATE_SUPPORT_PHASE1
GENERATE_SUPPORT_PHASE2
GET_LINE procedure, PL/SQL file I/O
global naming, distributed option
GRANT command
V6 to V7 incompatibilities
Graphics, EXEC TOOLS
hash clusters
downgrading
HASH IS option, CREATE CLUSTER command
hash join
ALTER SESSION command
DB_FILE_MULTIBLOCK_READ_COUNT
HASH_AREA_SIZE command
HASH_JOIN_ENABLED parameter
HASH_MULTIBLOCK_IO_COUNT parameter
SORT_AREA_SIZE
HASH_AREA_SIZE
dynamic initialization parameters
hash join
HASH_JOIN_ENABLED
dynamic initialization parameters
hash join
HASH_MULTIBLOCK_IO_COUNT
dynamic initialization parameters
hash join
hashing
histograms
ANALYZE TABLE
ANALYZE_DATABASE
ANALYZE_OBJECT
ANALYZE_SCHEMA
DBMS_UTILITY
I/O
I/O bottlenecks, distributed transactions, network considerations
I/O, bottlenecks
index storage
index support of freelist groups
indexed fixed tables
indexes, managing, VALIDATE INDEX
[
2
]
INIT.ORA file, backing up
[
2
]
INIT.ORA
files
parameters
initialization parameters
definition
in release 7.0
in release 7.1
in release 7.2
in release 7.3
terminology
input/output (I/O), disk capacity
[
2
]
mirroring
INSERT cursor
INSERT INTO command, copying data
insert rule, updatable join views
installing options
[
2
]
installing Oracle7
[
2
]
instance registration, parallel server
integrity constraints
export/import
migration utility
SQL scripts
when to use
[
2
]
interactive menu
interactive output from stored procedures, PL/SQL
interface enhancements
International Standards Organization (ISO), integrity constraint compliance of
Interoperability
RPC calls
synchronous propagation
INTO parameter, testing
IS_OPEN function, PL/SQL file I/O operations
job queues
KILL SESSION command
SQL*DBA
LANGUAGE parameter, migration utility and
links, updating link names
[
2
]
literal strings
load balancing in listener
MTS_LISTENER_ADDRESS
network manager tool
parallel server
local connections, multi-threaded shared servers
locks
recovery
table
LOG_BLOCK_CHECKSUM
LOG_BUFFER, shared global area
LONGs, distributed option
LRU latch scalability
massively parallel processors (MPP)
master definition site
COMPATIBILITY setting at
downgrading
master site, downgrading
master sites, COMPATIBILITY
MAXEXTENTS
illegal storage parameters
not applied in 7.0
media failure (disk failure), mirrored online redo log files and
media recovery, and database crash
memory requirements
concurrent access
shared pool
messages
MIGFILE, migration parameter
[
2
]
MIGRATE user
dropping
[
2
]
renaming
migrate your production database
MIGRATE.BSQ
create data dictionary base tables
migration utility
parallel query option
specifying filename
[
2
]
migrating, applications
[
2
]
CASE applications
errors during
from single instance to parallel server
general comments
[
2
]
OCI applications
[
2
]
Oracle Forms applications
overview
precompiler applications
[
2
]
preserve the source database
process
production database
programmatic interfaces
rehearsing
role of application developer
role of database administrator
SQL*Net
SQL*Plus scripts
SQL*Report reports
SQL*ReportWriter reports
steps for
testing plans
to a different computer architecture
with offline tablespaces
migration and compatibility issues
Direct Path Export
object groups
standby database
migration steps, step 1, prepare to migrate
[
2
]
step 2
[
2
]
step 3
[
2
]
step 4
preserve the source database
[
2
]
step 5
migrate the source database (using export/import)
[
2
]
migrate the source database (using the migration utility)
[
2
]
step 6
[
2
]
migration utility
ALTER DATABASE command
ALTER DATABASE CONVERT
[
2
]
CATALOG.SQL
CATEXP6.SQL
character set used
conversion of files
CONVERT.ORA
data dictionary conversion
errors and messages
export/import utility or
[
2
]
MIGRATE.BSQ
migrating the source database
[
2
]
migrating to a different architecture
overview
parameters
[
2
]
privileges needed to run
rerunning
space requirements
Trusted Oracle7 and
using
[
2
] [
3
] [
4
]
VARCHAR2
version 6 to Oracle7
version 7 control file
when to use
[
2
]
migration
choosing a method for
comparison of methods
new administrative procedures
[
2
]
object groups
sort direct writes feature
mirrored redo log files
mirroring
disk capacity
input/output
MLSLABEL
MODE option, SQL*MODULE
monitor commands, SQL*DBA
MPP
MTS_LISTENER_ADDRESS parameter, load balancing in listener
multi-byte NLS, standards compliance and
multi-node read consistency, distributed option
multi-threaded server
architecture
shared
shared and local/remote connections
SQL*Net
MULTISUBPROG, Pro*FORTRAN
N-way master configuration, synchronous propagation
national language character (NLC)
national language support (NLS)
calendar utility
configuration utility
data installation utility
enhancements in 7.2
extended
network manager tool, load balancing in listener
network
authentication
considerations
distributed transactions
security
new features, adding
[
2
]
NEW_DATABASE, migration parameter
[
2
]
NEW_LINE procedure, PL/SQL file I/O operations
NLC
NLS
[
2
]
NO_SPACE_CHECK, migration parameter
[
2
]
non-blocking OCI
OLOG
ONBCLR
ONBSET
ONBTST
NOT NULL constraints
NTT MIA, Pro*COBOL, Pro*C/C++
object groups
Advanced Replication option
catalog compatibility
migration and compatibility issues
migration to
modifications to deferred RPC API
modifications to deferred RPC tables
modifications to deferred RPC views
object privileges, 7.0 security enhancements
OBNDRA
OBNDRN
OBNDRV
OCI
OCI calls
OBNDRA
OBNDRV/OBNDRN
ODESCR
ODSC
OFLNG
OPARSE
ODESCR
ODSC
offline tablespaces
OFLNG
OLOG, non-blocking OCI
OLQP
OLTP
ONBCLR
ONBSET, non-blocking OCI
ONBTST, non-blocking OCI
online redo log files, mirrored
online tablespaces
[
2
]
OPARSE
operational efficiency, parallel query option
OPS, Oracle Parallel Server
optimization, rule based
optimizer
OPTIMIZER_MODE
options, installing
[
2
]
ORA_ENCRYPT_LOGIN variable
ORA_TQ_BASE$, parallel query option
Oracle Call Interface (OCI)
binding and defining arrays
deferred database calls
migrating applications
new features
non-blocking
[
2
]
OCI applications
preparing to migrate applications
Version 6 OCI (HLI) and
Oracle Call Interface, thread safety
Oracle Forms
Oracle Installer
Oracle names, SQL*Net
Oracle Office, link to
Oracle Parallel Server (OPS)
Oracle Precompilers, standards compliance
Oracle TRACE
Oracle7
executables
features
functionality
installing
[
2
]
parallel query features
programmatic interfaces
outer joins
packages, PL/SQL
parallel cache monitoring (PCM)
parallel direct loads, SQL*Loader
parallel query affinity, parallel server
parallel query option
CAT70102.SQL
CREATE TABLE...AS SELECT
features
MIGRATE.BSQ
operational efficiency
ORA_TQ_BASE$
SQL.BSQ
parallel recovery
parallel server
configuring the Distributed Lock Manager
delayed-logging block cleanout
enhancements
enhancements in 7.2
fine grained locking
instance registration
load balancing in listener
migrating from single instance to
option
parallel query affinity
tuning
parallelism
definition
PARAMETER file, Direct Path Export
parameter files (INIT.ORA), backing up
[
2
]
definition
obsolete parameters
[
2
]
specifying filename
[
2
]
terminology change
parameters, migration utility
[
2
]
password encryption
PCM
PCTINCREASE
change in use of in 7.0
no longer specified in CREATE ROLLBACK SEGMENT
not applied in 7.0
performance enhancements
in release 7.0
in release 7.2
performance testing
SQL_TRACE
TKPROF
PFILE, migration parameter
[
2
]
PGA
piecewise binds, string data
ping, efficiency
pipes, PL/SQL
PL/SQL
alerts
call by reference
CATPROC.SQL
[
2
]
compilation of procedural objects
cursor variables
downgrading from release 2.3
enhancements in 7.1
fetch from cursor variable
file I/O
FCLOSE
FCLOSE_ALL
FFLUSH
FOPEN
GET_LINE
IS_OPEN
NEW_LINE
PUT
PUT_LINE
PUTF
functions called from SQL
functions
installation
[
2
]
interactive output from stored procedures
language changes in release 7.0
packages
pipes
remote dependencies
restrictions on functions
stored procedures
tables of records
triggers
upgrading to release 2.3
using functions
Wrapper
downgrading to earlier release
precompilation, C++ in Pro*C/C++, C++ in SQL*Module
precompiler applications
compatibility mode
migrating
new features
preparing to migrate
precompilers
new features in release 1.5
new features in release 1.6
new features in release 1.7
previous database, downgrading to
[
2
]
PRIMARY KEY option, changing unique indexes
privileges, migration utility requirements
Pro*C/C++
C++ precompilation
integration testing
NTT MIA
release 7.2 datatype changes
standards compliance
[
2
]
VARCHAR recognition
version 2
Pro*COBOL
NTT MIA
release 7.2 datatype changes
SQL standards conformance
standards compliance
VARCHAR recognition
Pro*FORTRAN, release 1.6, MULTISUBPROG
Pro*, thread safety
procedural option
profiles
[
2
]
program global area (PGA)
SORT_AREA_SIZE parameter
programmatic interfaces
changes under Oracle7
CHAR
CONSTRAINT
CREATE CLUSTER
CREATE TABLE
migrating
PRVTDFRD.PLB
PRVTJOB.PLB
PRVTPEXP.PLB
PRVTSNAP.PLB
PRVTSQL.PLB
PUBLIC quotas
PUT procedure, PL/SQL file I/O operations
PUT_LINE procedure, PL/SQL file I/O operations
PUTF procedure, PL/SQL file I/O operations
query coordinator, definition
query execution enhancements, sort big keys
query server, definition
QUOTA, CREATE USER, ALTER USER
raw data
defines
piecewise binds
read only tablespaces
recoding Version 6 applications
RECOVER STANDBY DATABASE command
RECOVERABLE
recovery
capabilities in release 7.0
checksums
enhancements in release 7.2
parallel
parallel server enhancements in 7.0
release 7.0 enhancements
redo log
buffer cache
files, mirrored online
refresh group
release 7.0
administration enhancements
backup enhancements
backward compatibility
changes in SQL*DBA
changes to export/import utility
changes to SQL*Loader
changes to views
CONNECT command
creating users
data dictionary changes
dynamic performance tables
functionality enhancements
initialization parameters
language changes
new and renamed SQL scripts
new features in Oracle precompilers, release 1.5
other changes
parallel server enhancements
performance enhancements
recovery capabilities
recovery enhancements
resource limits
RESTRICTED SESSION
security enhancements
SHUTDOWN command
SQL command changes
STARTUP command
views
release 7.1
backward compatibility
COMPATIBLE
data dictionary views
disabling features
distributed option
dynamic performance tables
functionality enhancements
initialization parameter changes
new features in Oracle precompilers, release 1.6
PL/SQL enhancements
SQL syntax changes
supplied packages
release 7.2
administration enhancements
backward compatibility
changed SQL scripts
COMPATIBLE
[
2
]
data dictionary changes
datatype changes
disabling features
enabling features
functionality enhancements
initialization parameters
new features in Oracle precompilers, release 1.7
NLS enhancements
other changes
parallel server enhancements
performance enhancements
recovery enhancements
security enhancements
SQL changes
standards compliance
Trusted Oracle7 views
release 7.3
COMPATIBLE
disabling features
enabling features
new RepCatLog request
replication triggers and packages
release 7.x, enabling and disabling features
remote connections
multi-threaded shared servers
security
remote dependencies, PL/SQL
remote procedure calls (RPC)
REMOTE_DEPENDENCIES_MODE parameter
REP$WHAT AM I package
REPCAT$_REPPROP
REPCAT$_REPSCHEMA
RepCat
procedure changes
table modifications
view modifications
replicated table comparison, Advanced Replication option
replication
Reports, EXEC TOOLS
repschemas, downgrading to
reserved words, new
resilvering
resizeable datafiles
description of
downgrading after using
export/import and
FILEXT$
resolution, distributed option
resource limits
in release 7.0
RESOURCE privilege
export/import
migration utility and
RESTRICT_REFERENCES, downgrading from 7.1
RESTRICTED SESSION, 7.0 security enhancements
role
of application developer
of database administrator
roles
predefined
rollback segments
blocks in
conversion of
[
2
]
ROWID, change in format
ROWLABEL
ROWLABLE, addition of column
RPC
RPC calls, interoperability
scalability, LRU latch
schema
definition
explanation of terminology
objects
SCN
scripts, change SQL scripts in migration
[
2
]
SQL in release 7.0
security
connecting to remote databases
enhancements in release 7.0
enhancements in release 7.2
SQL92 compliance
SELECT *, in view definitions
SELECT command, AS keyword
SELECT cursor
SELECT privilege, for update and delete statements
sequences, distributed statements
SERIALIZABLE mode, compatibility with SQL92
Server Manager
CATSVRMGR.SQL
server process
definition
new terminology
session
definition
explanation of terminology
SET ROLE
SGA
shadow processes
old terminology
open cursors and
shared global area
shared global area (SGA)
size of
shared global area
DB_BLOCK_BUFFERS
LOG_BUFFER
SHARED_POOL_SIZE
shared pool area, SHARED_POOL_SIZE
shared pool, memory requirements
shared SQL areas
definition
new terminology
SHARED_POOL_SIZE
shared global area
shared pool area
upgrading
SHUTDOWN command, in release 7.0
SHUTDOWN NORMAL command, downgrading
[
2
]
upgrading to a new release
shutting down the database
[
2
]
SMP
snapshot capability, distributed option
snapshot refresh
snapshot site, downgrading
snapshot sites, setting COMPATIBLE at
snapshot, adding with synchronous propagation
snapshots, semantics for in Release 7.3
sort big keys, query execution enhancements
sort direct writes feature
compatibility and migration
performance benefits
performance tradeoffs
sort direct writes, compatibility
sort segment, space management
SORT_AREA_SIZE
hash join
program global area
SPA
space information
DBMS_SPACE
DBMSUTIL
displaying
space management
deallocation of unused space
sort segment
tablespace coalesce
unlimited extents
space requirements
COPY command
DBA_SEGMENTS view
export/import
[
2
]
migration utility
USER_SEGMENTS view
SPOOL parameter, migration parameter
[
2
]
SQL*DBA
changes in 7.0
DESCRIBE command
KILL SESSION command
monitor commands
SQL*Loader
changes in 7.0
parallel direct loads
SQL*Module
C++ precompilation
FIPS option
MODE option
WITH INTERFACE
[
2
]
WITH INTERFACE clause
SQL*Net
distributed transactions (DTP)
migrating
multi-threaded server
Oracle names
SQL*Plus scripts
migrating
Oracle7 functionality
V6 compatibility mode
SQL*Report reports, migrating
SQL*ReportWriter reports, migrating
SQL.BSQ, parallel query option
SQL92, compatibility with version 7
SQL_TRACE, performance testing
[
2
]
remote sessions
SQL
changed scripts in release 7.2
changes in release 7.2
command changes in 7.0
compatibility in version 6
dynamic
embedded statements
enhancements in 7.1
SQLLIB, new routines
SQL
new and renamed scripts in 7.0
referencing PL/SQL functions in
scripts
[
2
]
shared areas
standards compliance
statements, and integrity constraints
syntax
syntax changes in release 7.1
standards compliance
distributed option
in release 7.2
multi-byte NLS and
Pro*C/C++
Pro*C/C++, Release 2.1
Pro*COBOL
release 7.1
SQL
Trusted Oracle7
XA interface
standby database
COMPATIBLE
general description
migration and compatibility
STARTUP command
CONNECT INTERNAL
in release 7.0
NOMOUNT option
STARTUP NOMOUNT RESTRICT command, downgrading
STARTUP RESTRICT command
downgrading
upgrading
storage parameters, illegal MAXEXTENTS
stored procedures
interactive from
PL/SQL
string data
defines
piecewise binds
subqueries, in FROM clause
supplied packages, in release 7.1
symmetric multi processors (SMP)
symmetric replication
[
2
]
definition
general description of
migrating a version 6 database
synchronous propagation
adding a snapshot
Advanced Replication option
creating a N-way master configuration
downgrading to Release 7.2
interoperability
semantics for Release 7.3 snapshot sites
SYS password, migration utility
System Change Numbers (SCN), recovery
SYSTEM password, migration utility
system privileges, 7.0 security enhancements
system requirements, estimation of
system security
SYSTEM tablespace, migration utility
tables of records, PL/SQL
tables
dynamic performance in 7.0
integrity constraints
tablespace coalesce, space management
tablespaces
assigning quotas
conversion of
[
2
]
offline
quotas
read only
terminology
[
2
]
testing
applications
before migrating
comparing results
develop a plan
EXPLAIN PLAN
functional
integration
INTO parameter
migration
minimal
performance
pre- and post-migration
volume/load stress
thread safety
Oracle Call Interface
Pro*
THREADS option
time requirements, export/import
TKPROF, performance testing
TP monitors
TRACE
TRACE files
transaction isolation
transaction trace facility
triggers, PL/SQL
TRUNCATE command
Trusted Oracle7
mapping of labels during import
migrating applications
migrating with export/import
migrating with migration utility
standards compliance
upgrading scripts
views in 7.2
trusted stored procedures
tuning
[
2
]
migrated database
[
2
]
parallel server
two-phase commit, distributed option
unique indexes
PRIMARY KEY option
UNIQUE option
use of
[
2
]
UNIQUE option, changing unique indexes
UNIX, SGA and
unlimited extents, space management
UNRECOVERABLE
[
2
] [
3
]
downgrading
UNSAFE_NULL_FETCH command
updatable join views
catalog views
delete rule
insert rule
update rule
UPDATE command, SELECT privilege
UPDATE cursor
update rule, updatable join views
upgrading
Advanced Replication option
ALTER SYSTEM DISABLE RESTRICTED SESSION
CATALOG.SQL
CATPARR.SQL
CATPROC.SQL
CATREP.SQL
CONNECT INTERNAL
considerations
copying data
EXPLAIN PLAN
SHARED_POOL_SIZE
SHUTDOWN NORMAL
STARTUP RESTRICT
to a new release
to PL/SQL release 2.3
UTLXPLAN.SQL
user definitions
user groups, roles and
USER keyword, definition in Version 7
user process, terminology change
user session, terminology change
USER_SEGMENTS view, space requirements for export/import
usernames, database
profiles and
resource limit
utilities, changes
UTLXPLAN.SQL, upgrading
V$ views, indexed fixed tables and
V$INDEXED_FIXED_COLUMN view
V$RECOVER_FILE_STATUS view
V$RECOVERY_STATUS view
V$SESSION, index fixed tables
V$SESSTAT, index fixed tables
V$SQLAREA, index fixed tables
V6 compatibility mode, SQL*Plus scripts
VALIDATE INDEX command, managing indexes
[
2
]
VALIDATE INDEX, replaced by ANALYZE
VARCHAR
VARCHAR datatype
C structs
Pro*C
Pro*COBOL
recognition
VARCHAR2 datatype
[
2
]
export/import
migration utility
programmatic interfaces
reserved word
version 5
DROPCAT5.SQL
export/import utility and
EXPTAB
EXPVEW
version 6
compatibility
do not open after running migration utility
OCI calls
precompilers and
retaining behavior
very large database (VLDB)
views
changes in 7.0
creating with errors
in release 7.0
new Trusted Oracle views
replacing
SELECT *
still valid after changing table
Trusted Oracle7
VLDB
volume/load stress testing
WITH INTERFACE clause, SQL*Module
XA
interface, standards compliance
library
recovery enhancements