Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X

Index: T

TABLE_TO_COMMA procedure

10.1.1. Getting Started with DBMS_UTILITY

10.1.2.20. The DBMS_UTILITY.TABLE_TO_COMMA procedure

tables

analyzing : 13.4.1. Tracking Space in Tablespaces

AQ and : 5.1.1. General Features

displaying contents of (example) : 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL

memory use and : 11.1.4.2. The DBMS_SESSION.FREE_UNUSED_USER_MEMORY procedure

referenceability : 10.3.4. Setting Referenceability of Tables

reorganizing : 14.1.5. Reorganizing Tables

replacing (example) : 10.3.4.1. The DBMS_DDL. (Oracle8 only)

replicated tables

comparing : 15.5.2.1. The DBMS_RECTIFIER.DIFFERENCES procedure

dropping and replication triggers : 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure

instantiation versus rectifying : 15.5.2.2. The DBMS_RECTIFIER_DIFF.RECTIFY procedure

rectifying : 15.5.2.2. The DBMS_RECTIFIER_DIFF.RECTIFY procedure

space utilization : 12.1. DBMS_SPACE: Obtaining Space Information

tabpkg package

(see also specific program names)

6.2.7.1. Enhancing UTL_FILE.GET_LINE

tabref.sql : 10.3.4.1. The DBMS_DDL. (Oracle8 only)

TERMINATE procedure

10.4.1. Getting Started with DBMS_RANDOM

10.4.2.4. The DBMS_RANDOM.TERMINATE procedure (Oracle8 only)

territory (NLS), setting : 11.1.2.3. The DBMS_SESSION.SET_NLS procedure

testing : (see debugging; tracing; troubleshooting)

time, elapsed time : 10.1.2.14. The DBMS_UTILITY.GET_TIME function

timeouts

3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function

3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function

3.1.6.4. Paying attention to timeouts

toggling bits : 9.2.3.4. The UTL_RAW.BIT_XOR function

total_blocks function : 12.1.3.1. The segspace package

trace event levels : (see tracing, event levels)

trace package

(see also specific program names)

1.3.5.1. Examples of encapsulation packages

11.2.3. DBMS_SYSTEM Examples

trace.sql : 11.2.3. DBMS_SYSTEM Examples

tracing

(see also debugging; troubleshooting)

11.1.4.5. The DBMS_SESSION.SET_SQL_TRACE procedure

11.2. DBMS_System: Setting Events for Debugging

enabling/disabling in another session : 11.2.2.3. The DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure

enabling/disabling in same session : 11.1.4.5. The DBMS_SESSION.SET_SQL_TRACE procedure

encapsulating DBMS_SYSTEM : 11.2.3. DBMS_SYSTEM Examples

enhancement : 11.1.5.6. The set_sql_trace procedure

event levels

reading : 11.2.2.1. The DBMS_SYSTEM.READ_EV procedure

setting : 11.2.2.2. The DBMS_SYSTEM.SET_EV procedure

reasons for using : 7.3.8. Session Monitoring and Three-Tier Architectures

SQL statements with packaged functions : 1.3.7.2. Using a packaged procedure from within SQL

TRANSACTION procedure (DBMS_DEFER)

17.3.1.1. DBMS_DEFER programs

17.3.2.1. The DBMS_DEFER.TRANSACTION procedure

transaction statements, programmatic interface to : 4.2. DBMS_TRANSACTION: Interfacing to SQL Transaction Statements

transactions

(see also deferred transactions)

7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure

action names : (see action names)

alerts and

3.2.2.5. The DBMS_ALERT.SIGNAL procedure

3.2.3. DBMS_ALERT Examples

characteristics of : 4.2.5. Setting Transaction Characteristics

cleaning up : 4.2.6. Cleaning Up Transaction Details

commitment : 4.2.3. Committing Data

concentrating via DBMS_PIPE : 3.1.7.4. Implementing a server program

current transaction : 7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure

dequeuing and

5.1.3. Dequeue Features

5.3.8. Dequeue Options Record Type

discrete transactions : 4.2.5.3. The DBMS_TRANSACTION.BEGIN_DISCRETE_TRANSACTION procedure

enqueuing and

5.1.3. Dequeue Features

5.3.7. Enqueue Options Record Type

identifiers for : 4.2.7.1. The DBMS_TRANSACTION.LOCAL_TRANSACTION_ID function

in-doubt transactions : (see in-doubt transactions)

intersession communication and : 3.1. DBMS_PIPE: Communicating Between Sessions

LOBs and : 8.2.1.1. Internal and external LOBs

lock persistence and : 4.1.2.2. The DBMS_LOCK.REQUEST function

pipes and : 3.1.2.2. Nontransactional communications

read-only : 4.2.5.1. The DBMS_TRANSACTION.READ_ONLY procedure

read-write : 4.2.5.2. The DBMS_TRANSACTION.READ_WRITE procedure

recovery : 4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure

rollback : 4.2.4. Rolling Back Changes

short transactions : 4.2.5.3. The DBMS_TRANSACTION.BEGIN_DISCRETE_TRANSACTION procedure

step id : 4.2.7.2. The DBMS_TRANSACTION.STEP_ID function

transid.sql : 4.2.7.2. The DBMS_TRANSACTION.STEP_ID function

TRANSLATE function : 9.2.3.15. The UTL_RAW.TRANSLATE function

TRANSLITERATE function : 9.2.3.16. The UTL_RAW.TRANSLITERATE function

triggers

alert signaling and : 3.2. DBMS_ALERT: Broadcasting Alerts to Users

allocating locks and : 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure

named locks and : 4.1.3.4. ALLOCATE_UNIQUE drawbacks

National Language Support parameters and : 11.1.2.3. The DBMS_SESSION.SET_NLS procedure

replication triggers : (see replication triggers)

roles and : 11.1.2.4. The DBMS_SESSION.SET_ROLE procedure

TRIM procedure

8.1.1. DBMS_LOB Programs

8.3.3.4. The DBMS_LOB.TRIM procedure

troubleshooting

(see also debugging; tracing)

2.3.10.3. The DBMS_SQL.LAST_ROW_ID function

dynamic SQL : 2.4.6. Problem-Solving Dynamic SQL Errors

EXECUTE_AND_FETCH : 2.3.8. Retrieving Values

Trusted Oracle, job execution and : 13.2.2. Job Execution and the Job Execution Environment

two-phase commit : (see distributed databases; in-doubt transactions)

typing : (see datatypes)

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.