Oracle8i Generic Documentation Master Index

T

T variable in SQLDA

how value is set, PC_ 15-9

purpose of, PC_ 15-9

tab, PLS 2-3

TAB view, SRF 2-184

table

access pattern, SPS 12-2

allocating extents, SPS 11-11, SPS 17-14

cluster, SPS 17-7

contention, SPS 6-8, SPS 17-13

free space unavailable, SPS 17-11

initial storage, SPS 11-17, SPS 17-13

lock, SPS 7-3, SPS 7-6

multiple files, SPS 11-12, SPS 17-13

PCM locks, SPS 11-15, SPS 17-11

read-only, SPS 12-2

tablespace, SPS 6-8

table alias

in CREATE INDEX, SQL 7-279

table aliases, SQL 2-77

TABLE clause

of TRUNCATE, SQL 7-582

of UPDATE, SQL 7-586, SQL 7-587

table constraint

defined, SQL 7-217

of ALTER TABLE, SQL 7-131

of CREATE TABLE, SQL 7-369

table data

replicating to master sites, REP 2-27

TABLE datatype, PLS 4-2

table directories, SCN 4-4

table fetch by rowid statistic, SRF C-18

table fetch continued row statistic, SRF C-19

table lock, SPS 10-3

acquiring with LOCK TABLE, PCO 3-28

when released, PCO 3-29

table locks

acquiring with LOCK TABLE, PC_ 3-25

disabling, SQL 7-154

duration of, SQL 7-520

on partitions, SQL 7-521

on remote database, SQL 7-521

on subpartitions, SQL 7-521

and queries, SQL 7-520

ROW EXCLUSIVE, SQL 7-521

ROW SHARE, SQL 7-521

row share, PC_ 3-25

SHARE, SQL 7-521

SHARE ROW EXCLUSIVE, SQL 7-521

SHARE UPDATE, SQL 7-521

when released, PC_ 3-25

TABLE operator, PLS 4-18

table- or view-based security, ADG 12 - 26

table partition

containing global index, SAD 13-12

creating, SAD 13-9

dropping, SAD 13-12

exchanging, SAD 13-18

splitting, SAD 13-17

truncating, SAD 13-15

table queue, STU 26-80

table REF constraint

of ALTER TABLE, SQL 7-131

table ref constraint, SQL 7-218

of ALTER TABLE, SQL 7-131

of CREATE TABLE, SQL 7-368

table REF constraints, SQL 7-224

table scan blocks gotten statistic, SRF C-19

table scan rows gotten statistic, SRF C-19

table scans (cache partitions) statistic, SRF C-19

table scans (direct read) statistic, SRF C-19

table scans (long tables) statistic, SRF C-20

table scans (rowid ranges) statistic, SRF C-20

table statistics

gathering, STU 7-11

TABLE syntax, ADG 18 - 13

TABLE_LOCK column, SPS 16-7

TABLE_PRIVILEGE_MAP table

access privilege codes, SRF 2-185

TABLE_PRIVILEGES view, SRF 2-184

table-level Export, SUT 1-8

table-level Import, SUT 2-33

table-mode Export

specifying, SUT 1-24

table-mode Import

examples, SUT 2-35

Tables, SUT 2-63

tables

adding partitions, SAD 13-11

adding rows to, SQL 7-513

advanced queue (AQ)

exporting, SUT 1-57

advanced queue (AQ) importing, SUT 2-61

affect dependent views, SCN 21-5

allocating extents, SAD 14-11

allocating extents for, SQL 7-140

altering, ADG 3 - 9, SAD 14-10, SAD 14-11

analyzing statistics, SAD 20-3

appending rows with SQL*Loader, SUT 5-32

assigning to a cluster, SQL 7-377

attributes, OCI 6-7

auditing, SCN 11-63, SCN 31-8

base, SCN 1-24

data dictionary use of, SCN 2-2

relationship to views, SCN 10-12

changing degree of parallelism on, SQL 7-153

changing existing values in, SQL 7-585

clustered, SAD 17-2, SCN 10-46

clustered tables

privileges to drop, SAD 17-10

collecting modification statistics on, SQL 7-142

collecting statistics on, SQL 7-187

comparing, SPR 31 - 2, RAR 8-60

constraining, ADG 13 - 22

contain integrity constraints, SCN 1-58

contained in tablespaces, SCN 10-5

continuing a multiple table load, SUT 5-34

continuing a single table load, SUT 5-34

controlling space allocation for, SCN 10-4, SCN 25-8

creating, ADG 3 - 3, ADG 3 - 4, SAD 14-9, SQL 7-365

multiple, SQL 7-347

creating comments about, SQL 7-212

data dictionary, SRF 2-1

deallocating unused space from, SQL 7-141

default physical attributes

changing, SQL 7-135

defining before Import, SUT 2-14

definitions

creating before import, SUT 2-14

degree of parallelism

specifying, SQL 7-365

describing, OCI 6-2

designing, ADG 3 - 3

designing before creating, SAD 14-2

detail tables, STU 28-6

dimension tables (lookup tables), STU 28-5

dimensions

star queries, SCN 24-14

disassociating statistics types from, SQL 7-475

DML locks, SRF 1-37

drop column support, GTK 2-41

dropping, ADG 3 - 10, SAD 14-12

along with owner, SQL 7-483

dropping along with cluster, SQL 7-447

dropping indexes of, SQL 7-475

dropping partitions of, SQL 7-475

DUAL, SCN 2-7

dynamic partitioning, SCN 26-6

elements, PCO 7-2

enable or disable constraints, SCN 28-22

enabling parallelism for, STU 26-8

estimating size, SAD 14-5

exclusive access during direct path loads

SQL*Loader, SUT 8-25

exporting

specifying, SUT 1-24

fact tables, STU 28-6

star queries, SCN 24-14

formatter, in Oracle Trace, STU 15-5

free lists, SRF 1-28

full table scan and buffer cache, SCN 7-4

granting

system privileges on, SQL 7-500

guidelines, ADG 3 - 2, ADG 3 - 4

guidelines for managing, SAD 14-1, SAD 14-6

hash, SCN 10-55

hash clustered

creating, SAD 18-4

managing, SAD 18-1

historical, SCN 26-38

how data is stored in, SCN 10-4

importing, SUT 2-28

in PL/SQL, ADG 10 - 9

increasing column length, ADG 3 - 9, SAD 14-10

indexes and, SAD 16-2, SCN 10-21

index-organized

creating, SQL 7-372

key compression in, SCN 10-30, SCN 10-38

overflow segment for, SQL 7-372

space in index block, SQL 7-372

index-organized tables, SCN 10-36

logical rowids, SCN 10-39, SCN 12-20

insert triggers

direct path load

SQL*Loader, SUT 8-22

inserting rows into, PC_ F-68, PCO F-54

inserting rows using SQL*Loader, SUT 5-33

inserting rows with a subquery, SQL 7-384

integrity constraints, SCN 28-2, SCN 28-5

intersection, REP 3-13

key-preserved, ADG 3 - 29, SAD 15-5

limiting indexes on, SAD 16-3

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-96

LOB storage of, SQL 7-370

locating free space, SRF 1-52

location, ADG 3 - 4, SAD 14-10

location of, SAD 14-3

locking, SQL 7-520

locks on, SCN 11-45, SCN 27-21, SCN 27-23, SCN 27-25

logging

table creation, SQL 7-371

logging insert operations, SQL 7-142

lookup tables, SCN 24-14

maintaining consistency, SUT 1-17

managing, SAD 14-1

manually ordering for import, SUT 2-15

master groups

generating replication support for, REP 2-37

master table

Import, SUT 2-51

