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.
|
Wednesday, 15 March 2017
oracle application table spaces
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment