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