maximum number of columns in, SCN 10-12

migrated and chained rows in, SQL 7-192

modifying

without replicating changes, REP 8-34

moving to a new segment, SQL 7-134

mutating, ADG 13 - 22

name restrictions

storage characteristics, SQL 7-376

nested tables, SCN 10-9, SCN 13-12

indexes, SCN 14-6

no-logging mode, SCN 25-7

normalization

star schemas, SCN 24-15

normalized or denormalized, SCN 1-29, SCN 10-19

object

creating, SQL 7-358

object import order, SUT 2-4

object tables, SCN 13-3, SCN 13-7

constraints, SCN 14-5

indexes, SCN 14-6

triggers, SCN 14-6

virtual, SCN 15-2

order of row storage, SQL 7-372

ordering rows from, SQL 7-384

overview of, SCN 1-23, SCN 10-3

parallel creation, SCN 26-31

parallel creation of, SQL 7-380

parallel DDL storage, SCN 26-33

parallel table scans, SCN 26-4

parallelism

setting default degree, SQL 7-380

parallelizing creation of, SAD 14-4

parent/child relationships

maintaining across nodes, DDS 4-3

partition attributes of, SQL 7-145

PARTITION option, SCN 11-63

partitioned, NLS 4-8, SUT 1-8, SUT 2-5

allowing rows to move between partitions, SQL 7-153

default attributes of, SQL 7-145

replicating, REP 2-26

partitioned and indexes, REP A-4

partitioned in DB2

no Oracle equivalent, SUT B-4

partition-extended table names, SCN 11-63

partitioning of, SQL 2-64, SQL 7-365

partitions, SCN 11-2, SCN 11-27

physical attributes

changing, SQL 7-135

specifying, SQL 7-369

placement on disk, STU 20-22

presented in views, SCN 10-11

privileges for creation, ADG 3 - 8, SAD 14-9

privileges for dropping, ADG 3 - 11, SAD 14-12

privileges for partitions, SCN 11-62

privileges on, SCN 30-5

privileges to alter, ADG 3 - 10, SAD 14-10

problems generating replication support for, REP 7-32

queue tables, SCN 19-4, SCN 19-12

rectifying, SPR 31 - 5, RAR 8-63, REP 7-19

refreshing in data warehouse, SCN 26-37

relational

creating, SQL 7-358

remote, accessing, SQL 7-255

removing from the database, SQL 7-475

removing rows from, SQL 7-439

renaming, SQL 7-143, SQL 7-527

reorg, REP A-4

replacing rows using SQL*Loader, SUT 5-33

replicating, SCN 1-36

restricting records per block, SQL 7-143

restricting references to, SQL 7-225

retrieving data from, SQL 7-544

row locking, SRF 1-111

rows

ordering by primary key, SQL 7-372

saving blocks in a cache, SQL 7-142, SQL 7-383

schema of clustered, ADG 6 - 16, SAD 17-7

separating from indexes, SAD 14-6

single-table hash clusters, SCN 10-57

size

USER_SEGMENTS view, SUT 1-9

specifying PCTFREE for, ADG 3 - 5, SAD 12-4

specifying PCTUSED for, ADG 3 - 6

specifying table-mode Export, SUT 1-24

specifying tablespace, ADG 3 - 4, SAD 14-3, SAD 14-10

specifying tablespaces for, SCN 10-5

SQL examples, SQL 7-385

SQL*Loader method for individual tables, SUT 5-40

storage characteristics, SQL 7-575

defining, SQL 7-365, SQL 7-370

STORAGE clause with parallel execution, SCN 26-33

storage parameters, SAD 12-10

striping examples, STU 20-24

subpartition attributes of, SQL 7-145

SUBPARTITION option, SCN 11-63

summary or rollup, SCN 26-31

synonyms for, SQL 7-355

system

incremental export, SUT 1-50

SYSTEM tablespace and, SAD 14-3

table aliases, SCN 14-8, SCN 14-9

table items as arrays, SPR 48 - 15

table names

qualifying column names, SCN 14-8, SCN 14-9

tablespace for

defining, SQL 7-365, SQL 7-370

temporary, GTK 2-42, SCN 10-10

duration of data, SQL 7-377

segments in, SCN 4-18

session-specific, SQL 7-367

transaction specific, SQL 7-367

temporary space and, SAD 14-6

transaction parameters, SAD 14-3

triggers used in, SCN 20-2

truncating, ADG 3 - 10, SAD 20-9

SQL*Loader, SUT 5-33

unclustering, SQL 7-446

UNRECOVERABLE, SAD 14-4

updating existing rows using SQL*Loader, SUT 5-33

updating rows in, PC_ F-112, PCO F-85

validate or novalidate constraints, SCN 28-22

validating structure, SAD 20-8

validating structure of, SQL 7-191

virtual or viewed, SCN 1-24

with LOB columns

partitioning, SCN 11-38

with unusable indexes, SQL 7-88

tables of group items, PCO A-3

TABLES parameter

Export, SUT 1-24

Import, SUT 2-28

tables, host, PCO 7-2

tables, object, See object tables

tablespace

Tablespace and Extents page

Edit Snapshot property sheet, REP 5-27

tablespace backups

using RMAN, SBR 8-4, SBR 8-5, SBR 8-6

TABLESPACE clause, STU 20-24

CREATE TABLE statement, STU 20-24

of CREATE CLUSTER, SQL 7-239

of CREATE INDEX, SQL 7-282

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-316

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-302

of CREATE ROLLBACK SEGMENTS, SQL 7-345

of CREATE TABLE, SQL 7-370

tablespace metadata

transporting, SUT 2-31

tablespace point-in-time recovery, GTK 3-6, SBR B-25

tablespace set, SAD 9-20

tablespaces, SCN 3-6, SQL 7-168

adding datafiles, SAD 10-5

allocating space for users, SQL 7-427

allowing write operations on, SQL 7-169

altering availability, SAD 9-10

altering storage settings, SAD 9-8

assigning defaults for users, SAD 23-12

assigning user quotas, SAD 9-3

backing up datafiles of, SQL 7-168

bringing online, SAD 9-10, SQL 7-168, SQL 7-396

checking default storage parameters, SAD 9-31

coalescing, SAD 9-8

coalescing free extents, SQL 7-169

compatibility, MIG 8-9

contrasted with schemas, SCN 10-2

converting

from permanent to temporary, SQL 7-169

from temporary to permanent, SQL 7-169

creating, SAD 9-3, SQL 7-394

creating additional, SAD 9-4

datafile

adding, SQL 7-167

renaming, SQL 7-167

default for object creation, SCN 1-42, SCN 29-13

default quota, SAD 23-13

default storage characteristics, SQL 7-575

default storage parameters for, SAD 12-10

default temporary, SAD 23-13

defining as read only, SQL 7-169

described, SCN 3-6

designing media recovery, SQL 7-12

dictionary-managed, SCN 3-7

dropping

about, SAD 9-14

required privileges, SAD 9-15

dropping during import, SUT 2-54

dropping the contents of, SQL 7-477

enable autoextension of, SQL 7-167

Export, SUT 1-49

extent management of, SQL 7-399

extent size of, SQL 7-395

granting

system privileges on, SQL 7-500

guidelines for managing, SAD 9-2

how specified for tables, SCN 10-5

listing files of, SAD 9-31

listing free space in, SAD 9-32

locally managed, GTK 2-41, SQL 7-396, SQL 7-576

temporary, SQL 7-399

locally-managed, SCN 3-8

temporary tablespaces, SCN 3-13

location, SAD 10-4

locks on, SCN 27-30

logging attribute of, SQL 7-166, SQL 7-395

managed using dictionary tables, SQL 7-396

managing, SAD 10-1

managing extents of, SQL 7-396

migrating offline tablespaces, MIG 3-10, MIG 4-8

MINIMUM EXTENT

parallel DML, SCN 25-10

monitoring, SAD 10-13

moving or copying to another database, SCN 3-14

no-logging mode, SCN 25-7

of session duration, SQL 7-398

offline, SCN 1-10, 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-9

online, SCN 1-10, SCN 3-9, SCN 3-17

online read-only, GTK 2-42

overview of, SCN 1-9, SCN 3-6

permanent objects in, SQL 7-396

point-in-time recovery, GTK 3-6

privileges for creating, SAD 9-4

privileges to take offline, SAD 9-10

quotas

assigning, SAD 9-3

quotas for users, SAD 23-13

quotas on, SCN 1-42, SCN 1-43, SCN 29-13, SCN 29-14

limited and unlimited, SCN 29-14

no default, SCN 29-14

read-only, SAD 9-12, SCN 3-10

backing up, SBR 8-15

dropping objects from, SCN 3-12

effect on recovery, SBR 14-5

Import, SUT 2-54

transition mode, SCN 3-11

recovering, SQL 7-13

recovering offline in open database, SBR 14-23

relationship to datafiles, SCN 3-2

removing from the database, SQL 7-477

reorganizing

Import, SUT 2-54

revoking access from users, SCN 29-14

revoking from users, SAD 23-14

rollback segments required, SAD 9-5

setting default storage parameters for, SAD 9-3

size of, SCN 3-4

size of free extents in, SQL 7-168

space allocation, SCN 3-7

specifying datafiles for, SQL 7-395

specifying for a user, SQL 7-427

specifying for index rebuild, SQL 7-135

SYSTEM tablespace, SAD 9-4

taking offline, SQL 7-168, SQL 7-396

taking offline normal, SAD 9-10

taking offline temporarily, SAD 9-11

tempfile

adding, SQL 7-167

temporary, SAD 23-13, SCN 1-43, SCN 3-12

default for user, SCN 29-13

specifying for a user, SQL 7-427

temporary objects in, SQL 7-396

temporary, creating, SQL 7-398

transition read only mode, SCN 3-11

transportable, GTK 2-23, SCN 3-13

unlimited quotas, SAD 23-14

used for temporary segments, SCN 4-16, SCN 4-18

using multiple, SAD 9-2

viewing quotas, SAD 23-24

writable, SAD 9-14

See also SYSTEM tablespace

TABLESPACES parameter, SUT 2-29

TABQUOTAS view, SRF 2-185

tabs

loading data files containing tabs, SUT 5-50

trimming, SUT 5-82

whitespace, SUT 5-82

TABS synonym for USER_TABLES, SRF 2-185

TAF, SCN 32-14

taking offline

tablespaces, SAD 9-10

TAN function, SQL 4-42

TANH function, SQL 4-42

tape archiving destination, SRF 1-60

tape devices

auto media management, LEG 3-19

tape drives

streaming for archiving, SAD 7-23

TAPE_ASYNCH_IO parameter, STU 26-29

initialization parameters

TAPE_ASYNCH_IO, SRF 1-122

target database

definition, MIG 1-3

tasks, SCN 8-2

Tasks tab

from Create Job property sheet, PSC 6-35

TCP/IP

described, NET 4-25

parameters for addresses, NET 6-79

TCP/IP with SSL, NET 4-7

described, NET 4-25

parameters for addresses, NET 6-79, NET 6-80

TCP/IP with SSL Protocol

described, NET 4-7

TCP.NODELAY option, STU 22-3

TCP.NODELAY parameter, NET 3-14, NET C-81

TDO

definition, OCI 12-2

description, OCI 11-23

obtaining, OCI 11-23

type descriptor object. See TDO.

TDO. See type descriptor object

TEMP tablespace raw device, PSC 2-6

TEMPFILE clause

of ALTER DATABASE, SQL 7-8, SQL 7-17

of CREATE TEMPORARY TABLESPACE, SQL 7-399

TEMPFILE clauses

of ALTER DATABASERENAME FILE clause

OF ALTER DATABASE, SQL 7-8

tempfiles, SCN 3-17

automatic extension of, SQL 7-399

bringing online, SQL 7-17

data dictionary information, MIG 8-23

disabling automatic extension, SQL 7-17

dropping, SQL 7-17

enabling automatic extension, SQL 7-17

specifying, SQL 7-399, SQL 7-490

taking offline, SQL 7-17

Template

See Deployment Template

TEMPLATE.TBL file, PSC 2-13, PSC 4-3

TEMPORARAY clause

of ALTER TABLESPACE, SQL 7-169

TEMPORARY clause

of CREATE TABLESPACE, SQL 7-396

temporary extent, STU 26-70

TEMPORARY keyword, STU 20-36

temporary LOBS, STU 19-30

temporary segment enqueue, SRF B-2

temporary segments, SCN 4-16, SCN 4-18, SCN 10-10, SUT 8-28

allocating, SCN 4-18

allocation for queries, SCN 4-18

deallocating extents from, SCN 4-16

dropping, SCN 4-16

FILE keyword

SQL*Loader, SUT 8-29

ignore quotas, SCN 29-14

index creation and, ADG 6 - 2, SAD 16-3

not exported during backup, SUT 1-49

operations that require, SCN 4-18

parallel DDL, SCN 26-33

parallel INSERT, SCN 25-8

tablespace containing, SCN 4-16, SCN 4-18

when not in redo log, SCN 4-19

temporary space

allocating, SAD 14-6

temporary storage in a direct path load, SUT 8-11

temporary table enqueue, SRF B-2

temporary tables, GTK 2-42, SCN 10-10

compatibility, MIG 8-10

creating, SQL 7-365, SQL 7-367

dropping for downgrading, MIG 12-6

session-specific, SQL 7-367

transaction-specific, SQL 7-367

temporary tablespace

optimizing sort, STU 20-36

size, STU 26-70

space

insufficient for migration, MIG A-2

striping, STU 26-70

TEMPORARY TABLESPACE clause

of ALTER USER. See CREATE USER.

of CREATE USER, SQL 7-427

temporary tablespaces, SCN 3-12

creating, SQL 7-398

specifying for a user, SQL 7-427

SQL examples, SQL 7-399

TEMPORARY_TABLE_LOCKS parameter, SRF 1-122

terminal

encoding scheme, PC_ 4-49

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-84

terminated fields

specified with a delimiter, SUT 5-84

specified with delimiters and SQL*Loader, SUT 5-70

terminating

a user session, SAD 4-15

terminating condition, PLS 7-38

terminating sessions

active sessions, SAD 4-16

identifying sessions, SAD 4-16

inactive session, example, SAD 4-17

inactive sessions, SAD 4-17

termination, program

normal versus abnormal, PC_ 3-22

terminator

statement, PLS 2-3

terminator for embedded SQL statements, PCO 2-19

terminator, SQL statements, PCO A-7

terminology

migration, MIG 1-2

navigational functions, OCI 16-4

used in this manual, OCI 1-11

ternary operator, PLS 2-41

territories, NLS A-5

supported, NLS A-5

territory, NLS 2-8, SRF 1-79, SRF 1-82

territory support, NLS 1-4

test

security for databases, SAD 22-9

test databases, creating, SBR 4-52

testing, STU 2-13

applications for migration, MIG 2-23

backup strategies, SBR 3-24

client using 3GL, NET 8-9

client using application, NET 8-9

client using OS, NET 8-9

client using special commands, NET 8-10

developing a plan for migration, MIG 2-19

EXPLAIN PLAN, MIG 2-22

functional for migration, MIG 2-20

