Wednesday, 15 March 2017

oracle application table spaces




Tablespace Type
Tablespace Name
Contents
Transaction Tables
APPS_TS_TX_DATA
Tables that contain transactional data.
Transaction Indexes
APPS_TS_TX_IDX
Indexes on transaction tables.
Reference
APPS_TS_SEED
Reference and setup data and indexes.
Interface
APPS_TS_INTERFACE
Interface and temporary data and indexes.
Summary
APPS_TS_SUMMARY
Summary management objects, such as materialized views, and other objects that record summary information.
Nologging
APPS_TS_NOLOGGING
Materialized views not used for summary management and temporary objects.
Advanced Queuing/AQ
APPS_TS_QUEUES
Advanced Queuing and dependent tables and indexes.
Media
APPS_TS_MEDIA
Multimedia objects, such as text, video, sound, graphics, and spatial data.
Archive
APPS_TS_ARCHIVE
Archive-purge-related objects.
Undo
UNDO
Automatic Undo Management (AUM) tablespace. UNDO segments are identical to ROLLBACK segments when AUM is enabled.
Temp
TEMP
Temporary tablespace for global temporary table, sorts, and hash joins.
System
SYSTEM
System tablespace used by the Oracle Database.


No comments:

Post a Comment