Oracle8i Generic Documentation Master Index
Release 2 (8.1.6)

A76991-01

Library

Product

Contents

Prev Up Next

Oracle8i Generic Documentation Master Index


T

T variable in SQLDA
how value is set, PC_ 15-9
purpose of, PC_ 15-9
Taable and index structures, ADQ 5-2
TAB view, SRF 2-164
table (host) elements
maximum, PCO 7-3
TABLE clause
of DELETE, SQL 7-467
of INSERT, SQL 7-542
of SELECT, SQL 7-576
of TRUNCATE, SQL 7-612
of UPDATE, SQL 7-617, SQL 7-618
table constraints
defined, SQL 7-233
of ALTER TABLE, SQL 7-141
of CREATE TABLE, SQL 7-393
TABLE datatype, PLS 4-2
table lock
acquiring with LOCK TABLE, PCO 3-23
exclusive, PCO 3-23
row share, PCO 3-23
when released, PCO 3-23
table locks, PSA 7-17, PSC 4-7
acquiring with LOCK TABLE, PC_ 3-25
disabling, SQL 7-165
duration of, SQL 7-547
effect of, PC_ 3-25
enabling, SQL 7-165
EXCLUSIVE, SQL 7-548
modes of, SQL 7-548
on partitions, SQL 7-548
on remote database, SQL 7-548
on subpartitions, SQL 7-548
and queries, SQL 7-547
ROW EXCLUSIVE, SQL 7-548
ROW SHARE, SQL 7-548
row share, PC_ 3-25
SHARE, SQL 7-548
SHARE ROW EXCLUSIVE, SQL 7-548
SHARE UPDATE, SQL 7-548
when released, PC_ 3-26
TABLE operator, PLS 4-18
table- or view-based security, ADG 11-35
table queues, DWG 18-71
table REF constraints, SQL 7-234, SQL 7-242
of ALTER TABLE, SQL 7-140
of CREATE TABLE, SQL 7-393
TABLE syntax, ADO 6-12
TABLE_LOCK column, PSA 10-4
TABLE_PRIVILEGE_MAP table
access privilege codes, SRF 2-165
TABLE_PRIVILEGES view, SRF 2-164
table-level Export, SUT 1-8
table-level Import, SUT 2-5, SUT 2-31
table-mode Export
specifying, SUT 1-25
table-mode Import
examples, SUT 2-33
tables, SUT 2-60
adding rows to, SQL 7-540
Advanced Queuing
exporting, SUT 1-59
importing, SUT 2-58
affect dependent views, SCN 111
aliases, SQL 2-82
in CREATE INDEX, SQL 7-298
in DELETE, SQL 7-467
allocating extents, PSA 8-12, PSC 7-24, SAD 13-13
allocating extents for, SQL 7-150
altering, ADG 2-9, SAD 13-11, SAD 13-12
analyzing statistics, SAD 19-3
appending rows with SQL*Loader, SUT 5-33
assigning to a cluster, SQL 7-401
attributes, OCI 6-7
auditing, SCN 11-63, SCN 336
base, SCN 1-23
data dictionary use of, SCN 2-3
relationship to views, SCN 10-13
changing degree of parallelism on, SQL 7-164
changing existing values in, SQL 7-616
cluster, PSA 8-5
clustered, SCN 10-49
clustered (hash). See hash clusters
clustered (index). See clusters.
collecting modification statistics on, SQL 7-152
collecting statistics on, SQL 7-203
comparing, SPR 34-3, RAR 8-53
constraining, ADG 13-22
contain integrity constraints, SCN 1-57
contained in tablespaces, SCN 10-5
contention, PSA 8-11, PSC 7-6
continuing a multiple-table load, SUT 5-35
continuing a single-table load, SUT 5-34
controlling space allocation for, SCN 10-4, SCN 153
creating, ADG 2-3, ADG 2-4, SAD 13-9, SQL 7-390
multiple, SQL 7-369
creating comments about, SQL 7-228
data dictionary, SRF 2-2
deallocating unused space from, SQL 7-150
default physical attributes
changing, SQL 7-145
defining before Import, SUT 2-13
definitions
creating before Import, SUT 2-13
degree of parallelism
specifying, SQL 7-390
DELETE, PSA 5-4
describing, OCI 6-2
designing, ADG 2-3
designing before creating, SAD 13-2
detail tables, DWG 8-7
differences between, RAR 7-41
dimension tables (lookup tables), DWG 8-7
dimensions
star queries, DWG 16-2, STU 4-62
directories, SCN 4-4
disassociating statistics types from, SQL 7-501
DML locks, SRF 1-36
drop column support, GTK 3-41
dropping, ADG 2-10, SAD 13-16
along with cluster, SQL 7-473
along with owner, SQL 7-510
indexes of, SQL 7-501
partitions of, SQL 7-501
dropping columns, SAD 13-14
marking unused, SAD 13-14
remove unused columns, SAD 13-15
removing, SAD 13-14
DUAL, SCN 2-7
dynamic partitioning, SCN 162
elements, PCO 7-2
enable or disable constraints, SCN 276
enabling parallelism for, DWG 18-6
estimating size, SAD 13-4
exclusive access during direct path loads
SQL*Loader, SUT 8-25
exporting
specifying, SUT 1-25
fact tables, DWG 8-7
star queries, DWG 16-2, STU 4-62
formatter in Oracle Trace, STU 14-5
free lists, SRF 1-28
free space unavailable, PSA 8-9
full table scan and buffer cache, SCN 7-4
granting
system privileges on, SQL 7-526
guidelines, ADG 2-2, ADG 2-4
guidelines for managing, SAD 13-1, SAD 13-6, SAD 13-26
hash, SCN 10-59
hash clustered. See hash clusters
historical, SCN 195
moving time windows, SAD 15-33
how data is stored in, SCN 10-4
importing, SUT 2-27
in PL/SQL, ADG 9-9
increasing column length, ADG 2-9, SAD 13-11
indexes and, SCN 10-23
index-organized, ADG 6-1 to ADG 6-20, SAD 13-17 to SAD 13-26
creating, SQL 7-396
key compression in, SCN 10-33, SCN 10-41
overflow segment for, SQL 7-397
space in index block, SQL 7-397
index-organized tables, SCN 10-39
logical rowids, SCN 10-42, SCN 12-20
initial storage, PSA 8-11, PSC 7-25
INSERT, PSA 5-4
insert triggers
direct path load in SQL*Loader, SUT 8-22
inserting rows into, PC_ F-67, PCO F-55
inserting rows using SQL*Loader, SUT 5-32
inserting rows with a subquery, SQL 7-409
integrity constraints, SCN 252, SCN 255
intersection, REP 3-15
key-preserved, ADG 2-22, SAD 18-6
limiting indexes on, SAD 14-4
loading data into more than one table using SQL*Loader, SUT 5-51
loading data into tables, SUT 5-32
loading object tables, SUT 5-95
LOB storage of, SQL 7-394
locating free space, SRF 1-47
location, ADG 2-4
location of, SAD 13-3
lock, PSC 4-4
locking, SQL 7-547
locks, PSA 7-17, PSC 4-13
locks on, SCN 11-45, SCN 231, SCN 234, SCN 235
locks, disabling, PSA 10-4
logging
insert operations, SQL 7-152
table creation, SQL 7-395
lookup tables, STU 4-62
lookup tables (dimension tables), DWG 16-2
maintaining consistency, SUT 1-17
managing, SAD 13-1
manually ordering for Import, SUT 2-14
master table
Import, SUT 2-48
maximum number of columns in, SCN 10-13
migrated and chained rows in, SQL 7-207
modifying
without replicating changes, REP 6-17
moving to a new segment, SQL 7-144
multiple files, PSA 8-11
mutating, ADG 13-22
name restrictions
Export, SUT 1-26
Import, SUT 2-27
nested, PC_ 18-2
creating, SQL 7-444
exporting, SUT 1-59
importing, SUT 2-56
storage characteristics, SQL 7-400
nested tables, ADO 1-9, SCN 10-10, SCN 13-12
indexes, ADO 2-4
no-logging mode, SCN 151
normalized or denormalized, SCN 1-28, SCN 10-20
object
creating, SQL 7-381
See object tables
object import order, SUT 2-3
object tables, ADO 1-5, SCN 13-3, SCN 13-8
constraints, ADO 2-3
indexes, ADO 2-4
triggers, ADO 2-5
virtual, ADO 5-2, SCN 14-2
order of row storage, SQL 7-396
ordering rows from, SQL 7-409
overlapping, PSA 5-9
overview of, SCN 1-22, SCN 10-3
parallel creation, SCN 188
parallel creation of, SQL 7-405
parallel DDL storage, SCN 190
parallel table scans, SCN 160
parallelism
setting default degree, SQL 7-405
parallelizing creation of, SAD 13-4
partition attributes of, SQL 7-155
PARTITION clause, SCN 11-63
partitioned, NLS 4-9, SAD 15-2 to SAD 15-35, SUT 1-8, SUT 2-5
allowing rows to move between partitions, SQL 7-164
default attributes of, SQL 7-155
see also partitioned tables
partitioned and indexes, REP A-8
partitioned in DB2
no Oracle equivalent, SUT B-4
partition-extended table names, SCN 11-63
partitioning, PSA 5-15
partitioning of, SQL 2-70, SQL 7-390
partitions, SCN 11-2, SCN 11-26
PCM locks, PSA 8-9, PSC 7-21
physical attributes
changing, SQL 7-145
specifying, SQL 7-393
placement on disk, STU 20-21
presented in views, SCN 10-12
privileges for creation, ADG 2-8, SAD 13-9
privileges for dropping, ADG 2-11, SAD 13-15
privileges for partitions, SCN 11-62
privileges on, SCN 307
privileges to alter, ADG 2-10, SAD 13-11
problems generating replication support for, REP B-4
qualifying column names, ADO 2-6, ADO 2-7
queue tables, SCN 70, SCN 79
read-only, PSA 5-3
recovery of dropped, SBR 6-15
rectifying, SPR 34-6, RAR 7-41, RAR 8-56
refreshing in data warehouse, SCN 194
relational
creating, SQL 7-381
remote, accessing, SQL 7-273
removing from the database, SQL 7-501
removing rows from, SQL 7-465
renaming, SQL 7-153, SQL 7-554
reorganizing, REP A-8
replacing rows using SQL*Loader, SUT 5-33
replicating, SCN 1-36
replication, REP 2-15
restricting
records per block, SQL 7-153
references to, SQL 7-242
retrieving data from, SQL 7-572
row locking, SRF 1-106
rows
ordering by primary key, SQL 7-396
saving blocks in a cache, SQL 7-151, SQL 7-408
schema of clustered, ADG 5-16
SELECT, PSA 5-4
separating from indexes, SAD 13-5
single-table hash clusters, SCN 10-61
size
USER_SEGMENTS view, SUT 1-9
specifying PCTFREE for, ADG 2-5, SAD 12-4
specifying PCTUSED for, ADG 2-6
specifying table-mode Export, SUT 1-25
specifying tablespace, ADG 2-4, SAD 13-3
specifying tablespaces for, SCN 10-5
SQL examples, SQL 7-410
SQL*Loader method for individual tables, SUT 5-40
storage characteristics, SQL 7-605
defining, SQL 7-390, SQL 7-394
STORAGE clause with parallel execution, SCN 190
striping examples, STU 20-23
subpartition attributes of, SQL 7-155
SUBPARTITION clause, SCN 11-63
summary or rollup, SCN 188
synonyms for, SQL 7-377
system
incremental export, SUT 1-51
SYSTEM tablespace and, SAD 13-3
table items as arrays, SPR 51-15
tablespace, PSC 7-6
tablespace for
defining, SQL 7-390, SQL 7-394
temporary, GTK 3-42, SAD 13-10, SCN 10-11
duration of data, SQL 7-401
segments in, SCN 4-20
session-specific, SQL 7-391
transaction specific, SQL 7-391
temporary space and, SAD 13-6
transaction parameters, SAD 13-3
triggers used in, SCN 82
truncating, ADG 2-10, SAD 19-10
SQL*Loader, SUT 5-33
unclustering, SQL 7-472
UNRECOVERABLE, SAD 13-4
UPDATE, PSA 5-4
updating comments, RAR 7-45
updating existing rows using SQL*Loader, SUT 5-33
updating rows in, PC_ F-111, PCO F-86
validate or novalidate constraints, SCN 276
validating structure, SAD 19-9
validating structure of, SQL 7-206
virtual or viewed, SCN 1-23
with LOB columns
partitioning, SCN 11-37
with unusable indexes, SQL 7-94
tables of group items, PCO A-3
TABLES parameter
Export, SUT 1-25
Import, SUT 2-27
tables, host, PCO 7-2
tablespace
backup, PSC 1-5
creating, PSC A-20
data files, PSC A-20
dropping, PSC A-20
recovery, PSC A-24
taking offline, PSC A-20, PSC A-21
temporary, ADL 10-8
temporary LOB data stored in temporary, ADL 10-7
tablespace backups
using RMAN, RMN 5-5, RMN 5-6
TABLESPACE clause, STU 20-24
CREATE TABLE statement, STU 20-24
of CREATE CLUSTER, SQL 7-257
of CREATE INDEX, SQL 7-300
of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-336
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-322
of CREATE ROLLBACK SEGMENTS, SQL 7-367
of CREATE TABLE, SQL 7-394
tablespace point-in-time recovery, GTK 4-6, SBR 7-25
advantages, SBR 7-2
clone database, SBR 7-4, SCN 5-8
different methods, SBR 7-25
introduction, SBR 7-2
limitations, SBR 7-5
methods, SBR 7-3
O/S, SBR 7-3
performing, SBR 7-1 to SBR 7-26
planning for, SBR 7-4
preparing, SBR 7-6
procedures for using transportable tablespace feature, SBR 7-26
requirements, SBR 7-6
restrictions, SBR 7-5
terminology, SBR 7-4
transportable tablespace method, SBR 7-3, SBR 7-25
tuning considerations, SBR 7-23
backup control files, SBR 7-24
recovery set location, SBR 7-23
using RMAN, RMN 1-63
introduction, RMN 8-2
performing, RMN 8-10
planning for, RMN 8-4
preparing the auxiliary instance, RMN 8-7
recovery sets containing whole tables, RMN 8-6
restrictions, RMN 8-4
tuning considerations, RMN 8-13
tablespace set, SAD 9-29
tablespaces, OID 12-8, SCN 3-6, SQL 7-180
active rollback segments, PSC 7-6
adding datafiles, SAD 10-5
adding to primary database
effect on standby, SBY 4-10
allocating space for users, SQL 7-453
allowing write operations on, SQL 7-181
altering storage settings, SAD 9-12
assigning defaults for users, SAD 22-16
assigning user quotas, SAD 9-3
backing up, SBR 3-7, SBR 4-8
frequency, SBR 3-7
offline, SBR 4-12
online, SBR 4-8
backing up datafiles of, SQL 7-180
backing up on a standby database
in read-only mode, SBY 4-17
when shut down, SBY 4-17
balancing, OID 13-9
bringing online, SQL 7-180, SQL 7-422
checking default storage parameters, SAD 9-40
coalescing free extents, SQL 7-181
coalescing free space, SAD 9-12
compatibility, MIG 9-9, MIG 9-23
contrasted with schemas, SCN 10-2
converting
from permanent to temporary, SQL 7-181
from temporary to permanent, SQL 7-181
creating, OID 10-5, PSA 9-2, SQL 7-420
creating, example, DWG 14-11
datafile
adding, SQL 7-179
renaming, SQL 7-179
dedicated temporary, DWG 18-51
default for object creation, SCN 1-41, SCN 292
default quota, SAD 22-17
default storage characteristics, SQL 7-605
defining as read only, SQL 7-181
deleting, SBY 5-25
described, SCN 3-6
design, for access distribution, PSA 6-16
designing media recovery, SQL 7-12
dictionary managed, SAD 9-5 to SAD 9-6
dictionary-managed, SCN 3-8
dictionary-mapped, STU 20-29
dropping, PSA 9-2, SAD 9-22
dropping during import, SUT 2-51
dropping the contents of, SQL 7-504
DRSYS, PSG 1-12
enable autoextension of, SQL 7-179
expanding for large sorts, PSG 1-12
Export, SUT 1-50
extent management of, SQL 7-425
extent size of, SQL 7-421
granting
system privileges on, SQL 7-527
guidelines for managing, SAD 9-2
how specified for tables, SCN 10-5
in replication, OID 10-5
index data, PSA 7-14
INDX, PSG 1-12
listing files of, SAD 9-41
listing free space in, SAD 9-41
locally managed, GTK 3-41, SAD 9-6 to SAD 9-8, SQL 7-422, SQL 7-606
DBMS_SPACE_ADMIN package, SAD 9-23
detecting and repairing defects, SAD 9-23
tempfiles, SAD 9-9
temporary, SAD 9-9, SQL 7-425
locally-managed, SCN 3-8
temporary tablespaces, SCN 3-13
location, SAD 10-4
locks on, SCN 241
logging attribute of, SQL 7-178, SQL 7-421
managed using dictionary tables, SQL 7-422
managing extents of, SQL 7-422
metadata
transporting, SUT 2-30
migrating offline tablespaces, MIG 4-10, MIG 5-8
monitoring, SAD 10-13
moving or copying to another database, SCN 3-14
no-logging mode, SCN 151
of session duration, SQL 7-424
offline, PSC 7-6, SCN 1-6, SCN 3-9, SCN 3-17
and index data, SCN 3-10
cannot be read-only, SCN 3-11
remain offline on remount, SCN 3-10
OLTS_ATTR_STORE, OID 12-12
OLTS_CT_CN, OID 12-12
OLTS_CT_DN, OID 12-12
OLTS_CT_OBJCL, OID 12-12
OLTS_CT_STORE, OID 12-12
OLTS_DEFAULT, OID 12-12
OLTS_IND_ATTRSTORE, OID 12-12
OLTS_IND_CT_DN, OID 12-12
OLTS_IND_CT_STORE, OID 12-12
online, SCN 1-6, SCN 3-9, SCN 3-17
online read-only, GTK 3-42
online rollback segments, PSA 3-4, PSA 3-6
overview of, SCN 1-5, SCN 3-6
parallel backup, PSA 13-16
parallel recovery, PSA 14-7
permanent objects in, SQL 7-422
point-in-time recovery, GTK 4-6
privileges for creating, SAD 9-4
privileges to take offline, SAD 9-15
quotas
assigning, SAD 9-3
quotas for users, SAD 22-17
quotas on, SCN 1-41, SCN 1-42, SCN 292, SCN 293
limited and unlimited, SCN 293
no default, SCN 293
RBS, PSG 1-12
read-only, PSA 9-7, SCN 3-11
backing up, RMN 5-16, SBR 4-7
dropping objects from, SCN 3-12
effect on recovery, SBR 5-4
Import, SUT 2-51
making read-only, SAD 9-18
making writable, SAD 9-20
on a WORM device, SAD 9-21
recovery, SBR 5-4
transition mode, SCN 3-11
read-write
backing up, SBR 4-6
recovering, SQL 7-14
recovering accessible
when database is closed, RMN 6-23
when database is open, RMN 6-24
recovering inaccessible
when database is closed, RMN 6-23
when database is open, RMN 6-24
recovering offline in open database, SBR 5-22
recovery, PSA 14-7
relationship to datafiles, SCN 3-2
removing from the database, SQL 7-503
reorganizing
Import, SUT 2-52
restoring, RMN 6-10
revoking access from users, SCN 293
revoking from users, SAD 22-17
rollback segment, PSA 3-4, PSA 3-6, PSC 7-6
setting default storage parameters, SAD 12-11
setting default storage parameters for, SAD 9-3
size of, SCN 3-4
size of free extents in, SQL 7-180
sizing, OID 12-9
space allocation, SCN 3-7
specifying
datafiles for, SQL 7-421
for a user, SQL 7-453
for index rebuild, SQL 7-145
SYSTEM, OID 12-12, PSA 3-4, PSG 1-12
SYSTEM tablespace, SAD 9-4
tables, PSC 7-6
taking offline, PSC 7-6, SQL 7-180, SQL 7-422
taking offline normal, SAD 9-15
taking offline temporarily, SAD 9-16
TEMP, PSG 1-12
tempfile
adding, SQL 7-179
temporary, SCN 1-42, SCN 3-12, STU 20-37
assigning to users, SAD 22-16
creating, SAD 9-8, SQL 7-424
default for user, SCN 293
for creating large indexes, SAD 14-3
for sort segments, SAD 13-6
specifying for a user, SQL 7-453
temporary objects in, SQL 7-422
TOOLS, PSG 1-12
transition read only mode, SCN 3-11
transportable, DWG 11-5, DWG 12-3, GTK 3-23, SAD 9-27 to SAD 9-39, SCN 3-14
unlimited quotas, SAD 22-17
used for temporary segments, SCN 4-17, SCN 4-20
USERS, PSG 1-12
using multiple, SAD 9-2
viewing quotas, SAD 22-27
See also SYSTEM tablespace
TABLESPACES parameter, SUT 2-28
TABQUOTAS view, SRF 2-165
tabs, PLS 2-2
loading data files containing tabs, SUT 5-49
trimming, SUT 5-82
whitespace, SUT 5-82
TABS synonym for USER_TABLES, SRF 2-165
TAF, SCN 355
configuring, PSG 5-2
GLOBAL_DBNAME parameter in listener.ora file, PSG 3-15
overview, PSG 5-2
pre-establishing a connection, PSG 5-5
retrying a connection, PSG 5-5
See transparent application failover
see Transparent Application Failover (TAF)
with client load balancing, PSG 5-4
with connect-time failover, PSG 5-4
tags, RMN 1-58
TAN function, SQL 4-98
TANH function, SQL 4-99
tape archiving destination, SRF 1-55
tape buffers
tuning for RMAN backups. See Oracle8i Tuning, RMN 1-35
tape drives
auto media management, LEG 3-19
streaming for archiving, SAD 7-22
TAPE_ASYNCH_IO initialization parameter
initialization parameters
TAPE_ASYNCH_IO, SRF 1-116
TAPE_ASYNCH_IO parameter, DWG 18-26
target database
definition, MIG 1-3, RMN 1-2
targetDN, OID F-3
tasks, SCN 8-2
Tasks tab
from Create Job property sheet, PSG 7-22
TCP/IP, ADG 12-1
TCP/IP connections, OID 14-5, OID 14-8, OID F-5
TCP/IP protocol
described, NET 4-2
HOST parameter, NET B-4
parameters for addresses, NET B-4
PORT parameter, NET B-4
TCP/IP with SSL protocol
described, NET 4-2
HOST parameter, NET B-4
parameters for addresses, NET B-4
PORT parameter, NET B-4
TCP.NODELAY parameter, NET C-77, STU 22-17
TDO
definition, OCI 12-2
description, OCI 11-23
obtaining, OCI 11-23
type descriptor object. See TDO.
TDO. See type descriptor object
tear-off, in Oracle Directory Manager, OID 4-10
technology stack, OID 14-3
TEMP tablespace
described, PSG 1-12
raw device, PSG 2-6
TEMPFILE clause
of ALTER DATABASE, SQL 7-8, SQL 7-17
of CREATE TEMPORARY TABLESPACE, SQL 7-425
tempfiles, SAD 9-9, SCN 3-18
automatic extension of, SQL 7-425
bringing online, SQL 7-17
data dictionary information, MIG 9-24
disabling automatic extension, SQL 7-17
dropping, SQL 7-17
enabling automatic extension, SQL 7-17
modifying, SQL 7-16
resizing, SQL 7-17
reusing, SQL 7-517
size of, SQL 7-517
specifying, SQL 7-425, SQL 7-516
taking offline, SQL 7-17
Template. See Deployment Template
templates, creating entries from, OID 7-15
TEMPORARY clause
of ALTER TABLESPACE, SQL 7-181
of CREATE TABLESPACE, SQL 7-422
temporary extents, DWG 18-52
TEMPORARY keyword, STU 20-37
temporary LOBs, STU 19-31
character set ID, ADL 10-127
checking if LOB is temporary, ADL 10-22
data stored in temporary tablespace, ADL 10-7
DBMS_LOB available functions/procedures, ADL 3-8
disable buffering
explcitly freeing before overwriting it with permanent LOB locator, ADL 10-9
features, ADL 10-10
inline and out-of-line not used, ADL 10-7
lifetime and duration, ADL 10-8
locators can be IN values, ADL 10-6
locators operate as with permanent LOBs, ADL 10-6
memory handling, ADL 10-8
OCI and logical buckets, ADL 10-8
OCI functions, ADL 3-15
performance, ADL 10-10
Pro*C/C++ precompiler embedded SQL statements, ADL 3-24
Pro*COBOL precompiler statements, ADL 3-28
reside on server not client, ADL 10-8
similar functions used to permanent LOBs, ADL 10-7
SQL DML does not operate on, ADL 10-6
transactions and consistent reads not suuported, ADL 10-7
trimming, ADL 10-162
write append to, ADL 10-143
temporary segments, SCN 4-17, SCN 4-20, SCN 10-11, SUT 8-28
allocating, SCN 4-20
allocation for queries, SCN 4-20
deallocating extents from, SCN 4-17
dropping, SCN 4-17
FILE keyword
SQL*Loader, SUT 8-28
ignore quotas, SCN 293
index creation and, ADG 5-2, SAD 14-3
not exported during backup, SUT 1-50
operations that require, SCN 4-19
parallel DDL, SCN 190
parallel INSERT, SCN 153
tablespace containing, SCN 4-17, SCN 4-20
when not in redo log, SCN 4-20
temporary space
allocating, SAD 13-6
temporary storage in a direct path load, SUT 8-11
temporary tables, GTK 3-42, SAD 13-10, SCN 10-11
compatibility, MIG 9-10
creating, SQL 7-390, SQL 7-391
dropping for downgrading, MIG 13-13
session-specific, SQL 7-391
transaction-specific, SQL 7-391
temporary tablespace
for binds of more than 4000 bytes, ADL 7-16
space
insufficient for migration, MIG A-2
TEMPORARY TABLESPACE clause
of ALTER USER. See CREATE USER
of CREATE USER, SQL 7-453
temporary tablespaces, SCN 3-12
creating, SQL 7-424
optimizing sort, STU 20-37
specifying for a user, SQL 7-453
SQL examples, SQL 7-425
striping, DWG 18-52
temporary tablespaces, see tablespaces, temporary
TEMPORARY_TABLE_LOCKS initialization parameter: obsolete
terminal
encoding scheme, PC_ 4-49
TERMINAL attribute, USERENV, ADG 11-43
TERMINAL format
COBOL statements, PCO 2-12
TERMINATED BY, SUT 5-16
SQL*Loader, SUT 5-70
WHITESPACE
SQL*Loader, SUT 5-70
with OPTIONALLY ENCLOSED BY, SUT 5-83
terminated fields
specified with a delimiter, SUT 5-83
specified with delimiters and SQL*Loader, SUT 5-70
terminating condition, PLS 7-39
terminating directory servers, OID 4-17, OID 4-18
terminating RMAN commands, RMN 1-12
terminating user sessions
active sessions, SAD 4-22
identifying sessions, SAD 4-21
inactive session, example, SAD 4-22
inactive sessions, SAD 4-22
termination, program
normal versus abnormal, PC_ 3-23
terminator for embedded SQL statements, PCO 2-19
terminator, SQL statements, PCO A-7
terminator, statement, PLS 2-3
terminology
migration, MIG 1-2
navigational functions, OCI 16-4
used in this manual, OCI 1-11
ternary operators, PLS 2-42
territories, NLS 2-10
overriding, NLS 2-6
supported, NLS A-5
territory, SRF 1-76, SRF 1-79
territory support, NLS 1-6
test databases, creating, RMN 1-64
test disk API, RMN 9-19
testing, STU 2-14
applications for migration, MIG 3-25
backup strategies, SBR 3-12
client configuration
using applications, NET 11-11
using OS, NET 11-11
using special commands, NET 11-12
with 3GL, NET 11-12
with Net8 Assistant, NET 11-22
with TCROUTE, NET 11-20
with TNSPING, NET 11-17
developing a plan for migration, MIG 3-21
EXPLAIN PLAN, MIG 3-24
functional for migration, MIG 3-22
integration for migration, MIG 3-22
INTO clause, MIG 3-24
listener configuration, NET 11-15
media manager, RMN 1-23
migration results, MIG 8-13
minimal for migration, MIG 3-22
network connectivity, NET 11-17
network objects, NET 11-14
Oracle Connection Manager, NET 11-15
Oracle Names servers, NET 11-13
performance for migration, MIG 3-23
pre- and post-migration, MIG 3-24
server configuration
with Net8 Assistant, NET 11-15
standby databases, SBY 1-15
the migrated test database, MIG 3-25
the migration process, MIG 3-25
volume/load stress for migration, MIG 3-23
with control utilities, NET 11-3
testing the media management API, RMN 9-10
testing the network, PSG 4-3
text
conventions, SQL x
date and number formats, SQL 2-38
in SQL syntax, SQL 2-2
properties of CHAR and VARCHAR2 datatypes, SQL 2-2
syntax of, SQL 2-2
text conventions used in this manual, PCO cxxv
text date format element, SQL 2-46
Text Message, ADQ 12-27
TEXT_ENABLE initialization parameter: obsolete
TextDecl - oracle.xml.parser.v2.XMLToken.TextDecl, JPR 4-138
tftp utility, NET 10-9
TH date format element suffix, SQL 2-51
THE keyword for subqueries, GTK 7-7
THEN clause, PLS 3-3
Thin JDBC support, OAS 3-1
thin-clients, and LDAP, OID 1-3
third generation language, ADG 9-2
third-normal-form schemas, DWG 16-2
thrashing, STU 18-5
thread, STU 23-3
THREAD clause, PSA 4-7, PSA 13-1, PSA 13-5, PSA 13-15
disabling a thread, PSA 3-8
when required, PSA 3-7
thread ID, PSG 1-16
THREAD initialization parameter, SRF 1-117
thread management functions, OCI 15-176
THREAD option
creating private thread, PSC 7-3
creating public thread, PSC 7-3
THREAD parameter, PSA 1-8, PSA 1-13, PSA 3-7, PSG 1-16, PSG 4-5
instance acquiring thread, PSC 7-3
thread safety, OCI 8-22
advantages of, OCI 8-22
and three-tier architectures, OCI 8-22
basic concepts, OCI 8-23
compatibility, MIG 9-19
implementing with OCI, OCI 8-23
mixing 7.x and 8.0 calls, OCI 8-24
required OCI calls, OCI 8-23
THREADS
precompiler option, PC_ 10-40, PC_ 11-7, PCO 12-7, PCO 14-39
threads, PC_ F-28, PCO F-19
allocating context, PC_ 11-8, PC_ F-28, PCO 12-8, PCO F-19
archive file format, PSA 13-6
archiving redo log files, PSA 13-1, PSA 13-5, PSA 13-15
associated with an instance, PSA 3-7
changing from public to private, PSA 3-8
closed, PSA 13-21
creating, PSA 3-7
disabled, PSA 3-8
disabling, PSA 3-8
enabled, PSA 13-8, PSA 13-21, PSA 14-9
enabling, PC_ 11-7, PC_ F-50, PCO 12-8, PCO F-38
example, PSC 7-3
exclusive mode, PSA 1-7
forced log switch, PSA 13-15
freeing context, PC_ 11-9, PC_ F-29, PCO 12-8, PCO F-20
log history, PSA 13-8
multi-threaded server, SCN 8-14, SCN 8-16
number of groups, PSC 7-4
online redo log, SAD 6-2
open, PSA 13-8, PSA 13-21
public, PSA 3-7
use context, PC_ 11-8, PCO 12-8, PCO F-21
THREADS precompiler option, PCO 14-39
three-tier architectures
and thread safety, OCI 8-22
three-tier systems, ADG 11-64, ADG 11-65, ADG 11-66
three-valued logic (true, false, unknown)
produced by nulls, SCN 10-9
threshold level, OAS 8-3, OAS 8-4
Throughput, ADQ 5-2
throughput, OID 12-6, SCN 130, STU 1-3, STU 4-8
cost-based approach, STU 4-10
optimizing, STU 4-9, STU 7-6
with Cache Fusion, PSA 12-4
THSP date format element suffix, SQL 2-51
TICKS attribute, NET 9-7
tiers, STU 18-14
TIME datatype (SQL/DS or DB2), SQL 2-30
time format
RECOVER DATABASE UNTIL TIME statement, SBR 5-30
time lag
in standby database, SBY 5-52 to SBY 5-56
time parameters, NLS 2-13
setting for Recovery Manager use, RMN 2-2
Time Series, GTK 3-13
Time Series cartridge
use in power demand example, DCI 11-74
Time Specification
Delay, ADQ 8-46
Expiration, ADQ 8-49
Time Specification - Delay, ADQ 12-62
Time Specification - Expiration, ADQ 12-64
time-based recovery, SBR 5-28 to SBR 5-30
coordinated in distributed databases, SBR 6-17
definition, SBR 3-16
TIMED_OS_STATISTICS initialization parameter, SRF 1-117
TIMED_OS_STATISTICS parameter
of ALTER SYSTEM, SQL 7-118
TIMED_QUERY command, NET A-77
TIMED_STATISTICS initialization parameter, SRF 1-118, STU 6-4, STU 23-2
SQL Trace, STU 6-4
TIMED_STATISTICS parameter, DWG 18-71
file read/write statistics, SRF 3-47, SRF 3-119
of ALTER SESSION, SQL 7-95
of ALTER SYSTEM, SQL 7-118
TIMEOUT parameter, NET 2-17, NET 7-17
TIMEOUT_ON_RESOURCE exception, PLS 6-6
timer initiated disconnect
see dead connection detection
TimeScale package, SPR 1-16
TimeSeries package, SPR 1-17
timestamp checking, SCN 117
TIMESTAMP column
PLAN_TABLE table, STU 5-4
TIMESTAMP datatype (SQL/DS or DB2), SQL 2-30
timestamping
client trace files, NET C-28
listener trace files, NET C-58
Oracle Connection Manager trace files, NET C-75
server trace files, NET C-28
timestamps, DWG 11-7
PL/SQL library unit dependencies, ADG 9-28
Timout field, NET 7-17
TKPROF program, STU 6-3, STU 6-6, STU 19-40
editing the output SQL script, STU 6-17
example of output, STU 6-15
generating the output SQL script, STU 6-16
introduction, STU 11-7
syntax, STU 6-8
using the EXPLAIN PLAN statement, STU 6-10
TKPROF_TABLE, STU 6-18
querying, STU 6-17
TM (transaction manager), ADG 16-2
TM number format element, SQL 2-41
TM, DML Enqueue, PSA 7-17, PSC 4-7
TNS, SMS 25-1
benefits, NET 3-2
described, NET 3-2
TNS listener on Administrator list, LEG 2-27, LEG 2-28
TNS Time Out Value option, NET 8-23
TNS_ADMIN environment variable, NET 12-4, NET 12-6, PSG B-5
TNS_ADMIN parameter, NET 12-4, NET 12-6
tns_admin parameter, PSG B-5, PSG B-8
TNSAPI.A file, NET 10-7
TNSAPI.DLL file, NET 10-7
TNSAPI.H file, NET 10-7
TNSAPI.LIB file, NET 10-7
tnsnames.ora
configuring for replication, OID 10-4
in cold backup, OID B-7
TNSNAMES.ORA file, SAD 7-11, SBY 2-17
configuring, SBY 2-11, SBY 2-12, SBY 5-4
format, SBY 5-5, SBY 5-16
tnsnames.ora file, PSG 3-16, PSG 3-40
BACKUP parameter, PSG 5-3
configuration parameter reference, NET C-31 to NET C-48
configuring, NET 6-5
default configuration, PSG 3-16
DELAY parameter, PSG 5-3
exporting entries to directory server, NET 6-32
FAILOVER parameter, PSG 4-2
FAILOVER_MODE, PSG 5-3
INSTANCE_NAME parameter, PSG 3-18
LOAD_BALANCE parameter, PSG 4-2
loading into CDS using tnnfg, OAS 14-17
METHOD parameter, PSG 5-3
migrating, MIG F-14
modifying to load connect descriptors into CDS, OAS 14-16
parameters
ADDRESS, NET C-38
ADDRESS_LIST, NET C-38
BACKUP, NET C-44
BACKUP parameter, NET 8-13
CONNECT_DATA, NET C-42
DELAY, NET 8-13, NET C-44
DESCRIPTION, NET C-37
DESCRIPTION_LIST, NET C-37
FAILOVER, MIG F-11, NET 8-4, NET C-39
FAILOVER_MODE, NET 8-13, NET C-43
GLOBAL_NAME, NET 8-9, NET C-45
HS, NET 8-9, NET C-45
INSTANCE_NAME, NET 8-9, NET C-46, NET C-87
LOAD_BALANCE, MIG F-11, NET 8-4, NET C-40, NET C-87
METHOD, NET 8-13, NET C-44
RDB_DATABASE, NET 8-9, NET C-46
RETRIES, NET 8-13, NET C-44
SDU, NET 8-9, NET C-40
SERVER, NET C-46
SERVICE_NAME, MIG F-7, NET C-47, NET C-88
SID, MIG F-7, NET C-48
SOURCE_ROUTE, MIG F-11, NET 8-4, NET C-41
TYPE, NET 8-13, NET C-44
TYPE_OF_SERVICE, NET 8-9, NET C-41
release 8.1, changes in, NET C-86 to NET C-88
FAILOVER parameter, NET C-83
LOAD_BALANCE parameter, NET C-82
nested addresses, NET C-84
SERVICE_NAME parameter, NET C-81
SOURCE_ROUTE parameter, NET C-83
renaming, OAS 14-18
RETRIES parameter, PSG 5-3
service discovery, PSG C-5
SERVICE_NAME parameter, PSG 3-18
TYPE parameter, PSG 5-3
upgrading, MIG F-14
tnsnav.ora file, MIG F-17
tnsnet.ora file, MIG F-17
TNSPING utility, NET 11-17
compared to TRCROUTE utility, NET 11-20
TNSPING.TRACE_DIRECTORY parameter, NET 12-37, NET C-24
TNSPING.TRACE_LEVEL parameter, NET 12-37, NET C-25
TO clause
of ROLLBACK statement, PC_ F-99
TO PUBLIC clause
of GRANT object_privileges, SQL 7-534
of GRANT system_privileges_and_roles, SQL 7-520
TO role clause
of GRANT object_privileges, SQL 7-534
of GRANT system_privileges_and_roles, SQL 7-520
TO SAVEPOINT clause, PCO 3-18
in ROLLBACK statement, PC_ 3-20
of ROLLBACK, SQL 7-565
purpose of, PC_ 3-20
restriction on, PC_ 3-21
restrictions, PCO 3-19
using in ROLLBACK statement, PCO 3-18
TO user clause
of GRANT object_privileges, SQL 7-534
of GRANT system_privileges_and_roles, SQL 7-520
TO_CHAR
date conversion function, SQL 4-99
number conversion function, SQL 4-100
TO_CHAR function, ADG 3-25, SQL 2-37, SQL 2-40, SQL 2-45, SQL 2-51, SRF 1-75
CC date format, ADG 3-12
data conversion, SCN 12-24
default date format, NLS 2-14
format masks, NLS 4-10
group separator, NLS 2-22
Julian dates, SCN 12-11
language for dates, NLS 2-16
NLS default in CHECK constraints, SCN 271
NLS default in views, SCN 10-15
RR date format, ADG 3-6
spelling of days and months, NLS 2-16
TO_DATE function, ADG 3-8, ADG 3-25, SCN 12-10, SQL 2-37, SQL 2-45, SQL 2-49, SQL 2-51, SQL 4-101, SRF 1-75
data conversion, SCN 12-24
default date format, NLS 2-14
format masks, NLS 4-10
Julian dates, SCN 12-11
language for dates, NLS 2-16
NLS default in CHECK constraints, SCN 271
NLS default in views, SCN 10-15
partitions, SCN 11-12, SCN 11-21
RR date format, ADG 3-11
spelling of days and months, NLS 2-16
TO_LABEL function
desupported, MIG 9-30
TO_LOB
limitations, ADL 9-60
TO_LOB function, MIG 8-2, SQL 2-37, SQL 4-102
TO_MULTI_BYTE function, SQL 4-103
TO_NUMBER function, ADG 3-25, SCN 12-9, SQL 2-37, SQL 2-40, SQL 4-103
data conversion, SCN 12-24
format masks, NLS 4-10
group separator, NLS 2-22
Julian dates, SCN 12-11
NLS default in CHECK constraints, SCN 271
NLS default in views, SCN 10-15
TO_SINGLE_BYTE function, SQL 4-104
toDatum(OracleConnection) - oracle.ODCI.ODCIArgDescList.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-8
toDatum(OracleConnection) - oracle.ODCI.ODCIArgDescRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-10
toDatum(OracleConnection) - oracle.ODCI.ODCIArgDesc.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-5
toDatum(OracleConnection) - oracle.ODCI.ODCIColInfoList.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-16
toDatum(OracleConnection) - oracle.ODCI.ODCIColInfoRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-18
toDatum(OracleConnection) - oracle.ODCI.ODCIColInfo.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-13
toDatum(OracleConnection) - oracle.ODCI.ODCICostRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-23
toDatum(OracleConnection) - oracle.ODCI.ODCICost.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-21
toDatum(OracleConnection) - oracle.ODCI.ODCIFuncInfoRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-28
toDatum(OracleConnection) - oracle.ODCI.ODCIFuncInfo.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-26
toDatum(OracleConnection) - oracle.ODCI.ODCIIndexCtxRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-33
toDatum(OracleConnection) - oracle.ODCI.ODCIIndexCtx.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-31
toDatum(OracleConnection) - oracle.ODCI.ODCIIndexInfoRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-38
toDatum(OracleConnection) - oracle.ODCI.ODCIIndexInfo.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-36
toDatum(OracleConnection) - oracle.ODCI.ODCIObjectList.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-44
toDatum(OracleConnection) - oracle.ODCI.ODCIObjectRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-46
toDatum(OracleConnection) - oracle.ODCI.ODCIObject.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-41
toDatum(OracleConnection) - oracle.ODCI.ODCIPredInfoRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-51
toDatum(OracleConnection) - oracle.ODCI.ODCIPredInfo.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-49
toDatum(OracleConnection) - oracle.ODCI.ODCIQueryInfoRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-56
toDatum(OracleConnection) - oracle.ODCI.ODCIQueryInfo.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-54
toDatum(OracleConnection) - oracle.ODCI.ODCIRidList.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-59
toDatum(OracleConnection) - oracle.ODCI.ODCIStatsOptionsRef.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-64
toDatum(OracleConnection) - oracle.ODCI.ODCIStatsOptions.toDatum(oracle.jdbc.driver.OracleConnection), JPR 3-62
toggling change-log flag, OID 10-17
toggling multi-master flag, OID 10-17
toggling SSL on and off, OID F-5
TOID_NOVALIDATE parameter, SUT 2-28
token cards, OAS 1-9
token passing, REP 6-12
sample implementation, REP 6-11
token(int, String) - oracle.xml.parser.v2.XMLToken.token(int, java.lang.String), JPR 4-139
tokenize(InputSource) - oracle.xml.parser.v2.XMLTokenizer.tokenize(org.xml.sax.InputSource), JPR 4-143
tokenize(InputStream) - oracle.xml.parser.v2.XMLTokenizer.tokenize(java.io.InputStream), JPR 4-143
tokenize(Reader) - oracle.xml.parser.v2.XMLTokenizer.tokenize(java.io.Reader), JPR 4-144
tokenize(String) - oracle.xml.parser.v2.XMLTokenizer.tokenize(java.lang.String), JPR 4-144
tokenize(URL) - oracle.xml.parser.v2.XMLTokenizer.tokenize(java.net.URL), JPR 4-145
TOO_MANY_ROWS exception, PLS 6-6
tools
for tuning, OID 13-2
TOOLS tablespace
described, PSG 1-12
raw device, PSG 2-6
Toolset
Oracle, PC_ 20-14
top object class, OID 2-8, OID 2-9
optional object classes in, OID 2-9
top utility, OID 13-2
TOP_N function, DWG 17-31
top-down design, PLS 1-15
Topic must be specified - error, ADQ D-10
Topic Publisher, ADQ 12-51
Topic, Publish-Subscribe, ADQ 12-46
TopicReceiver - oracle.jms.TopicReceiver, JPR 2-213
Topics cannot be of type EXCEPTION - error, ADQ D-9
top-level memory
of object, OCI 13-16
top-N queries, SQL 2-61
toString() - oracle.jms.AQjmsAgent.toString(), JPR 2-27
toString() - oracle.jms.AQjmsDestination.toString(), JPR 2-71
toString() - oracle.security.ssl.OracleSSLCredential.toString(), OAS F-22
toString() method, NLS 6-8
Total Elapsed Time data view, STU 14-11
TOTAL_REFUSED, NET A-94
TOTAL_RELAYS, NET A-94
TouchNet II, OAS 8-4
TOUSER
Import parameter, SUT 2-29
TP monitor, PSC A-13
TP monitors, MIG 3-18
TP_NAME parameter, NET B-3
TPC/IP
as supported by UTL_TCP, SPR 66-1
TPN parameter, NET B-3
TRACE command, NET A-24
trace facility
function of, PC_ C-6
using to improve performance, PC_ C-6, PCO D-6
trace file
set up sample for sqlnet.ora file, OAS A-2
trace files, PSG C-8, SCN 8-15
and RMAN, RMN 9-2
ARCn trace file, SCN 361
background thread trace files, PSG C-9
backing up control file, SBR 4-14
cmadm_pid.trc, NET 12-40
cmadmpid.trc, NET 12-40
cman_pid.trc, NET 12-40
cmanpid.trc, NET 12-40
control file backups to, SBR 4-14
cycling
client, NET C-26
listener, NET C-57
Oracle Connection Manager, NET C-75
server, NET C-27
DBWn trace file, SCN 346
default names for, NET 12-34
destination, SRF 1-16, SRF 1-121
error call trace stack, PSG C-11
error message information, NET 12-45
example, NET 12-55
example of error messages, NET 12-45
example of packet data, NET 12-44
job failures and, SAD 8-9
LGWR trace file, SCN 8-10
listener.trc, NET 12-38
location of, SAD 4-16, SBY 4-6, SRF 1-16
log writer, SAD 4-16
log writer process and, SAD 6-6, SBR 2-13
maximum size, SRF 1-67
namespid.trc, NET 12-39
names.trc, NET 12-39
oraxxxxx.trc, PSG C-10
sidalrt.log, PSG C-10
sidbsp0.trc, PSG C-9
siddbwr.trc file, PSG C-9
sidlckn.trc, PSG C-9, PSG C-11
sidlmdn.trc, PSG C-9
sidlmon.trc, PSG C-9
sidp00n.trc, PSG C-9
sidsmon.trc file, PSG C-9
size of, SAD 4-16
snapshots, REP B-8
sqlnetpid.trc file, NET C-28
sqlnet.trc, NET C-25
sqlnet.trc for clients, NET 12-35
svr_pid.trc for servers, NET 12-35, NET C-25
timestamping
client, NET C-28
listener, NET C-58
Oracle Connection Manager, NET C-75
server, NET C-28
using, SAD 4-15, SAD 4-16
when written, SAD 4-16
Trace, Oracle, STU 14-1
TRACE_DIRECTORY parameter, NET 12-38, NET 12-40, NET C-74
TRACE_DIRECTORY_CLIENT parameter, NET 12-35, NET C-25
TRACE_DIRECTORY_listener_name parameter, NET C-56
TRACE_DIRECTORY_SERVER parameter, NET 12-36, NET C-25
TRACE_FILE parameter, NET 12-38
TRACE_FILE_CLIENT parameter, NET 12-35, NET C-25
TRACE_FILE_listener_name parameter, NET C-57
TRACE_FILE_SERVER parameter, NET 12-36, NET C-25
TRACE_FILELEN parameter, NET C-74
TRACE_FILELEN_CLIENT parameter, NET C-26
TRACE_FILELEN_SERVER parameter, NET C-26
TRACE_FILEN_listener_name parameter, NET C-57
TRACE_FILENO_CLIENT parameter, NET C-26
TRACE_FILENO_listener_name parameter, NET C-57
TRACE_FILENO_SERVER parameter, NET C-27
TRACE_LEVEL parameter, NET 12-38
TRACE_LEVEL_CLIENT parameter, NET 12-35, NET C-27
TRACE_LEVEL_listener_name parameter, NET C-58
TRACE_LEVEL_SERVER parameter, NET 12-36, NET C-27
TRACE_TIMESTAMP parameter, NET C-75
TRACE_TIMESTAMP_CLIENT parameter, NET C-28
TRACE_TIMESTAMP_listener_name parameter, NET C-58
TRACE_TIMESTAMP_SERVER parameter, NET C-28
TRACE_UNIQUE_CLIENT parameter, NET C-28
TRACETAB.SQL, SPR 53-3
tracing
archivelog process, SAD 7-25
client, NET C-25
cycling files
client, NET C-26
listener, NET C-57
Oracle Connection Manager, NET C-75
server, NET C-27
server, NET C-25
timestamping
client trace files, NET C-28
listener trace files, NET C-58
Oracle Connection Manager trace files, NET C-75
server trace files, NET C-28
tracing function calls, OID 5-23
TRACING parameter, NET 12-40, NET C-74
tracking volume modes, LEG 2-9, LEG 4-3
trailing blanks
how handled, PLS B-4
loading with delimiters, SUT 5-73
TRAILING NULLCOLS
example, SUT 4-28
SQL*Loader keyword, SUT 5-43
trailing whitespace
trimming, SUT 5-86
transaction, PCO 3-13
committed data, PSC 1-4
concurrent, PSC 1-4
offline tablespace, PSC A-21
recovery, PSC A-14
rollback segments, PSC A-21
row locking, PSC 1-4
sequence numbers, PSC 8-13
updates, PSC 1-4
transaction boundaries
LOB locators, ADL 5-16
transaction control statements, SCN 1-52, SCN 13, SQL 6-4
distributed transactions and, DDS 4-4
in autonomous PL/SQL blocks, SCN 41
PL/SQL support of, SQL 6-4
transaction failures
simulating, DDS 5-26
transaction handle
attributes, OCI A-14
description, OCI 2-10
transaction identifier, OCI 8-4
transaction management
overview, DDS 4-11
transaction manager, ADG 16-2
transaction processing
distributed systems, DDS 1-33
overview of, PC_ 2-7
statements used for, PC_ 2-8
transaction processing monitor, PC_ 5-54, PSA 5-6, PSA 5-15, STU 18-15, STU 18-17
transaction recovery, PSC 9-16
fast-start checkpointing, GTK 3-51
Fast-Start on-demand rollback, GTK 3-51
Fast-Start parallel rollback, GTK 3-52
inter-transaction, GTK 3-52
intra-transaction, GTK 3-52
transaction service
Heterogeneous Services, DDS 6-3
views
Heterogeneous Services, DDS 7-12
transaction set consistency, SCN 220, SCN 221
transaction tables, SCN 4-22
reset at recovery, SCN 8-12
TRANSACTION_AUDITING initialization parameter, SRF 1-119
TRANSACTION_AUDITING parameter
of ALTER SYSTEM, SQL 7-118
TRANSACTIONAL - oracle.jms.AQjmsConstants.TRANSACTIONAL, JPR 2-55
transactional complexity
levels in OCI, OCI 8-3
transactions, PLS 5-2, SCN 1-52, SCN 31
aborted, PSC 7-6
advanced queuing, SCN 67
allowing to complete, SQL 7-106
assigning
rollback segment to, SQL 7-602
to a specific rollback segment, SQL 7-603
assigning rollback segments, STU 20-30
assigning system change numbers, SCN 36
assigning to rollback segments, SCN 4-22
assigning to specific rollback segment, SAD 11-12
asynchronous processing, SCN 66
automatically committing, SQL 7-230
autonomous, ADG 7-32 to ADG 7-40, PLS 5-52, SCN 40
within a PL/SQL block, SCN 40
block-level recovery, SCN 231, SCN 355
closing database links, DDS 3-2
commenting on, SQL 7-231
committed data, PSA 13-14
committing, OCI 2-26, PC_ F-24, PCO F-15, PLS 5-43, SCN 1-54, SCN 8-10, SCN 34, SCN 35
group commits, SCN 8-10
use of rollback segments, SCN 4-23
concurrency and, SCN 226
concurrent, PSC 4-9, PSC 4-10, SRF 1-119
contents, PCO 3-13
contents of, PC_ 2-8, PC_ 3-17
context, PLS 5-55
controlling transactions, SCN 23
data locking, SRF 1-36
dead, SCN 344
deadlocks and, SCN 34, SCN 227
defining and controlling, SCN 23
definition of, PC_ 2-7
described, SCN 32
description of, PC_ 3-16
discrete, STU 17-2
discrete transactions, SCN 24, SCN 39
distributed, PC_ F-101, PLS 5-42, SCN 1-31
deadlocks and, SCN 229
parallel DDL restrictions, SCN 184
parallel DML restrictions, SCN 184, SCN 203
resolving automatically, SCN 8-12
two-phase commit, SCN 1-35, SCN 38
two-phase commit and, DDS 1-36, SCN 406
distributed, forcing, SQL 7-84
distribution among rollback segments of, SCN 4-23
end of, SCN 35
consistent data, SCN 23
ending, SQL 7-230
ending properly, PLS 5-46
external LOBs do not participate in, ADL 2-3
failure during, PC_ 3-17
functions, OCI 15-204
global, OCI 8-4
branch states, OCI 8-6
branches, OCI 8-5
one-phase commit, OCI 8-7
transactions identifier, OCI 8-4
two-phase commit, OCI 8-7
global examples, OCI 8-8
guarding databases with, PC_ 3-16
guidelines, PCO 3-24
guidelines for, PC_ 3-27
how Oracle records, SBR 1-4
how to begin, PC_ 3-17, PCO 3-13
how to end, PC_ 3-17, PCO 3-13
IDs of locators, ADL 5-16
implicit commit of, SQL 6-2, SQL 6-4, SQL 6-5
in-doubt, DDS 4-14, PCO 3-24
after a system failure, DDS 5-11
committing, SQL 7-230
forcing, SQL 7-231
limit rollback segment access, SCN 4-31
pending transactions table, DDS 5-25
recoverer process (RECO) and, DDS 5-27
resolving automatically, SCN 1-35, SCN 5-9, SCN 38
resolving manually, SCN 1-35
rollback segments and, SCN 4-25
use partly available segments, SCN 4-31
initialization parameters, OCI 8-11
inserts, PSC 7-10
instance failure, PSA 14-3
internal LOBs participate fully, ADL 2-2
isolation, PSC 4-12
isolation level, SQL 7-602
LOB locators cannot span, ADL 5-13
LOBs locators cannot span, ADL 7-15
local, OCI 8-3
locators with non-serializable, ADL 5-16
locators with serializable, ADL 5-16
locks, PSC 4-5, PSC 4-7
locks for, PSA 7-17
locks, releasing, SQL 7-230
making permanent, PC_ 3-18, PCO 3-14
manual locking, ADG 7-11
manual locking of, SCN 242
manually overriding in-doubt, DDS 5-12
migrating from, ADL 5-26
OCI functions for
transactions, OCI 8-2
offline tablespace, PSC 7-7
overview of, SCN 1-52
partitioning, PSA 5-15
processing, PLS 5-2, PLS 5-41
propagation
protection mechanisms, REP 6-20
rate, DWG 18-43
read consistency of, SCN 1-30, SCN 216
read-committed isolation mode, SQL 7-603
read-only, ADG 7-8, OCI 8-3, PC_ 3-23, PCO 3-20, PLS 5-47, SCN 1-31, SCN 217, SQL 7-602
not assigned to rollback segments, SCN 4-22
read-write, SQL 7-602
recovery, SCN 344
redo log files written before commit, SCN 8-10
remote, DDS 1-35
rollback, SBR 1-8
rollback segments, PSC 7-7, SRF 1-120
rollback segments and, SAD 11-12, SCN 4-22
rolling back, OCI 2-26, PC_ F-98, PCO F-76, PLS 5-44, PSA 14-3, PSC 7-6, SCN 1-54, SCN 36, SQL 7-107, SQL 7-367, SQL 7-564
and offline tablespaces, SCN 4-31
partially, SCN 38
to a savepoint, SQL 7-565
use of rollback segments, SCN 4-22
row locking, PSC 4-12
savepoints for, SQL 7-567
savepoints in, SCN 1-54, SCN 37
serializable, ADG 7-22, OCI 8-3, SCN 217, STU 17-6
serializable isolation mode, SQL 7-603
serialization of, REP 6-3
SET TRANSACTION command, ADG 7-8
space used in data blocks for, SCN 4-5
start of, SCN 35
statement level rollback and, SCN 34
subdividing with savepoints, PC_ 3-19, PCO 3-18
system change numbers, SCN 8-10
table access patterns, PSA 5-3
terminating, PC_ 3-18
terminating the application and, SCN 35
transaction control statements, SCN 13
triggers and, SCN 104
two-phase commit in parallel DML, SCN 197
types of DML involved, PSA 6-3
uncommitted, SBR 1-8
undoing, PC_ 3-20, PCO 3-16
undoing parts of, PC_ 3-19, PCO 3-18
updates, PSC 7-10
visibility, PLS 5-55
waiting for recovery, PSA 14-3
when rolled back automatically, PC_ 3-17, PC_ 3-22, PCO 3-14, PCO 3-17
writing to rollback segments, SCN 4-23
TRANSACTIONS initialization parameter, SRF 1-105
DML locks, SRF 1-36
using, SAD 11-2
TRANSACTIONS parameter, DWG 18-22, PSC 7-8, SCN 4-28
ensuring LM lock capacity, PSA 10-3
TRANSACTIONS_PER_ROLLBACK parameter, PSC 7-8
TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, SRF 1-105, SRF 1-120
using, SAD 11-2
TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, SCN 4-28
transformations, DWG 13-2
SQL and PL/SQL, DWG 13-4
SQL*Loader, DWG 13-3
star, DWG 16-2
transformNode(XSLStylesheet) - oracle.xml.parser.v2.XMLNode.transformNode(oracle.xml.parser.v2.XSLStylesheet), JPR 4-115
transient copies of objects, PC_ 17-4
transient objects, OCI 10-7, PC_ 17-4
LOB
attributes, OCI 7-4
meta-attributes, OCI 10-20
transition read only tablespaces, SCN 3-11
TRANSLATE ... USING function, SQL 4-106
TRANSLATE function, SQL 4-105
translated messages, NLS A-4
translators
SQLJ, NLS 6-2
transmission time, STU 16-7
transmitting archived redo logs, SAD 7-14, SBR 2-23, SBY 3-13
in normal transmission mode, SAD 7-14, SBR 2-23
in standby transmission mode, SAD 7-14
transparency
definition of, PSC 1-3
location
using procedures, DDS 2-30, DDS 2-31, DDS 2-32
query, DDS 2-32
update, DDS 2-32
Transparent Application Failover, SCN 355
configuring, PSG 5-2
definition of, PSC 9-9
GLOBAL_DBNAME parameter in listener.ora, NET 7-13
GLOBAL_DBNAME parameter in listener.ora file, PSG 3-15
overview, PSG 5-2
pre-establishing a connection, PSG 5-5
retrying a connection, PSG 5-5
uses of, PSC 9-10
with client load balancing, PSG 5-4
with connect-time failover, PSG 5-4
transparent application failover, GTK 4-8, SBY 5-37
Transparent Application Failover (TAF)
configuring, NET 8-12
GLOBAL_DBNAME parameter in listener.ora, NET 8-14
overview, NET 2-21
parameters, NET C-43
Transparent Gateway, STU 9-40
transparent gateways
accessing Heterogeneous Services agents, DDS 7-2
creating database links, DDS 7-4
Heterogeneous Services, DDS 6-5
installing Heterogeneous Services data dictionary, DDS 7-2
testing connections, DDS 7-4
Transparent Network Substrate
see TNS (Transparent Network Substrate)
Transparent Network Substrate (TNS)
benefits, NET 3-2
described, NET 3-2
Transport Layer Security (TLS), and LDAP Version 3, OID 1-3
transport layer, described, NET 3-4
TRANSPORT_TABLESPACE parameter, SUT 2-30
transportable tablespaces, DWG 11-5, DWG 12-3, GTK 3-23, SAD 9-27 to SAD 9-39, SCN 3-14, SUT 2-60
compatibility, MIG 9-9
recovery, SBR 6-4
removing transported tablespaces, MIG 13-10
TSPITR and, SBR 7-3
transportation
definition, DWG 12-2
distributed operations, DWG 12-2
flat files, DWG 12-2
transporting tablespaces between databases, SAD 9-26 to SAD 9-39
TRCROUTE utility
described, NET 11-20
performance effects, NET 11-20
requirements for, NET 11-20
with earlier versions of SQL*Net, NET 11-20
tree view, browsing, OID 7-5
tree view, selecting root of search, OID 7-5
TRIGGERS
export parameter, SUT 1-27
triggers, DWG 11-7, PLS 1-19, SCN 81, SCN 114, SUT 8-22
about, ADG 9-28
accessing column values, ADG 13-15
action, SCN 88
timing of, SCN 90
AFTER, ADG 13-7, ADG 13-16, ADG 13-35, ADG 13-38, SQL 7-428
AFTER triggers, SCN 90
as program units, SCN 1-56
auditing, SAD 24-20, SAD 24-21, SCN 336
auditing with, ADG 13-34, ADG 13-36
autonomous, PLS 5-58
BEFORE, ADG 13-7, ADG 13-16, ADG 13-48, ADG 13-49, SQL 7-428
BEFORE triggers, SCN 90
body, ADG 13-14, ADG 13-17, ADG 13-18, ADG 13-20
cascading, SCN 84
check constraints, ADG 13-47, ADG 13-48
client events, ADG 14-7
column list in UPDATE, ADG 13-6, ADG 13-18
compatibility, MIG 9-13
compiled, ADG 13-28
compiling, SQL 7-183
conditional predicates, ADG 13-14, ADG 13-17
constraints apply to, SCN 102
constraints contrasted with, SCN 85
CREATE TRIGGER ON, ADG 11-22
creating, ADG 13-3, ADG 13-20, ADG 13-26, SQL 7-427
creating multiple, SQL 7-429
data access and, SCN 104
data access restrictions, ADG 13-48
database
altering, SQL 7-183
dropping, SQL 7-505, SQL 7-510
database insert, SUT 8-22
debugging, ADG 13-30
dependency management of, SCN 106, SCN 112
enabled triggers, SCN 102
designing, ADG 13-2
disabling, ADG 13-31, SAD 19-14, SQL 7-165, SQL 7-183
distributed query creation, ADG 9-46, DDS 3-3
dropped automatically when downgrading, MIG 13-43
dropped tables and, ADG 2-10, SAD 13-16
enabled or disabled, SCN 102
enabling, ADG 13-31, SAD 19-13, SQL 7-165, SQL 7-183, SQL 7-427
enforcing data integrity with, SCN 255
error conditions and exceptions, ADG 13-18
event, ADG 11-59
events, ADG 13-5, SCN 87
examples, ADG 13-34 to ADG 13-50, SAD 24-21
examples of, SCN 92, SCN 94, SCN 105
executing
with a PL/SQL block, SQL 7-433
with an external procedure, SQL 7-433
firing (executing), SCN 82, SCN 106
privileges required, SCN 106
steps involved, SCN 102
timing of, SCN 102
FOR EACH ROW clause, ADG 13-12
generating derived column values, ADG 13-49
granting
system privileges on, SQL 7-527
illegal SQL statements, ADG 13-20
in tuning OLTP applications, STU 9-16
INSTEAD OF, SQL 7-429
dropping, SQL 7-458
INSTEAD OF triggers, ADG 13-7, SCN 93
object views and, ADO 5-11, SCN 14-5
integrity constraints vs., ADG 13-2, ADG 13-40
internal, REP A-6
INVALID status, SCN 109, SCN 112
Java, SCN 88
listing information about, ADG 13-32
LOB columns with, how to tell when updated, ADL 6-4
login, ADG 11-49, ADG 11-52, ADG 11-53
migration issues, ADG 13-29
modifying, ADG 13-30
multiple same type, ADG 13-21
mutating tables and, ADG 13-22
naming, ADG 13-5
on DATABASE and SCHEMA, GTK 3-39
on database events, SQL 7-431
on DDL events, SQL 7-430
on DML operations, SQL 7-429
on nested table view columns, GTK 3-35
downgrading, MIG 13-43
on views, SQL 7-429
Oracle Forms triggers versus, SCN 83
order of firing, SQL 7-429
overview of, SCN 82
package variables and, ADG 13-21
parts of, SCN 86
permanently disabled, SUT 8-24
prerequisites before creation, ADG 13-4
privileges, ADG 13-26
to drop, ADG 13-30
privileges for enabling and disabling, SAD 19-13
privileges for executing, SCN 310
roles, SCN 322
procedures and, ADG 13-20
procedures contrasted with, SCN 82
prohibited in views, SCN 10-13
publish-subscribe support, SCN 99
recompiling, ADG 13-29
re-creating, SQL 7-428
REFERENCING option, ADG 13-17
referential integrity and, ADG 13-41 to ADG 13-45
remote dependencies and, ADG 13-20
remote exceptions, ADG 13-18
removing from the database, SQL 7-505
replicating, REP 2-17, REP 6-19
resource manager events, ADG 14-6
restrictions, ADG 13-13, ADG 13-20, SCN 88, SCN 203
direct-load INSERT, SCN 154
parallel DML, SCN 201
restrictions on, SQL 7-433
row, ADG 13-12, SCN 89
row evaluation order, ADG 13-21
row values
old and new, SQL 7-432
row, specifying, SQL 7-432
scan order, ADG 13-21
schema object dependencies, SCN 102, SCN 106
sequence for firing multiple, SCN 102
shared SQL areas and, SCN 7-10
SQL examples, SQL 7-434
statement, SCN 89, SQL 7-432
storage of, SCN 106
stored, ADG 13-28
system triggers, ADG 13-4
on DATABASE, ADG 13-4
on SCHEMA, ADG 13-4
trigger evaluation order, ADG 13-21
types of, SCN 89
UNKNOWN does not fire, SCN 88
update
SQL*Loader, SUT 8-23
use of LONG, LONG RAW, and LOB datatypes, ADG 13-20
user-defined types, ADO 2-5
username reported in, ADG 13-26
uses of, SCN 83
WHEN clause, ADG 13-13
with CALL to a procedure as trigger body, GTK 3-39
with LOBs, DCI 6-12
TRIM collection method, PLS 4-25
TRIM function, GTK 3-44, SQL 4-107
trimming
LOB data
internal persistent LOBs, ADL 9-217
summary, SUT 5-87
temporary LOB data, ADL 10-162
trailing whitespace
SQL*Loader, SUT 5-86
VARCHAR fields, SUT 5-83
triple-DES encryption algorithm, OAS 2-4
troubleshooting, NET 12-1 to NET 12-59, OID C-1, PSG C-1 to PSG C-12, REP B-1
client, NET 12-4
contacting Oracle Customer Support, NET 12-59
directory servers, OID 3-10
log files, NET 12-16
loopback tests, NET 12-4
media manager configurations, RMN 2-22
migration, MIG A-1
ALTER DATABASE CONVERT statement, MIG A-16
AUDIT_TRAIL initialization parameter, MIG A-3
database name mismatch, MIG A-18
datafile version integrity, MIG A-19
Migration utility error messages, MIG A-5
missing convert file, MIG A-17
MULTIPLIER option, MIG A-4
NOMOUNT database start mode, MIG A-16
OPTIMAL setting, MIG A-4
Oracle7 control file, MIG A-16
password file, MIG A-17
running the Migration utility, MIG A-2
running the Oracle Data Migration Assistant, MIG A-2
scripts run long, MIG A-20
SYSTEM tablespace, MIG A-2
temporary tablespace tablespace, MIG A-2
Oracle Database Configuration Assistant, PSG 3-24, PSG 3-44
performance, OID 13-12
questions, NET 12-15
server, NET 12-3
service discovery, PSG C-2
trace files, NET 12-16, PSG C-8
using log file, NET 12-24
Troubleshooting JMS Errors, ADQ xi, ADQ D-1
TRUE keyword
behavior in Oracle7 and Oracle8i, MIG 9-23
TRUE value, PLS 2-9
TRUNC function, ADG 3-9
date function, SQL 4-109
format models, SQL 4-117
number function, SQL 4-108
TRUNCATE PARTITION clause, SAD 15-30
of ALTER TABLE, SQL 7-160
TRUNCATE statement, RAR 7-19, SAD 19-10, SCN 12, SQL 7-611
DROP STORAGE option, SAD 19-12
REUSE STORAGE option, SAD 19-12
TRUNCATE SUBPARTITION clause, SAD 15-32
of ALTER TABLE, SQL 7-160
TRUNCATE TABLE command, ADG 2-10
TRUNCATE TABLE statement
PRESERVE SNAPSHOT LOG option, RAR 7-21
PURGE SNAPSHOT LOG option, RAR 7-21
truncated values, PCO 6-13
detecting, PC_ 6-4, PC_ 7-14, PCO 4-23, PCO 5-4
indicator variables, PCO 6-2
truncation error
when generated, PC_ 6-6
truncation errors
when generated, PCO 5-6
TRUST keyword, ADG 9-68
TRUST parameter
of PRAGMA RESTRICT_REFERENCES, SQL 7-189
trusted certificates, OID 2-23
TRUSTED mode, DWG 19-26
Trusted Oracle, SQL 1-5
Export/Import, MIG 6-3
trusted security, RAR A-2, RAR A-8
TRUSTED_SERVERS view, SRF 2-165
TS, SMS 51-1
TS_PITR_CHECK view, RMN 8-6, SRF 2-166
TS_PITR_OBJECTS TO_BE_DROPPED view, SRF 2-167
TSPITR. See tablespace point-in-time recovery.
TSTools package, SPR 1-20
TTS_OWNERS parameter, SUT 2-30
tunables, database, OID 13-10
tuning, OID 13-1
access path, STU 2-11
after migration, MIG 8-14
analyzing tables, DDS 3-7
and design, STU 2-10
application design, STU 2-9
archiving, SAD 7-19
business rule, STU 2-7
client/server applications, STU 3-11
contention, STU 21-1
cost-based optimization, DDS 3-5
CPU, OID 13-3, STU 18-1
CPU usage, OID 13-3
data design, STU 2-8
data sources, STU 11-2
database logical structure, STU 2-9
databases, SAD 1-21
decision support systems, STU 3-4
diagnosing problems, STU 16-1
disk, OID 13-8
distributed databases, STU 3-8
expectations, STU 1-9
factors, STU 16-2
goals, STU 1-9, STU 2-14
initially, SAD 2-25
I/O, STU 2-12, STU 20-2
library cache, STU 19-14
logical structure, STU 12-3
memory, OID 13-7
memory allocation, STU 2-11, STU 19-2, STU 19-42
method, STU 2-1
monitoring registered applications, STU 11-8
multi-threaded server, STU 21-5
OLTP applications, STU 3-2
operating system, STU 2-13, STU 16-7, STU 19-4
Oracle Parallel Server, STU 3-10
overview of, PSA 11-2
parallel execution, DWG 5-3, STU 3-5
personnel, STU 1-7
proactive, STU 2-2
production systems, STU 2-4
query servers, STU 21-15
reactive, STU 2-3
Recovery Manager performance. See Oracle8i Tuning
SGA parameters, OID 13-11
shared pool, STU 19-13
sorts, STU 20-35
SQL, STU 2-10
SQL and PL/SQL areas, STU 19-8
System Global Area (SGA), STU 19-4
tools, OID 13-2
using LONGs, ADG 3-19
tuning, performance, PC_ C-2, PCO D-2
Turn Off UNIX Signal Handling option in Net8 Assistant, NET 8-23
Tuxedo applications
compatibility with Oracle8i XA libraries, MIG 9-18
two-phase commit, DWG 18-22
case study, DDS 4-20
commit phase, DDS 4-14, DDS 4-24
steps in, DDS 4-15
described, DDS 1-35, SCN 1-35, SCN 406
distributed transactions, DDS 4-4, DDS 4-11
tracing session tree, DDS 5-9
viewing information about, DDS 5-7
forget phase, DDS 4-16
in-doubt transactions, DDS 4-16
automatic resolution, DDS 4-17
manual resolution, DDS 4-19
SCNs and, DDS 4-19
manual override of, SCN 1-35
parallel DML, SCN 197
phases, DDS 4-11
prepare phase, DDS 4-11, DDS 4-12
abort response, DDS 4-13
prepared response, DDS 4-12
read-only response, DDS 4-12
responses, DDS 4-12
steps, DDS 4-14
problems, DDS 5-11
recognizing read-only nodes, DDS 4-13
specifying commit point strength, DDS 5-5
transaction management, SCN 38
triggers, SCN 102
two-task
linking, PC_ 2-17
two-task mode, SCN 8-3
listener process and, SCN 8-14
network communication and, SCN 8-24
program interface in, SCN 8-25
two-tier, STU 18-14
two-way authentication, SSL, OID 4-6, OID F-5
TX, Transaction, PSA 7-17, PSC 4-7
%TYPE attribute, PLS 2-32
syntax, PLS 11-170
type attributes
attributes, OCI 6-10
type checking at runtime, PC_ 17-22
type constructor expressions, SQL 5-6
type definitions
collection, PLS 4-5
forward, PLS 9-29
RECORD, PLS 4-42
REF CURSOR, PLS 5-17
type descriptor object, OCI 11-23
TYPE directive
examples, PC_ F-111
type DTYCHR, MIG 12-8
type evolution, ADO 6-38
type functions
attributes, OCI 6-11
Type of Service field, NET 8-52
Type of Service field in Net8 Assistant, NET 8-9, NET 8-52
TYPE parameter, NET 8-13, NET C-44, PSG 5-3
type procedures
attributes, OCI 6-11
type reference, OCI 10-33
TYPE SQL directive, PC_ F-110
TYPE statements
using the CHARF datatype specifier, PCO 4-47
TYPE# column
SYS.INCEXP table, SUT 1-52
TYPE_CODE
precompiler option, PC_ 10-41
TYPE_CODE option
effect on functionality, PCO 10-13
TYPE_CODE precompiler option, PCO 14-40
TYPE_OF_SERVICE parameter, NET 8-9, NET 8-52, NET C-41
typecodes, OCI 3-23
types
attributes, OCI 6-9
describing, OCI 6-2
mutually referencing
downgrading, MIG 13-32
of attributes, OID 2-3
of object classes, OID 6-7
privileges on, SCN 314
See datatypes, object types
TYPES clause
of ASSOCIATE STATISTICS, SQL 7-210, SQL 7-212
types. See object types or datatypes
Typical database creation type, PSG 1-11
Typical installation type, PSG 3-2
typographical conventions, OID xii

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents