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)

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

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