Oracle8i Generic Documentation Master Index
Release 8.1.5

A68826-01

Library

Product

Contents

Index

Prev Top Next


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
in DELETE, SQL 7-441
TABLE clause
of DELETE, SQL 7-441
of INSERT, SQL 7-515
of SELECT, SQL 7-547
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
disabling, SPS 16-7
exclusive, PCO 3-29
minimizing, SPS 16-6
row share, 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
effect of, PC_ 3-25
enabling, SQL 7-154
EXCLUSIVE, SQL 7-521
modes of, SQL 7-521
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
altering, SAD 17-9
creating, SAD 17-6
dropping, SAD 17-10
managing, SAD 17-1
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
Export, SUT 1-25
Import, SUT 2-28
nested, PC_ 18-2
creating, SQL 7-418
exporting, SUT 1-57
importing, SUT 2-59
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
active rollback segments, SPS 6-8
backup, SPS 4-6, SPS 21-1
creating, SPS 15-6, SPS A-18
creating, example, STU 26-64
data files, SPS A-18
dedicated temporary, STU 26-70
dictionary-mapped, STU 20-28
dropping, SPS 15-6, SPS A-18
index data, SPS 15-5
offline, SPS 6-8
online rollback segments, SPS 14-5, SPS 14-7
parallel backup, SPS 21-12
parallel recovery, SPS 22-7
read-only, SPS 15-11
recovery, SPS 22-7, SPS A-22
rollback segment, SPS 6-8, SPS 14-5, SPS 14-7
SYSTEM, SPS 14-5
tables, SPS 6-8
taking offline, SPS 6-8, SPS A-18, SPS A-19
temporary, STU 20-36
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
advantages, SBR B-2
clone database, SBR B-4, SCN 5-7
different methods, SBR B-25
introduction, SBR B-2
limitations, SBR B-5
methods, SBR B-3
O/S, SBR B-3
performing, SBR B-1 to SBR B-26
planning for, SBR B-4
preparing, SBR B-6
procedures for using transportable tablespace feature, SBR B-25
requirements, SBR B-6
restrictions, SBR B-5
terminology, SBR B-4
transportable tablespace method, SBR B-3, SBR B-25
tuning considerations, SBR B-23
backup control files, SBR B-24
recovery set location, SBR B-23
using RMAN, SBR 4-51
introduction, SBR A-2
performing, SBR A-10
planning for, SBR A-4
preparing the auxiliary instance, SBR A-7
recovery sets containing whole tables, SBR A-6
restrictions, SBR A-4
tuning considerations, SBR A-13
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, SBR 3-19
frequency, SBR 3-19
offline, SBR 13-10
online, SBR 13-8
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
modifying, SQL 7-16
resizing, SQL 7-17
reusing, SQL 7-491
size of, SQL 7-491
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
aborted, SPS 6-8
autonomous, PLS 5-52
committed data, SPS 4-6, SPS 21-9
committing, PLS 5-42
concurrent, SPS 4-6, SPS 4-12, SPS 5-4
context, PLS 5-55
distributed, PLS 5-41
ending properly, PLS 5-45
free list, SPS 11-4
inserts, SPS 4-8, SPS 11-2
instance failure, SPS 22-3
isolation, SPS 4-15
lock, SPS 4-13, SPS 7-2, SPS 7-3, SPS 7-5, SPS 7-6, SPS 10-3
offline tablespace, SPS 6-9, SPS A-19
read-only, PLS 5-46
recovery, SPS A-12
rollback segments, SPS 6-9, SPS A-19
rolling back, PLS 5-43, SPS 6-8, SPS 22-3
row locking, SPS 4-6, SPS 4-15
sequence numbers, SPS 6-6
updates, SPS 4-6, SPS 11-2
waiting for recovery, SPS 22-3
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
collection, PLS 4-5
forward, PLS 9-29
RECORD, PLS 4-38
REF CURSOR, PLS 5-17
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



Prev

Top

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index