Oracle8
i
Generic Documentation Master Index
Release 2 (8.1.6)
A76991-01
Library
Product
Contents
Oracle8
i
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