Oracle9i Database Master Index: T
(Release 2 (9.2))
Shortcuts to Letters
Index Entries
- T variable in SQLDA
- how value is set
(Pro*C/C++ Precompiler Programmer's Guide)
- purpose of
(Pro*C/C++ Precompiler Programmer's Guide)
- tab (escape sequence)
(OLAP Developer's Guide to the OLAP DML)
- TAB clause
(SQL*Plus User's Guide and Reference)
- [entry #2] (SQL*Plus User's Guide and Reference)
- TAB variable
(SQL*Plus User's Guide and Reference)
- TAB view
(Reference)
- Table
(Pro*C/C++ Precompiler Programmer's Guide)
- table
- XMLType, querying
(SQL Reference)
- table
- as schema object
(Database Tuning with the Oracle Tuning Pack)
- obtaining cardinality values
(Database Tuning with the Oracle Tuning Pack)
- reason for being invalid
(Database Tuning with the Oracle Tuning Pack)
- used in application tuning
(Database Tuning with the Oracle Tuning Pack)
- table (host) elements
- maximum
(Pro*COBOL Precompiler Programmer's Guide)
- table aliases
(Application Developer's Guide - Object-Relational Features)
- table bean
(OLAP User's Guide)
- table charts
(Getting Started with Oracle Management Pack for Oracle Applications)
- [entry #2] (Getting Started with the Oracle Diagnostics Pack)
- [entry #3] (Getting Started with the Oracle Standard Management Pack)
- sorting data in
(Getting Started with Oracle Management Pack for Oracle Applications)
- [subentry #2] (Getting Started with the Oracle Diagnostics Pack)
- [subentry #3] (Getting Started with the Oracle Standard Management Pack)
- TABLE clause
- [entry #2] (SQL*Plus User's Guide and Reference)
- of ANALYZE
(SQL Reference)
- of DELETE
(SQL Reference)
- of INSERT
(SQL Reference)
- of SELECT
(SQL Reference)
- of TRUNCATE
(SQL Reference)
- of UPDATE
(SQL Reference)
- [subentry #2] (SQL Reference)
- [subentry #3] (SQL Reference)
- TABLE datatype
(PL/SQL User's Guide and Reference)
- table details
- allocated blocks
(Database Tuning with the Oracle Tuning Pack)
- average free space per block
(Database Tuning with the Oracle Tuning Pack)
- average row length
(Database Tuning with the Oracle Tuning Pack)
- chained rows
- migrated rows (Database Tuning with the Oracle Tuning Pack)
- displaying
(Database Tuning with the Oracle Tuning Pack)
- extents
(Database Tuning with the Oracle Tuning Pack)
- rows
(Database Tuning with the Oracle Tuning Pack)
- used blocks
(Database Tuning with the Oracle Tuning Pack)
- TABLE expressions
(Application Developer's Guide - Object-Relational Features)
- [entry #2] (Application Developer's Guide - Object-Relational Features)
- TABLE FETCH BY ROWID in V$SYSSTAT
(SNMP Support Reference Guide)
- TABLE FETCH CONTINUED ROW in V$SYSSTAT
(SNMP Support Reference Guide)
- table functions
(Concepts)
- [entry #2] (Data Cartridge Developer's Guide)
- [entry #3] (Data Cartridge Developer's Guide)
- [entry #4] (PL/SQL User's Guide and Reference)
- creating
(SQL Reference)
- defined
(OLAP User's Guide)
- [subentry #2] (OLAP User's Guide)
- doing transformations with
(PL/SQL User's Guide and Reference)
- parallel execution
(Concepts)
- [subentry #2] (PL/SQL User's Guide and Reference)
- parallel execution of
(Data Cartridge Developer's Guide)
- [subentry #2] (Data Cartridge Developer's Guide)
- [subentry #3] (Data Cartridge Developer's Guide)
- partitioning input
(Data Cartridge Developer's Guide)
- pipelined
(Concepts)
- [subentry #2] (Data Cartridge Developer's Guide)
- [subentry #3] (Data Cartridge Developer's Guide)
- [subentry #4] (Data Cartridge Developer's Guide)
- [subentry #5] (PL/SQL User's Guide and Reference)
- querying
(Data Cartridge Developer's Guide)
- [subentry #2] (PL/SQL User's Guide and Reference)
- REF CURSOR arguments to
(Data Cartridge Developer's Guide)
- table lock
- acquiring with LOCK TABLE
(Pro*COBOL Precompiler Programmer's Guide)
- row share
(Pro*COBOL Precompiler Programmer's Guide)
- when released
(Pro*COBOL Precompiler Programmer's Guide)
- table locks
- acquiring with LOCK TABLE
(Pro*C/C++ Precompiler Programmer's Guide)
- and queries
(SQL Reference)
- disabling
(SQL Reference)
- duration of
(SQL Reference)
- effect of
(Pro*C/C++ Precompiler Programmer's Guide)
- enabling
(SQL Reference)
- EXCLUSIVE
(SQL Reference)
- [subentry #2] (SQL Reference)
- modes of
(SQL Reference)
- on partitions
(SQL Reference)
- on remote database
(SQL Reference)
- on subpartitions
(SQL Reference)
- ROW EXCLUSIVE
(SQL Reference)
- [subentry #2] (SQL Reference)
- ROW SHARE
(SQL Reference)
- [subentry #2] (SQL Reference)
- row share
(Pro*C/C++ Precompiler Programmer's Guide)
- SHARE
(SQL Reference)
- SHARE ROW EXCLUSIVE
(SQL Reference)
- SHARE UPDATE
(SQL Reference)
- when released
(Pro*C/C++ Precompiler Programmer's Guide)
- table management
(Application Developer's Guide - Workspace Manager)
- table mode export
(Utilities)
- table name
- restrictions on spatial table names
(Spatial User's Guide and Reference)
- table names
- preserving case sensitivity
(Utilities)
- TABLE operator
(PL/SQL User's Guide and Reference)
- TABLE option
(SQL*Plus User's Guide and Reference)
- table parameter
- Character Set Scanner
(Globalization Support Guide)
- table partition segments
- compression of
(SQL Reference)
- [subentry #2] (SQL Reference)
- table partitions
- using interMedia column objects containing BLOBs
(interMedia User's Guide and Reference)
- Table Properties
(Database Tuning with the Oracle Tuning Pack)
- table queues
(Data Warehousing Guide)
- table REF constraints
(SQL Reference)
- of CREATE TABLE
(SQL Reference)
- table rows
- identifying in logical standby databases
(Data Guard Concepts and Administration)
- TABLE SCAN BLOCKS GOTTEN in V$SYSSTAT
(SNMP Support Reference Guide)
- TABLE SCAN ROWS GOTTEN in V$SYSSTAT
(SNMP Support Reference Guide)
- TABLE SCANS LONG TABLES in V$SYSSTAT
(SNMP Support Reference Guide)
- TABLE SCANS SHORT TABLES in V$SYSSTAT
(SNMP Support Reference Guide)
- table segments
- data compression of
(SQL Reference)
- [subentry #2] (SQL Reference)
- table structure
- explain
(Text Reference)
- filter
(Text Reference)
- Gist
(Text Reference)
- hfeedback
(Text Reference)
- highlight
(Text Reference)
- markup
(Text Reference)
- theme
(Text Reference)
- table synonyms
(Application Developer's Guide - Workspace Manager)
- TABLE syntax (nested tables)
(SQLJ Developer's Guide and Reference)
- TABLE syntax (nested tables), 6-62
(SQLJ Developer's Guide and Reference)
- TABLE type (PL/SQL)
(SQLJ Developer's Guide and Reference)
- TABLE types--see indexed-by tables
(JPublisher User's Guide)
- table view
- navigating Cursor for, example
(OLAP Developer's Guide to the OLAP API)
- table- or view-based security
(Application Developer's Guide - Fundamentals)
- table-level Export
(Utilities)
- table-level Import
(Utilities)
- table-mode Export
- specifying
(Utilities)
- table-mode Import
- examples
(Utilities)
- tableProps attribute
(XML Database Developer's Guide - Oracle XML DB)
- tables
- access to sample
(SQL*Plus User's Guide and Reference)
- adding columns
(Administrator's Guide)
- adding rows to
(SQL Reference)
- Advanced Queuing
- exporting (Utilities)
- importing (Utilities)
- affect dependent views
(Concepts)
- affinity and advanced queuing
(Real Application Clusters Deployment and Performance)
- aliases
(SQL Reference)
- in CREATE INDEX (SQL Reference)
- in DELETE (SQL Reference)
- allocating extents
(Administrator's Guide)
- [subentry #2] (Real Application Clusters Administration)
- allocating extents for
(SQL Reference)
- altering
(Administrator's Guide)
- without replicating changes (Replication Management API Reference)
- altering physical attributes
(Administrator's Guide)
- altering replicated
(Replication Management API Reference)
- analyzing
(Administrator's Guide)
- [subentry #2] (Administrator's Guide)
- appending rows with SQL*Loader
(Utilities)
- assigning to a cluster
(SQL Reference)
- attributes
(Oracle Call Interface Programmer's Guide)
- auditing
(Concepts)
- base
- relationship to views (Concepts)
- changing degree of parallelism on
(SQL Reference)
- changing existing values in
(SQL Reference)
- cluster
(Real Application Clusters Deployment and Performance)
- clustered
(Concepts)
- clustered (hash). See hash clusters
(Administrator's Guide)
- clustered (index).
(Administrator's Guide)
- clustered, definition
(Concepts)
- collecting statistics on
(SQL Reference)
- [subentry #2] (SQL Reference)
- comments on
(SQL Reference)
- comparing
(Replication Management API Reference)
- [subentry #2] (Supplied PL/SQL Packages and Types Reference)
- constraining
(Application Developer's Guide - Fundamentals)
- contained in tablespaces
(Concepts)
- controlling destination when copying
(SQL*Plus User's Guide and Reference)
- [subentry #2] (SQL*Plus User's Guide and Reference)
- controlling space allocation for
(Concepts)
- copying values between
(SQL*Plus User's Guide and Reference)
- [subentry #2] (SQL*Plus User's Guide and Reference)
- [subentry #3] (SQL*Plus User's Guide and Reference)
- creating
(Administrator's Guide)
- [subentry #2] (Application Developer's Guide - Fundamentals)
- [subentry #3] (Performance Tuning Guide and Reference)
- [subentry #4] (SQL Reference)
- multiple (SQL Reference)
- creating comments about
(SQL Reference)
- creating in locally managed tablespaces
(Administrator's Guide)
- data block space, specifying
(Administrator's Guide)
- data dictionary
(Reference)
- data stored outside database
(SQL Reference)
- deallocating unused space from
(SQL Reference)
- default physical attributes
- changing (SQL Reference)
- defining before Import
(Utilities)
- definitions
- creating before Import (Utilities)
- degree of parallelism
- specifying (SQL Reference)
- describing
(Oracle Call Interface Programmer's Guide)
- design
(Performance Planning)
- designing
(Application Developer's Guide - Fundamentals)
- designing before creating
(Administrator's Guide)
- detail tables
(Data Warehousing Guide)
- differences between
(Replication Management API Reference)
- dimension tables (lookup tables)
(Data Warehousing Guide)
- dimensions
- star queries (Data Warehousing Guide)
- star queries (Performance Tuning Guide and Reference)
- directories
(Concepts)
- disassociating statistics types from
(SQL Reference)
- DML locks
(Reference)
- dropping
(Administrator's Guide)
- along with cluster (SQL Reference)
- along with owner (SQL Reference)
- indexes of (SQL Reference)
- partitions of (SQL Reference)
- dropping columns
(Administrator's Guide)
- [subentry #2] (Administrator's Guide)
- DUAL
(Concepts)
- dynamic partitioning
(Concepts)
- elements
(Pro*COBOL Precompiler Programmer's Guide)
- enable or disable constraints
(Concepts)
- enabling parallelism for
(Data Warehousing Guide)
- estimating size
(Administrator's Guide)
- exclusive access during direct path loads
- SQL*Loader (Utilities)
- external
(Administrator's Guide)
- [subentry #2] (Administrator's Guide)
- [subentry #3] (Concepts)
- [subentry #4] (Data Warehousing Guide)
- [subentry #5] (SQL Reference)
- [subentry #6] (Utilities)
- creating (SQL Reference)
- restrictions on (SQL Reference)
- externally organized
(SQL Reference)
- fact tables
(Data Warehousing Guide)
- star queries (Data Warehousing Guide)
- star queries (Performance Tuning Guide and Reference)
- formatter in Oracle Trace
(Performance Tuning Guide and Reference)
- free space unavailable
(Real Application Clusters Deployment and Performance)
- full scans
(Performance Tuning Guide and Reference)
- full table scan and buffer cache
(Concepts)
- granting
- system privileges on (SQL Reference)
- guidelines
(Application Developer's Guide - Fundamentals)
- [subentry #2] (Application Developer's Guide - Fundamentals)
- guidelines for managing
(Administrator's Guide)
- hash clustered.
(Administrator's Guide)
- heap organized
(SQL Reference)
- historical
- [subentry #2] (Data Warehousing Guide)
- moving time windows (Administrator's Guide)
- how data is stored in
(Concepts)
- importing
(Utilities)
- in PL/SQL
(Application Developer's Guide - Fundamentals)
- increasing column length
(Administrator's Guide)
- index-organized
(Administrator's Guide)
- [subentry #2] (Administrator's Guide)
- [subentry #3] (Application Developer's Guide - Fundamentals)
- [subentry #4] (Application Developer's Guide - Fundamentals)
- [subentry #5] (SQL Reference)
- key compression in (Concepts)
- key compression in (Concepts)
- overflow segment for (SQL Reference)
- partitioning (Administrator's Guide)
- partitioning (Administrator's Guide)
- space in index block (SQL Reference)
- space in index block (SQL Reference)
- index-organized tables
(Concepts)
- logical rowids (Concepts)
- logical rowids (Concepts)
- indexes and
(Concepts)
- initial storage
(Real Application Clusters Deployment and Performance)
- insert triggers
- direct path load in SQL*Loader (Utilities)
- inserting rows into
(Pro*C/C++ Precompiler Programmer's Guide)
- [subentry #2] (Pro*COBOL Precompiler Programmer's Guide)
- inserting rows using SQL*Loader
(Utilities)
- inserting rows with a subquery
(SQL Reference)
- inserting using the direct-path method
(SQL Reference)
- integrity constraints
(Concepts)
- [subentry #2] (Concepts)
- joining in a query
(SQL Reference)
- key-preserved
(Administrator's Guide)
- [subentry #2] (Application Developer's Guide - Fundamentals)
- length semantics
(Advanced Replication)
- limiting indexes on
(Administrator's Guide)
- listing column definitions
(SQL*Plus User's Guide and Reference)
- [subentry #2] (SQL*Plus User's Guide and Reference)
- loading data into more than one table using SQL*Loader
(Utilities)
- loading object tables
(Utilities)
- LOB storage of
(SQL Reference)
- locating free space
(Reference)
- locking
(SQL Reference)
- locks on
(Concepts)
- [subentry #2] (Concepts)
- [subentry #3] (Concepts)
- logging
- insert operations (SQL Reference)
- table creation (SQL Reference)
- logical standby databases
- adding on (Data Guard Concepts and Administration)
- maintaining data in (Data Guard Concepts and Administration)
- not supported by (Data Guard Concepts and Administration)
- re-creating on (Data Guard Concepts and Administration)
- recovering on (Data Guard Concepts and Administration)
- skipping on (Data Guard Concepts and Administration)
- skipping transactions on (Data Guard Concepts and Administration)
- unsupported on (Data Guard Concepts and Administration)
- lookup tables
(Performance Tuning Guide and Reference)
- lookup tables (dimension tables)
(Data Warehousing Guide)
- maintaining consistency during Export
(Utilities)
- managing
(Administrator's Guide)
- [subentry #2] (Administrator's Guide)
- manually ordering for Import
(Utilities)
- master table
- Import (Utilities)
- maximum number of columns in
(Concepts)
- migrated and chained rows in
(SQL Reference)
- modifying column definition
(Administrator's Guide)
- moving
(Administrator's Guide)
- [subentry #2] (SQL Reference)
- moving to a new segment
(SQL Reference)
- moving, index-organized
(SQL Reference)
- multiple files
(Real Application Clusters Deployment and Performance)
- mutating
(Application Developer's Guide - Fundamentals)
- name restrictions
- Export (Utilities)
- Import (Utilities)
- Import (Utilities)
- nested
(Pro*C/C++ Precompiler Programmer's Guide)
- creating (SQL Reference)
- exporting (Utilities)
- importing (Utilities)
- storage characteristics (SQL Reference)
- nested tables
(Application Developer's Guide - Object-Relational Features)
- [subentry #2] (Concepts)
- [subentry #3] (Concepts)
- indexes (Application Developer's Guide - Object-Relational Features)
- normalized or denormalized
(Concepts)
- object
- creating (SQL Reference)
- See object tables (Application Developer's Guide - Object-Relational Features)
- object tables
(Application Developer's Guide - Object-Relational Features)
- [subentry #2] (Concepts)
- [subentry #3] (Concepts)
- constraints (Application Developer's Guide - Object-Relational Features)
- indexes (Application Developer's Guide - Object-Relational Features)
- triggers (Application Developer's Guide - Object-Relational Features)
- virtual (Application Developer's Guide - Object-Relational Features)
- virtual (Concepts)
- object, querying
(SQL Reference)
- objects
- order of import (Utilities)
- of XMLType, creating
(SQL Reference)
- organization, defining
(SQL Reference)
- overview of
(Concepts)
- parallel creation
(Data Warehousing Guide)
- parallel creation of
(SQL Reference)
- parallel DDL storage
(Data Warehousing Guide)
- parallelism
- setting default degree (SQL Reference)
- parallelizing creation
(Administrator's Guide)
- [subentry #2] (Administrator's Guide)
- partition attributes of
(SQL Reference)
- partitioned
(Administrator's Guide)
- [subentry #2] (Administrator's Guide)
- [subentry #3] (Globalization Support Guide)
- [subentry #4] (Utilities)
- see also partitioned tables (Administrator's Guide)
- partitioned in DB2
- no Oracle equivalent (Utilities)
- partitioning
(SQL Reference)
- [subentry #2] (SQL Reference)
- [subentry #3] (SQL Reference)
- allowing rows to move between partitions (SQL Reference)
- default attributes of (SQL Reference)
- partitions
(Concepts)
- physical attributes
- changing (SQL Reference)
- placement on disk
(Performance Tuning Guide and Reference)
- planning large tables
(Administrator's Guide)
- precreated
- length semantics (Advanced Replication)
- presented in views
(Concepts)
- privileges for creation
(Administrator's Guide)
- privileges on
(Concepts)
- [subentry #2] (Security Overview)
- privileges to alter
(Administrator's Guide)
- problems generating replication support for
(Advanced Replication)
- qualifying column names
(Application Developer's Guide - Object-Relational Features)
- [subentry #2] (Application Developer's Guide - Object-Relational Features)