integration for migration, MIG 2-20

INTO clause, MIG 2-22

listener, NET 8-18

media manager, SBR 4-19

migration results, MIG 6-6

minimal for migration, MIG 2-19

network connectivity, NET 8-20

network objects, NET 8-17

Oracle Connection Manager, NET 8-18

Oracle Names servers, NET 8-16

performance for migration, MIG 2-20

pre- and post-migration, MIG 2-21

the migrated test database, MIG 2-23

the migration process, MIG 2-22

volume/load stress for migration, MIG 2-21

with control utilities, NET 8-15

text

date and number formats, SQL 2-33

in SQL syntax, SQL 2-2

properties of CHAR and VARCHAR2 datatypes, SQL 2-2

syntax of, SQL 2-2

text date format element, SQL 2-41

text in, SQL 2-40

TEXT_ENABLE parameter, SRF 1-122

TH date format element suffix, SQL 2-45

The, NET 2-7, NET 4-15, NET 4-18, NET 4-19, NET 7-50, PSC 5-28, PSC 6-18, PSC 6-21, PSC 6-24, PSC 6-27

THE keyword for subqueries, GTK 6-7

THEN clause, PLS 3-3

third generation language, ADG 10 - 2

third generation language (3GL) routines, DDS 5-4

third party applications, NET 5-7

thrashing, STU 18-4

thread, STU 24-2

archive file format, SPS 21-5

archiving redo log files, SPS 21-4, SPS 21-10

associated with an instance, SPS 14-8

closed, SPS 21-16

disabled, SPS 14-9

enabled, SPS 21-7, SPS 21-16, SPS 22-10

example, SPS 6-3

exclusive mode, SPS 18-15

forced log switch, SPS 21-10

log history, SPS 21-7

number of groups, SPS 6-4

open, SPS 21-7, SPS 21-16

public, SPS 14-8

single, SPS 4-8

thread ID, PSC 1-12

thread management functions, OCI 15-171

THREAD option, SPS 18-18, SPS 21-4, SPS 21-10

creating private thread, SPS 6-3

creating public thread, SPS 6-3

disabling a thread, SPS 14-9

when required, SPS 14-8

THREAD parameter, PSC 1-12, PSC 6-4, PSC 6-10, SPS 14-8, SPS 18-5, SPS 18-10, SRF 1-122

conversion to multi-instance, SPS 23-7

individual parameter files, SPS 18-5

instance acquiring thread, SPS 6-3

thread safety, OCI 8-14

advantages of, OCI 8-14

and three-tier architectures, OCI 8-14

basic concepts, OCI 8-15

compatibility, MIG 8-18

implementing with OCI, OCI 8-15

mixing 7.x and 8.0 calls, OCI 8-16

required OCI calls, OCI 8-15

THREADS

precompiler option, PC_ 10-40, PC_ 11-8

threads, PC_ F-28, PCO F-19

allocating context, PC_ 11-8, PC_ F-28, PCO F-19

enabling, PC_ 11-8, PC_ F-50

freeing context, PC_ 11-10, PC_ F-29, PCO F-20

multi-threaded server, SCN 8-14, SCN 8-16

online redo log, SAD 6-2

use context, PC_ 11-9, PCO F-21

three-tier architectures

and thread safety, OCI 8-14

three-valued logic (true, false, unknown)

produced by nulls, SCN 10-8

threshold level, OAS 7-3, OAS 7-5

throughput, SCN 22-7, STU 1-3

cost-based approach, SCN 23-31

optimizing, STU 7-4, STU 7-38

THSP date format element suffix, SQL 2-45

ticket, OAS Glossary-7

ticket, initial, OAS Glossary-3

TICKS attribute, NET 7-49, NET 9-7

tiers, STU 18-11

tightly coupled system

hardware architecture, SPS 3-3, SPS 3-5

implementations, SPS 3-2

in loosely coupled cluster, SPS 3-5

performance, SPS 3-4

TIME datatype (SQL/DS or DB2), SQL 2-25

time format

RECOVER DATABASE UNTIL TIME statement, SBR 14-31

Time parameters, NLS 2-11

time parameters

setting for Recovery Manager use, SBR 5-2

Time Series, GTK 2-13

Time Series cartridge

use in power demand example, DCI 11-48

time window

moving, in historical table, SAD 13-20

time-based recovery, SBR 14-29 to SBR 14-31

coordinated in distributed databases, SBR 15-16

definition, SBR 3-28

TIMED_OS_STATISTICS parameter, SRF 1-123

of ALTER SYSTEM, SQL 7-108

TIMED_QUERY command, NET A-86

TIMED_STATISTICS parameter, SRF 1-124, STU 14-4, STU 24-1, STU 26-79

file read/write statistics, SRF 3-46, SRF 3-125

of ALTER SESSION, SQL 7-89

of ALTER SYSTEM, SQL 7-108

SQL Trace, STU 14-4

TIMEOUT parameter, NET 6-74

TIMEOUT parameter, role in listener-created server processes, NET 2-24

TIMEOUT_ON_RESOURCE exception, PLS 6-6

timer in sksawat wait event, SRF A-48

timer initiated disconnect

see dead connection detection

TimeScale package, SPR 1 - 15

TimeSeries package, SPR 1 - 16

timestamp checking, SCN 21-11

TIMESTAMP column

PLAN_TABLE table, STU 13-3

timestamp conflict resolution methods

sample trigger, REP 6-32

TIMESTAMP datatype (SQL/DS or DB2), SQL 2-25

timestamps

PL/SQL library unit dependencies, ADG 10 - 28

Timout option, NET 6-74

tip

object privilege shortcut, SAD 24-3

shortcuts for auditing objects, SAD 25-9

statement auditing shortcut, SAD 25-8

TKPROF program, STU 14-2, STU 14-6, STU 19-39

editing the output SQL script, STU 14-17

example of output, STU 14-15

generating the output SQL script, STU 14-17

introduction, STU 12-6

syntax, STU 14-7

using the EXPLAIN PLAN statement, STU 14-10

TKPROF_TABLE, STU 14-18

querying, STU 14-17

TM number format element, SQL 2-36

TM, DML Enqueue, SPS 10-3

tnnfg utility, sample of usage, OAS 13-16

TNS, SMS 25-1

see Transparent Network Substrate

TNS Time Out Value option, NET 7-23

TNS_ADMIN environment variable, NET 11-5, PSC B-5, PSC B-6

tns_admin parameter, PSC B-5, PSC B-9

TNS_ADMIN parameter, NET 11-5

TNS-01169 error message, NET 8-14

TNSAPI.A file, NET 9-8

TNSAPI.DLL file, NET 9-8

TNSAPI.H file, NET 9-8

TNSAPI.LIB file, NET 9-8

TNSNAMES value, NET 7-19

TNSNAMES.ORA, STU 25-21

configuring for instance registration, SPS 18-29

loading into CDS using tnnfg, OAS 13-16

modifying to load connect descriptors into CDS, OAS 13-15

renaming, OAS 13-16

see local naming, configuration file

TNSNAMES.ORA file, PSC 4-13, PSC 5-7, PSC 5-11, PSC 5-29, SAD 7-12, SBR 16-10

BACKUP parameter, PSC 4-44

configuring, PSC 4-20

configuring transparent application failover, PSC 4-43

FAILOVER parameter, PSC 4-35, PSC 4-41

FAILOVER_MODE parameter, PSC 4-35, PSC 4-43

how used for auto-discovery, PSC C-7

INSTANCE_NAME parameter, PSC 4-29

LOAD_BALANCE parameter, PSC 4-25, PSC 4-41

METHOD parameter, PSC 4-45

