Oracle9i Database Master Index: T
(includes Windows entries)
Shortcuts to Letters
Index Entries
- T variable in SQLDA
- how value is set
(Pro*C/C++ Guide)
- purpose of
(Pro*C/C++ Guide)
- tab (escape sequence)
(OLAP DML Guide)
- TAB clause
(SQL*Plus Guide)
- [entry #2] (SQL*Plus Guide)
- TAB clause, 1
(iSQL*Plus User’s Guide)
- TAB variable
(SQL*Plus Guide)
- TAB view
(Reference)
- table
- affinity and advanced queuing
(Real Application Clusters Deployment and Performance)
- as schema object
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- obtaining cardinality values
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- reason for being invalid
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- used in application tuning
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- WAR deployment file attribute
(Servlet Engine Developer's Guide)
- table (host) elements
- maximum
(Pro*COBOL Guide)
- table access analysis
- case study example
(Real Application Clusters Deployment and Performance)
- table aliases
(AppDev - Object-Relational Features)
- table bean
(OLAP Services Concepts and Administration Guide)
- [entry #2] (OLAP Services Concepts and Administration Guide for Windows)
- table charts
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- [entry #2] (Oracle Enterprise Manager Getting Started with the Oracle Diagnostics Pack)
- [entry #3] (Oracle Enterprise Manager Getting Started with the Oracle Standard Management Pack)
- sorting data in
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- [subentry #2] (Oracle Enterprise Manager Getting Started with the Oracle Diagnostics Pack)
- [subentry #3] (Oracle Enterprise Manager Getting Started with the Oracle Standard Management Pack)
- TABLE clause
- [entry #2] (SQL*Plus Guide)
- 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 constraints
(SQL Reference)
- defined
(SQL Reference)
- of ALTER TABLE
(SQL Reference)
- of CREATE TABLE
(SQL Reference)
- TABLE datatype
(PL/SQL Guide)
- table details
- allocated blocks
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- average free space per block
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- average row length
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- chained rows
- migrated rows (Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- displaying
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- extents
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- rows
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- used blocks
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- TABLE expressions
(AppDev - Object-Relational Features)
- [entry #2] (AppDev - Object-Relational Features)
- TABLE FETCH BY ROWID in V$SYSSTAT
(SNMP Support Reference)
- TABLE FETCH CONTINUED ROW in V$SYSSTAT
(SNMP Support Reference)
- table functions
(Concepts)
- [entry #2] (PL/SQL Guide)
- [entry #3] (Data Cartridge Developer's Guide)
- [entry #4] (Data Cartridge Developer's Guide)
- creating
(SQL Reference)
- doing transformations with
(PL/SQL Guide)
- parallel execution
(Concepts)
- [subentry #2] (PL/SQL Guide)
- 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] (PL/SQL Guide)
- [subentry #3] (Data Cartridge Developer's Guide)
- [subentry #4] (Data Cartridge Developer's Guide)
- [subentry #5] (Data Cartridge Developer's Guide)
- querying
(PL/SQL Guide)
- [subentry #2] (Data Cartridge Developer's Guide)
- REF CURSOR arguments to
(Data Cartridge Developer's Guide)
- table lock
- acquiring with LOCK TABLE
(Pro*COBOL Guide)
- row share
(Pro*COBOL Guide)
- when released
(Pro*COBOL Guide)
- table locks
- [entry #2] (Real Application Clusters Concepts)
- acquiring with LOCK TABLE
(Pro*C/C++ Guide)
- and queries
(SQL Reference)
- disabling
(SQL Reference)
- duration of
(SQL Reference)
- effect of
(Pro*C/C++ 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++ Guide)
- SHARE
(SQL Reference)
- SHARE ROW EXCLUSIVE
(SQL Reference)
- SHARE UPDATE
(SQL Reference)
- when released
(Pro*C/C++ Guide)
- table management
(AppDev - Workspace Manager)
- table mode export
(Utilities)
- table names
- preserving case sensitivity
(Utilities)
- TABLE operator
(PL/SQL Guide)
- TABLE option
(SQL*Plus Guide)
- table parameter
- Character Set Scanner Utility
(Globalization Support Guide)
- table partitions
- using interMedia column objects containing BLOBs
(interMedia Guide)
- Table Properties
(Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)
- table queues
(Data Warehousing Guide)
- table REF constraints
(SQL Reference)
- [entry #2] (SQL Reference)
- of ALTER TABLE
(SQL Reference)
- of CREATE TABLE
(SQL Reference)
- TABLE SCAN BLOCKS GOTTEN in V$SYSSTAT
(SNMP Support Reference)
- TABLE SCAN ROWS GOTTEN in V$SYSSTAT
(SNMP Support Reference)
- TABLE SCANS LONG TABLES in V$SYSSTAT
(SNMP Support Reference)
- TABLE SCANS SHORT TABLES in V$SYSSTAT
(SNMP Support 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 syntax (nested tables)
(SQLJ Guide)
- TABLE syntax (nested tables), 6-60
(SQLJ Guide)
- TABLE type (PL/SQL)
(SQLJ Guide)
- table view
- navigating Cursor for, example
(OLAP API Guide)
- table- or view-based security
(AppDev - Fundamentals)
- table-level Export
(Utilities)
- table-level Import
(Utilities)
- table-mode Export
- specifying
(Utilities)
- table-mode Import
- examples
(Utilities)
- tables
- [entry #2] (SQL*Plus Guide)
- access to sample
(SQL*Plus Guide)
- adding rows to
(SQL Reference)
- Advanced Queuing
- exporting (Utilities)
- importing (Utilities)
- affect dependent views
(Concepts)
- aliases
(SQL Reference)
- in CREATE INDEX (SQL Reference)
- in DELETE (SQL Reference)
- allocating extents
(Admin Guide)
- [subentry #2] (Real Application Clusters Administration)
- [subentry #3] (Real Application Clusters Deployment and Performance)
- allocating extents for
(SQL Reference)
- altering
(Admin Guide)
- [subentry #2] (Admin Guide)
- without replicating changes (Replication Management API Reference)
- altering replicated
(Replication Management API Reference)
- analyzing
(Admin Guide)
- [subentry #2] (Admin Guide)
- appending rows with SQL*Loader
(Utilities)
- assigning to a cluster
(SQL Reference)
- attributes
(OCI Programmer's Guide)
- auditing
(Concepts)
- base
- data dictionary use of (Concepts)
- 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
(Admin Guide)
- clustered (index).
(Admin Guide)
- clustered, definition
(Concepts)
- collecting statistics on
(SQL Reference)
- [subentry #2] (SQL Reference)
- comparing
(Replication Management API Reference)
- [subentry #2] (Supplied PL/SQL Packages and Types Reference)
- constraining
(AppDev - Fundamentals)
- constraints on
(SQL Reference)
- contained in tablespaces
(Concepts)
- contention
(Real Application Clusters Administration)
- [subentry #2] (Real Application Clusters Deployment and Performance)
- continuing a multiple-table load
(Utilities)
- continuing a single-table load
(Utilities)
- controlling destination when copying
(SQL*Plus Guide)
- [subentry #2] (SQL*Plus Guide)
- controlling destination when copying, 1
(iSQL*Plus User’s Guide)
- controlling space allocation for
(Concepts)
- copying values between
(SQL*Plus Guide)
- [subentry #2] (SQL*Plus Guide)
- [subentry #3] (SQL*Plus Guide)
- copying values between, 1
(iSQL*Plus User’s Guide)
- creating
(Admin Guide)
- [subentry #2] (AppDev - Fundamentals)
- [subentry #3] (AppDev - Fundamentals)
- [subentry #4] (Performance Guide)
- [subentry #5] (SQL Reference)
- multiple (SQL Reference)
- creating comments about
(SQL Reference)
- 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)
- definition
(Concepts)
- definitions
- creating before Import (Utilities)
- degree of parallelism
- specifying (SQL Reference)
- describing
(OCI Programmer's Guide)
- design
(Performance Methods)
- designing
(AppDev - Fundamentals)
- designing before creating
(Admin Guide)
- detail tables
(Data Warehousing Guide)
- differences between
(Replication Management API Reference)
- dimension tables (lookup tables)
(Data Warehousing Guide)
- dimensions
- star queries (Performance Guide)
- star queries (Data Warehousing Guide)
- directories
(Concepts)
- disassociating statistics types from
(SQL Reference)
- DML locks
(Reference)
- dropping
(Admin Guide)
- along with cluster (SQL Reference)
- along with owner (SQL Reference)
- indexes of (SQL Reference)
- partitions of (SQL Reference)
- dropping columns
(Admin Guide)
- [subentry #2] (Admin Guide)
- DUAL
(Concepts)
- dynamic partitioning
(Concepts)
- elements
(Pro*COBOL Guide)
- enable or disable constraints
(Concepts)
- enabling parallelism for
(Data Warehousing Guide)
- estimating size
(Admin Guide)
- exclusive access during direct path loads
- SQL*Loader (Utilities)
- external
(Admin Guide)
- [subentry #2] (Admin Guide)
- [subentry #3] (Concepts)
- [subentry #4] (SQL Reference)
- [subentry #5] (Data Warehousing Guide)
- [subentry #6] (Utilities)
- creating (SQL Reference)
- restrictions on (SQL Reference)
- externally organized
(SQL Reference)
- fact tables
- [subentry #2] (Data Warehousing Guide)
- star queries (Performance Guide)
- star queries (Data Warehousing Guide)
- FND_APPLICATION_TL
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_CONCURRENT_PROCESSES
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_CONCURRENT_PROGRAMS
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_CONCURRENT_PROGRAMS_TL
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_CONCURRENT_QUEUES
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_CONCURRENT_QUEUES_TL
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_CONCURRENT_REQUESTS
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_CONC_PP_ACTIONS
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_CONC_RELEASE_CLASSES
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_CONC_RELEASE_CLASSES_TL
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_LOOKUP_VALUES
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_PRINTER_STYLES
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_PRINTER_STYLES_TL
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_PRODUCT_INSTALLATIONS
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- FND_USER
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- formatter in Oracle Trace
(Performance Guide)
- free list settings
(Performance Guide)
- free space unavailable
(Real Application Clusters Deployment and Performance)
- full scans
(Performance Guide)
- full table scan and buffer cache
(Concepts)
- GCS resource
(Real Application Clusters Deployment and Performance)
- granting
- system privileges on (SQL Reference)
- guidelines
(AppDev - Fundamentals)
- [subentry #2] (AppDev - Fundamentals)
- guidelines for managing
(Admin Guide)
- hash clustered.
(Admin Guide)
- heap organized
(SQL Reference)
- historical
- [subentry #2] (Data Warehousing Guide)
- moving time windows (Admin Guide)
- how data is stored in
(Concepts)
- importing
(Utilities)
- in PL/SQL
(AppDev - Fundamentals)
- increasing column length
(Admin Guide)
- index-organized
(Admin Guide)
- [subentry #2] (Admin Guide)
- [subentry #3] (AppDev - Fundamentals)
- [subentry #4] (AppDev - Fundamentals)
- [subentry #5] (SQL Reference)
- key compression in (Concepts)
- key compression in (Concepts)
- overflow segment for (SQL Reference)
- partitioning (Admin Guide)
- partitioning (Admin 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 Concepts)
- [subentry #2] (Real Application Clusters Deployment and Performance)
- insert triggers
- direct path load in SQL*Loader (Utilities)
- inserting rows into
(Pro*C/C++ Guide)
- [subentry #2] (Pro*COBOL 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
(Admin Guide)
- [subentry #2] (AppDev - Fundamentals)
- length semantics
(Replication)
- limiting indexes on
(Admin Guide)
- listing column definitions
(SQL*Plus Guide)
- [subentry #2] (SQL*Plus Guide)
- listing column definitions, 1
(iSQL*Plus User’s Guide)
- loading data into more than one table using SQL*Loader
(Utilities)
- loading object tables
(Utilities)
- LOB storage of
(SQL Reference)
- locating free space
(Reference)
- location of
(Admin Guide)
- lock
(Real Application Clusters Concepts)
- locking
(SQL Reference)
- locks
(Real Application Clusters Concepts)
- locks on
(Concepts)
- [subentry #2] (Concepts)
- [subentry #3] (Concepts)
- locks, disabling
(Real Application Clusters Deployment and Performance)
- logging
- insert operations (SQL Reference)
- table creation (SQL Reference)
- lookup tables
(Performance Guide)
- lookup tables (dimension tables)
(Data Warehousing Guide)
- maintaining consistency during Export
(Utilities)
- managing
(Admin Guide)
- [subentry #2] (Admin Guide)
- manually ordering for Import
(Utilities)
- master table
- Import (Utilities)
- maximum number of columns in
(Concepts)
- migrated and chained rows in
(SQL Reference)
- moving to a new segment
(SQL Reference)
- moving, index-organized
(SQL Reference)
- multiple files
(Real Application Clusters Deployment and Performance)
- mutating
(AppDev - Fundamentals)
- name restrictions
- Export (Utilities)
- Import (Utilities)
- Import (Utilities)
- nested
- [subentry #2] (Pro*C/C++ Guide)
- creating (SQL Reference)
- exporting (Utilities)
- importing (Utilities)
- storage characteristics (SQL Reference)
- nested tables
(Concepts)
- [subentry #2] (Concepts)
- [subentry #3] (AppDev - Object-Relational Features)
- indexes (AppDev - Object-Relational Features)
- normalized or denormalized
(Concepts)
- object
- creating (SQL Reference)
- See object tables (AppDev - Object-Relational Features)
- object tables
(Concepts)
- [subentry #2] (Concepts)
- [subentry #3] (AppDev - Object-Relational Features)
- constraints (AppDev - Object-Relational Features)
- indexes (AppDev - Object-Relational Features)
- triggers (AppDev - Object-Relational Features)
- virtual (Concepts)
- virtual (AppDev - Object-Relational Features)
- objects
- order of import (Utilities)
- Oracle Application Object Library tables
(Oracle Enterprise Manager Getting Started with Oracle Management Pack for Oracle Applications)
- organization, defining
(SQL Reference)
- overlapping
(Real Application Clusters Deployment and Performance)
- overview of
(Concepts)
- parallel creation
(Data Warehousing Guide)
- parallel creation of
(SQL Reference)
- parallel DDL storage
(Data Warehousing Guide)
- parallelism