SERVICE_NAME parameter, PSC 4-29

TYPE parameter, PSC 4-44

TNSNAV.ORA file, migration issues, NET 5-22

TNSNET.ORA file, migration issues, NET 5-22

TNSPING utility, NET 8-20

compared to TRCROUTE utility, NET 8-23

TNSPING.TRACE_DIRECTORY parameter, NET 11-35, NET C-27

TNSPING.TRACE_LEVEL parameter, NET 11-35, NET C-27

To, PSC 4-29, SAD 10-5, SAD 21-12

TO clause

of ROLLBACK statement, PC_ F-100

TO PUBLIC clause

of GRANT object_privileges, SQL 7-507

of GRANT system_privileges_and_roles, SQL 7-494

TO role clause

of GRANT object_privileges, SQL 7-507

of GRANT system_privileges_and_roles, SQL 7-494

TO SAVEPOINT clause, PCO 3-24

in ROLLBACK statement, PC_ 3-20

of ROLLBACK, SQL 7-537

purpose of, PC_ 3-20

restriction on, PC_ 3-21

restrictions, PCO 3-26

using in ROLLBACK statement, PCO 3-24

TO user clause

of GRANT object_privileges, SQL 7-507

of GRANT system_privileges_and_roles, SQL 7-494

TO_CHAR

date conversion function, SQL 4-43

number conversion function, SQL 4-43

TO_CHAR function, ADG 4 - 25, SQL 2-32, SQL 2-35, SQL 2-40, SQL 2-46, SRF 1-78

CC date format, ADG 4 - 12

converting Trusted Oracle labels, ADG 4 - 28

data conversion, SCN 12-23

default date format, NLS 2-12

format masks, NLS 4-9

group separator, NLS 2-19

Julian dates, SCN 12-11

language for dates, NLS 2-14

NLS default in CHECK constraints, SCN 28-18

NLS default in views, SCN 10-14

RR date format, ADG 4 - 11

spelling of days and months, NLS 2-14

TO_DATE function, ADG 4 - 8, ADG 4 - 25, SCN 12-10, SQL 2-32, SQL 2-40, SQL 2-44, SQL 2-46, SQL 4-45, SRF 1-78

data conversion, SCN 12-23

default date format, NLS 2-12

format masks, NLS 4-9

Julian dates, SCN 12-11

language for dates, NLS 2-14

NLS default in CHECK constraints, SCN 28-18

NLS default in views, SCN 10-14

partitions, SCN 11-14, SCN 11-21

RR date format, ADG 4 - 11

spelling of days and months, NLS 2-14

TO_LABEL function

converting Trusted Oracle labels, ADG 4 - 28

TO_LOB function, SQL 2-32, SQL 4-45

TO_MULTI_BYTE function, SQL 4-46

TO_NUMBER function, ADG 4 - 25, SCN 12-9, SQL 2-32, SQL 2-35, SQL 4-46

data conversion, SCN 12-23

format masks, NLS 4-9

group separator, NLS 2-19

Julian dates, SCN 12-11

NLS default in CHECK constraints, SCN 28-18

NLS default in views, SCN 10-14

TO_SINGLE_BYTE function, SQL 4-47

TOID_NOVALIDATE parameter, SUT 2-30

token cards, OAS 1-8, OAS Glossary-7

token passing, REP 8-31

sample implementation, REP 8-30

TOO_MANY_ROWS exception, PLS 6-6

Toolset

Oracle, PC_ 20-14

top-down design, PLS 1-15

top-level memory

of object, OCI 13-16

top-N queries, SQL 2-56

Total Elapsed Time data view, STU 15-10

total file opens statistic, SRF C-20

TOTAL_REFUSED, NET A-91

TOTAL_RELAYS, NET A-91

TouchNet II, OAS 7-4

TOUSER

Import parameter, SUT 2-31

TP monitor, SPS A-11

TP monitors, MIG 2-17

TP_NAME parameter, NET 6-79

TPN parameter, NET 6-79

TRACE command, NET A-30

trace facility

function of, PC_ C-6

using to improve performance, PC_ C-6, PCO D-6

trace file

conversion to multi-instance, SPS 23-4

error message information, NET 11-42

example, NET 11-53

example of error messages, NET 11-42

example of packet data, NET 11-41

snapshots, REP 7-35

SQLNETthread_id.TRC, NET C-29

SQLNET.TRC, NET C-29

trace files, PSC C-11, SCN 8-14

ARCn trace file, SCN 32-20

background thread trace files, PSC C-11

CMADM_PIDTRC, NET 11-37

control file backups to, SBR 13-12

DBWn trace file, SCN 32-6

default names for, NET 11-32

destination, SRF 1-17, SRF 1-126

error call trace stack, PSC C-13

job failures and, SAD 8-10

LGWR trace file, SCN 8-9

LISTENER.TRC, NET 11-36

location of, SAD 4-11, SRF 1-17

log writer, SAD 4-11

log writer process and, SAD 6-6, SBR 2-13

maximum size, SRF 1-71

NAMES.TRC, NET 11-37

ORAXXXXX.TRC, PSC C-12

SIDALRT.LOG, PSC C-12

SIDBSP0.TRC, PSC C-12

SIDDBWR.TRC file, PSC C-11

SIDLCKN.TRC, PSC C-12, PSC C-13

SIDLMDN.TRC, PSC C-12

SIDLMON.TRC file, PSC C-12

SIDP00N.TRC, PSC C-12

SIDSMON.TRC file, PSC C-11

size of, SAD 4-11

SQLNETthread_id.TRC, NET 11-37

SQLNET.TRC, NET 11-37

SQLNET.TRC for clients, NET 11-33

SVR_PID for servers, NET 11-33

using, SAD 4-10, SAD 4-11

when written, SAD 4-12

Trace, Oracle, STU 15-1

TRACE_DIRECTORY parameter, NET 11-36, NET 11-37, NET C-63, NET C-79

TRACE_DIRECTORY_CLIENT parameter, NET 11-33, NET C-27

TRACE_DIRECTORY_SERVER parameter, NET 11-34, NET C-27

TRACE_FILE parameter, NET 11-36, NET C-63

TRACE_FILE_CLIENT parameter, NET 11-34, NET C-27

TRACE_FILE_SERVER parameter, NET 11-34, NET C-28

TRACE_LEVEL parameter, NET 11-36, NET C-64

TRACE_LEVEL_CLIENT parameter, NET 11-33, NET C-28

TRACE_LEVEL_SERVER parameter, NET 11-34, NET C-29

TRACE_UNIQUE_CLIENT parameter, NET C-29

tracing on client, NET 11-37, NET C-29

TRACING parameter, NET 11-37, NET C-79

tracking volume modes, LEG 2-9

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-19, PLS 5-2

transaction control statements, SCN 1-53, SCN 16-5, SQL 6-4

in autonomous PL/SQL blocks, SCN 17-10

PL/SQL support of, SQL 6-4

transaction enqueue, SRF B-2

transaction entries

guidelines for storage, SAD 12-9

transaction functions, OCI 15-199

transaction handle

attributes, OCI A-13

description, OCI 2-9

transaction identifier, OCI 8-4

transaction management

overview, DDS 3-2

transaction processing, PLS 5-2, PLS 5-40

overview of, PC_ 2-8

statements used for, PC_ 2-8

transaction processing monitor, PC_ 5-54, SPS 12-7, STU 18-12, STU 18-13

transaction recovery

fast-start checkpointing, GTK 2-51

Fast-Start on-demand rollback, GTK 2-52

Fast-Start parallel rollback, GTK 2-52

inter-transaction, GTK 2-52

intra-transaction, GTK 2-52

transaction recovery enqueue, SRF B-2

transaction rollbacks statistic, SRF C-20

transaction set consistency, SCN 27-10

transaction tables, SCN 4-20

reset at recovery, SCN 8-11

transaction tables consistent read rollbacks statistic, SRF C-20

transaction tables consistent reads - undo records applied statistic, SRF C-20

transaction visibility, PLS 5-55

transaction wait event, SRF A-48

TRANSACTION_AUDITING parameter, SRF 1-124

of ALTER SYSTEM, SQL 7-108

transactional complexity

levels in OCI, OCI 8-3

TRANSACTIONAL option

SHUTDOWN, STU 25-22

transactions, SCN 1-53, SCN 17-1

advanced queuing, SCN 19-3

allowing to complete, SQL 7-99

assigning rollback segment to, SQL 7-572

assigning rollback segments, STU 20-29

assigning system change numbers, SCN 17-5

assigning to a specific rollback segment, SQL 7-573

assigning to rollback segments, SCN 4-21

assigning to specific rollback segment, SAD 21-13

asynchronous processing, SCN 19-2

automatically committing, SQL 7-214

autonomous, ADG 8 - 33, SCN 17-9

within a PL/SQL block, SCN 17-9

block-level recovery, SCN 27-21, SCN 32-14

closing database links, DDS 4-2

commenting on, SQL 7-215

committing, OCI 2-26, PC_ F-24, PCO F-15, SCN 1-54, SCN 8-10, SCN 17-3, SCN 17-5

group commits, SCN 8-10

use of rollback segments, SCN 4-21

writing redo log buffers and, SAD 6-2

concurrency and, SCN 27-15

concurrent, SRF 1-125

contents, PCO 3-20

contents of, PC_ 2-8, PC_ 3-17

controlling transactions, SCN 16-14

data locking, SRF 1-37

dead, SCN 32-4

deadlocks and, SCN 17-4, SCN 27-17

deferred

deleting, REP 7-11

executing, REP 7-10

defining and controlling, SCN 16-14

definition of, PC_ 2-8

described, SCN 17-2

description of, PC_ 3-16

discrete, STU 9-1

discrete transactions, SCN 16-14, SCN 17-8

distributed, PC_ F-102, SCN 1-32

deadlocks and, SCN 27-18

parallel DDL restrictions, SCN 26-28

parallel DML restrictions, SCN 26-28, SCN 26-46

read-only, DDS 3-17

resolving automatically, SCN 8-12

restrictions, DDS 2-26

two-phase commit, SCN 1-35, SCN 17-7, SCN 33-13

two-phase commit and, DDS 1-13

distributed, forcing, SQL 7-79

distribution among rollback segments of, SCN 4-21

end of, SCN 17-4

consistent data, SCN 16-14

ending, SQL 7-214

error

displaying, REP 7-12

establish as read-only, SQL 7-572

establish as read-write, SQL 7-572

external LOBs do not participate, ADL 1-3

failure during, PC_ 3-17

global, OCI 8-4

branch states, OCI 8-6

branches, OCI 8-4

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-31

guidelines for, PC_ 3-27

how to begin, PC_ 3-17, PCO 3-20

how to end, PC_ 3-17, PCO 3-20

implicit commit of, SQL 6-2, SQL 6-4, SQL 6-5

in-doubt, DDS 3-4, PCO 3-30

after a system failure, DDS 3-19

limit rollback segment access, SCN 4-30

pending transactions table, DDS 3-29

recoverer process (RECO) and, DDS 3-34

resolving automatically, SCN 1-36, SCN 5-8, SCN 17-8

resolving manually, SCN 1-36

rollback segments and, SCN 4-24

use partly available segments, SCN 4-30

in-doubt, committing, SQL 7-214

in-doubt, forcing, SQL 7-215

initialization parameters, OCI 8-10

internal LOBs participate fully, ADL 1-2

isolation level, SQL 7-572

LOB locators cannot span, ADL 1-49

local, OCI 8-3

locks, releasing, SQL 7-214

making permanent, PC_ 3-18, PCO 3-20

manual locking, ADG 8 - 11

manual locking of, SCN 27-31

manual overriding in-doubt, DDS 3-21

migrating from, ADL 2-20

OCI functions for

transactions, OCI 8-2

overview of, SCN 1-53

propagation

protection mechanisms, REP 2-42 to REP 2-44

queue for

deferred, diagnosing problems with, REP 7-33

rate, STU 27-12

read consistency of, SCN 1-31, SCN 27-6

read-only, ADG 8 - 8, OCI 8-3, PC_ 3-23, PCO 3-26, SCN 1-32, SCN 27-6

distributed, DDS 3-17

not assigned to rollback segments, SCN 4-20

recovery, SCN 32-4

redo log files written before commit, SCN 8-10

rollback, SBR 1-8

rollback segments, SRF 1-125

rollback segments and, SAD 21-13, SCN 4-20

rolling back, OCI 2-26, PC_ F-99, PCO F-74, SCN 1-54, SCN 17-6, SQL 7-100, SQL 7-345, SQL 7-537

and offline tablespaces, SCN 4-30

partially, SCN 17-6

to a savepoint, SQL 7-537

use of rollback segments, SCN 4-20

savepoints for, SQL 7-539

savepoints in, SCN 1-55, SCN 17-7

serializable, ADG 8 - 23, OCI 8-3, SCN 27-7, STU 9-5

serialization of, REP 8-3

SET TRANSACTION command, ADG 8 - 8

setting read-committed isolation mode, SQL 7-573

setting serializable isolation mode, SQL 7-573

space used in data blocks for, SCN 4-5

start of, SCN 17-4

statement level rollback and, SCN 17-4

subdividing with savepoints, PC_ 3-19, PCO 3-24

system change numbers, SCN 8-10

terminating, PC_ 3-18

terminating the application and, SCN 17-5

transaction control statements, SCN 16-5

triggers and, SCN 20-23

two-phase commit in parallel DML, SCN 26-40

uncommitted, SBR 1-8

undoing, PC_ 3-20, PCO 3-22

undoing parts of, PC_ 3-19, PCO 3-24

when rolled back automatically, PC_ 3-17, PC_ 3-22, PCO 3-20, PCO 3-23

writing to rollback segments, SCN 4-22

transactions folder

forcing a commit

Enterprise Manager, DDS 3-31

forcing a rollback

Enterprise Manager, DDS 3-31

TRANSACTIONS parameter, SCN 4-27, SPS 6-10, SRF 1-110, SRF 1-125, STU 26-25

calculating non-PCM resources, SPS 16-4

DML locks, SRF 1-37

ensuring LM lock capacity, SPS 16-6

using, SAD 21-2

TRANSACTIONS_PER_ROLLBACK parameter, SPS 6-10

TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, SCN 4-27, SRF 1-110, SRF 1-125

using, SAD 21-2

transient copies of objects, PC_ 17-4

transient objects, OCI 10-7, PC_ 17-4

LOB

attributes, OCI 7-6

meta-attributes, OCI 10-20

transition read only tablespaces, SCN 3-11

TRANSLATE ... USING function, SQL 4-48

TRANSLATE function, SQL 4-47

translated messages, NLS A-4

transmission time, STU 17-5

transmitting archived redo logs, SAD 7-14, SBR 2-21, SBR 16-7

in normal transmission mode, SAD 7-14, SBR 2-21

in standby transmission mode, SAD 7-14

transparency, DDS 2-20

location

using procedures, DDS 2-24

query, DDS 2-25

update, DDS 2-25

Transparent Application Failover, SCN 32-14

transparent application failover, GTK 3-8, NET C-43, PSC 4-35, STU 25-19

configuring, PSC 4-43

with connect-time failover, PSC 4-43

Transparent Gateway, STU 8-11

Transparent Network Substrate (TNS)

benefits, NET 2-6

layer in stack communications, NET 2-12

main components, NET 2-12

transport layer, described, NET 2-8

TRANSPORT_TABLESPACE parameter, SUT 2-31

transportable tablespaces, GTK 2-23, SAD 9-18, SCN 3-13, SUT 2-63

compatibility, MIG 8-9

recovery, SBR 15-4

removing transported tablespaces, MIG 12-5

TSPITR and, SBR B-3

TRCROUTE utility

described, NET 8-23

performance effects, NET 8-23

requirements for, NET 8-23

using with listener load balancing, NET 8-24

triggers, SCN 1-59, SCN 20-1, SCN 21-8

, SUT 8-23

about, ADG 10 - 26

accessing column values, ADG 13 - 15

action, SCN 20-7

timing of, SCN 20-9

AFTER, ADG 13 - 7, ADG 13 - 16, ADG 13 - 35, ADG 13 - 38, SQL 7-403

AFTER triggers, SCN 20-9

as program units, SCN 1-56

auditing, SAD 25-20, SCN 31-8

auditing with, ADG 13 - 34, ADG 13 - 36

BEFORE, ADG 13 - 7, ADG 13 - 16, ADG 13 - 48, ADG 13 - 49, SQL 7-403

BEFORE triggers, SCN 20-9

body, ADG 13 - 14, ADG 13 - 17, ADG 13 - 18, ADG 13 - 20

cascading, SCN 20-4

check constraints, ADG 13 - 47, ADG 13 - 48

client events, ADG 14 - 5

column list in UPDATE, ADG 13 - 6, ADG 13 - 18

compatibility, MIG 8-14

compiled, ADG 13 - 27

compiling, SQL 7-171

conditional predicates, ADG 13 - 14, ADG 13 - 17

constraints apply to, SCN 20-21

constraints contrasted with, SCN 20-5

creating, ADG 13 - 3, ADG 13 - 20, ADG 13 - 25, SQL 7-402

creating multiple, SQL 7-404

data access and, SCN 20-23

data access restrictions, ADG 13 - 48

database

altering, SQL 7-171

dropping, SQL 7-479, SQL 7-483

database insert triggers

, SUT 8-22

debugging, ADG 13 - 29

dependency management of, SCN 20-25, SCN 21-6

enabled triggers, SCN 20-21

designing, ADG 13 - 2

disabling, ADG 13 - 30, SAD 20-12, SQL 7-154, SQL 7-171

distributed query creation, ADG 10 - 47, DDS 4-3

dropped automatically when downgrading, MIG 12-35

dropped tables and, ADG 3 - 10, SAD 14-12

enabled or disabled, SCN 20-21

enabling, ADG 13 - 30, SAD 20-12, SQL 7-154, SQL 7-171, SQL 7-402

enforcing data integrity with, SCN 28-4

enforcing referential integrity, DDS 4-3

error conditions and exceptions, ADG 13 - 18

events, ADG 13 - 5, SCN 20-6

examples, ADG 13 - 34, ADG 13 - 36, ADG 13 - 38, ADG 13 - 41, ADG 13 - 47, ADG 13 - 48, ADG 13 - 50, SAD 25-20

examples of, SCN 20-10, SCN 20-13, SCN 20-23

executing with a PL/SQL block, SQL 7-407

executing with an external procedure, SQL 7-407

firing (executing), SCN 20-2, SCN 20-25

privileges required, SCN 20-25

steps involved, SCN 20-21

timing of, SCN 20-21

FOR EACH ROW clause, ADG 13 - 12

generating derived column values, ADG 13 - 49

granting

system privileges on, SQL 7-500

illegal SQL statements, ADG 13 - 20

in tuning OLTP applications, STU 4-4

INSTEAD OF, SQL 7-404

dropping, SQL 7-432

INSTEAD OF triggers, ADG 13 - 7, SCN 20-12

object views and, SCN 15-5

integrity constraints vs., ADG 13 - 2, ADG 13 - 40

internal, REP A-2

INVALID status, SCN 21-2, SCN 21-6

Java, SCN 20-7

listing information about, ADG 13 - 32

maintain data integrity, SCN 1-59

maintaining parent/child table relationships across nodes, DDS 4-3

migration issues, ADG 13 - 28

modifying, ADG 13 - 29

multiple same type, ADG 13 - 21

mutating tables and, ADG 13 - 22

naming, ADG 13 - 5

on DATABASE and SCHEMA, GTK 2-39

on database events, SQL 7-405

on DDL events, SQL 7-405

on DML operations, SQL 7-404

on nested table view columns, GTK 2-35

downgrading, MIG 12-34

on views, SQL 7-404

Oracle Forms triggers vs., SCN 20-3

order of firing, SQL 7-404

overview of, SCN 1-59, SCN 20-2

package variables and, ADG 13 - 21

parts of, SCN 20-5

permanently disabled

, SUT 8-25

prerequisites before creation, ADG 13 - 4

privileges, ADG 13 - 25

to drop, ADG 13 - 29

privileges for enabling and disabling, SAD 20-12

privileges for executing, SCN 30-8

roles, SCN 30-20

procedures and, ADG 13 - 20

procedures contrasted with, SCN 20-2

prohibited in views, SCN 10-12

publish/subscribe support, SCN 20-18

recompiling, ADG 13 - 28

re-creating, SQL 7-403

REFERENCING option, ADG 13 - 17

referential integrity and, ADG 13 - 41, ADG 13 - 43, ADG 13 - 44, ADG 13 - 45

remote dependencies and, ADG 13 - 20

remote exceptions, ADG 13 - 18

removing from the database, SQL 7-479

replicating, REP 8-36

resource manager events, ADG 14 - 4

restrictions, ADG 13 - 13, ADG 13 - 20, SCN 20-7, SCN 26-46

direct-load INSERT, SCN 25-12

parallel DML, SCN 26-44

restrictions on, SQL 7-407

row, ADG 13 - 12, SCN 20-8

row evaluation order, ADG 13 - 21

row values

old and new, SQL 7-406

row, specifying, SQL 7-406

scan order, ADG 13 - 21

schema object dependencies, SCN 20-21, SCN 20-25

sequence for firing multiple, SCN 20-21

shared SQL areas and, SCN 7-10

SQL examples, SQL 7-407

statement, SCN 20-8, SQL 7-406

storage of, SCN 20-25

stored, ADG 13 - 27

system triggers, ADG 13 - 4

on DATABASE, ADG 13 - 4

on SCHEMA, ADG 13 - 4

trigger evaluation order, ADG 13 - 21

types of, SCN 20-8

UNKNOWN does not fire, SCN 20-7

update triggers

SQL*Loader, SUT 8-23

use of LONG, LONG RAW, and LOB datatypes, ADG 13 - 20

user-defined types, SCN 14-6

username reported in, ADG 13 - 25

uses of, SCN 20-3

WHEN clause, ADG 13 - 13

with CALL to a procedure as trigger body, GTK 2-39

with LOBs, DCI 6-12

TRIM collection method, PLS 4-25

TRIM function, GTK 2-44, SQL 4-49

trimming

summary, SUT 5-87

VARCHAR fields, SUT 5-83

trimming trailing whitespace

SQL*Loader, SUT 5-86

Troubleshooting, NET 11-1

troubleshooting, NET 11-1 to NET 11-58, PSC C-1 to PSC C-14, REP 7-29

auto-discovery, PSC C-3

client, NET 11-4

common startup and connection problems, NET 8-11

contacting Oracle Customer Support, NET 11-58

distributed transactions, DDS 3-19

error message ORA-12203, NET 8-12

error message TNS-01169, NET 8-14

log files, NET 11-15

loopback test, NET 11-4

migration, MIG A-1

ALTER DATABASE CONVERT command, MIG A-16

AUDIT_TRAIL initialization parameter, MIG A-3

database name mismatch, MIG A-19

datafile version integrity, MIG A-20

Migration utility error messages, MIG A-5

missing convert file, MIG A-17

MULTIPLIER option, MIG A-4

NOMOUNT database start mode, MIG A-17

OPTIMAL setting, MIG A-4

Oracle7 control file, MIG A-16

password file, MIG A-18

running the Migration utility, MIG A-2

running the Oracle Data Migration Assistant, MIG A-2

SYSTEM tablespace, MIG A-2

temporary tablespace tablespace, MIG A-2

Oracle Database Configuration Assistant, PSC 4-4, PSC 4-6

questions, NET 11-14

server, NET 11-3

trace files, NET 11-15, PSC C-11

using log file, NET 11-25

troubleshooting the media manager, SBR 5-21

TRUE keyword

behavior in Oracle7 and Oracle8i, MIG 8-22

TRUE value, PLS 2-8

TRUNC

date function, SQL 4-51

number function, SQL 4-50

TRUNC function, ADG 4 - 9

format models, SQL 4-55

TRUNCATE command, REP 7-25, SAD 20-9, SCN 16-4

DROP STORAGE option, SAD 20-11

REUSE STORAGE option, SAD 20-11

TRUNCATE PARTITION clause

ALTER TABLE command, SAD 13-15

of ALTER TABLE, SQL 7-150

TRUNCATE statement, SQL 7-581

TRUNCATE SUBPARTITION clause

of ALTER TABLE, SQL 7-150

TRUNCATE TABLE command, ADG 3 - 10

PRESERVE SNAPSHOT LOG option, REP 7-26

PURGE SNAPSHOT LOG option, REP 7-26

truncated values, PCO 6-14

detecting, PC_ 6-4, PC_ 7-14, PCO 4-26, PCO 5-4

indicator variables, PCO 6-2

truncating

clusters, SAD 20-9

partitioned objects, SAD 13-15

privileges for, SAD 20-10

tables, SAD 20-9

truncation error

when generated, PC_ 6-6

truncation errors

when generated, PCO 5-6

TRUST keyword, ADG 10 - 68

TRUST parameter

of PRAGMA RESTRICT_REFERENCES, SQL 7-175

TRUSTED mode, STU 31-19

Trusted ORACLE

ALL_LABELS view, SRF 2-23

data dictionary, SRF 2-1

Trusted Oracle, PLS 2-10, SQL 1-5

Export/Import, MIG 5-3

Trusted Oracle Server

converting labels, ADG 4 - 28

MLSLABEL datatype, ADG 4 - 23

TRUSTED_SERVER

data dictionary view, DDS D-1

TRUSTED_SERVERS view, SRF 2-185

trustpoints

adding, OAS 9-39

definition, OAS 9-39, OAS Glossary-7

TS, SMS 51-1

TS_PITR_CHECK view, SBR A-6, SRF 2-186

TS_PITR_OBJECTS TO_BE_DROPPED view, SRF 2-187

TSPITR. See tablespace point-in-time recovery.

Tasteless package, SPR 1 - 19

TTC presentation layer, NET 2-11, NET 9-7, NET C-55

TTS_OWNERS parameter, SUT 2-31

tuning, SPS 19-2

access path, STU 2-10

after migration, MIG 6-6

analyze tables, DDS 4-6

and design, STU 2-10

application design, STU 2-9

archiving, SAD 7-20

business rule, STU 2-7

checkpoints, STU 20-38

client/server applications, STU 3-9

contention, STU 21-1

cost based optimization, DDS 4-5

CPU, STU 18-1

data design, STU 2-7

data sources, STU 12-1

database logical structure, STU 2-9

databases, SAD 1-20

decision support systems, STU 3-3

diagnosing problems, STU 17-1

distributed databases, STU 3-7

distributed queries, DDS 4-4

expectations, STU 1-9

factors, STU 17-1

goals, STU 1-9, STU 2-12

initially, SAD 2-14

I/O, STU 2-11, STU 20-2

large pool for MTS, STU 19-21

library cache, STU 19-13

logical structure, STU 6-3

memory allocation, STU 2-10, STU 19-2, STU 19-41

method, STU 2-1

monitoring registered applications, STU 5-1, STU 12-7

multi-threaded server, STU 21-5

OLTP applications, STU 3-1

operating system, STU 2-12, STU 17-6, STU 19-4

parallel execution, STU 3-4, STU 26-36

parallel server, STU 3-8

personnel, STU 1-7

proactive, STU 2-1

production systems, STU 2-4

query servers, STU 21-14

reactive, STU 2-3

shared pool, STU 19-10, STU 19-21

shared pool for MTS, STU 19-21

sorts, STU 20-34

SQL, STU 2-10

SQL and PL/SQL areas, STU 19-7

System Global Area (SGA), STU 19-5

using LONGs, ADG 4 - 17

tuning, performance, PC_ C-2, PCO D-2

Turn Off UNIX Signal Handling option, NET 7-24

Tuxedo applications

compatibility with Oracle8i XA libraries, MIG 8-17

TWO_TASK environment variable, MIG 3-16

two-phase commit, STU 26-25

commit phase, DDS 3-4, DDS 3-15

described, DDS 1-13, SCN 1-35, SCN 33-13

example of, DDS 3-11

manual override of, SCN 1-36

parallel DML, SCN 26-40

prepare phase, DDS 3-3

recognizing read-only nodes, DDS 3-17

transaction management, SCN 17-7

triggers, SCN 20-21

two-phase commits, SPS 1-19

two-task

linking, PC_ 2-18

Two-Task Common (TTC) presentation layer, NET C-55

described, NET 2-11, NET 9-7

TTC presentation layer, NET C-51

two-task mode, SCN 8-3

listener process and, SCN 8-14

network communication and, SCN 8-23

program interface in, SCN 8-23

two-tier, STU 18-11

TX, Transaction, SPS 10-3

%TYPE attribute, PLS 2-31

syntax, PLS 11-157

type attributes

attributes, OCI 6-10

type checking at runtime, PC_ 17-22

type constructor expressions, SQL 5-6

type definition

type descriptor object, OCI 11-23

TYPE directive

examples, PC_ F-112

type DTYCHR, MIG 11-8

type evolution, ADG 18 - 40, PLS 9-7

type functions

attributes, OCI 6-11

Type of Service, NET 7-8

Type of Service option, NET 7-71

TYPE parameter, NET C-44, PSC 4-44

type procedures

attributes, OCI 6-11

type reference, OCI 10-33

TYPE SQL directive, PC_ F-111

TYPE statements

using the CHARF datatype specifier, PCO 4-51

TYPE# column

SYS.INCEXP table, SUT 1-51

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 7-8, NET 7-71, NET C-42

typecodes, OCI 3-23

types

attributes, OCI 6-9

describing, OCI 6-2

granting

system privileges on, SQL 7-501

incomplete

creating, SQL 7-411

mutually referencing

downgrading, MIG 12-24

nested table

creating, SQL 7-413

object

creating, SQL 7-411

privileges on, SCN 30-11

See datatypes, object types

varray

creating, SQL 7-413

TYPES clause

of ASSOCIATE STATISTICS, SQL 7-194, SQL 7-196

types. See object types or datatypes.

Typical, NET 4-23, NET C-55

Typical install type, NET 4-21

Typical installation, PSC 3-5

Typical installation type, PSC 3-2, PSC 4-2