OATM Tablespace |
Tablespace Name |
OATM Tablespace Content |
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:
materialized views, fact tables, and other summary objects.
|
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
|
Tables that contain archived
purge-related data.
|
Undo
|
APPS_UNDOTS1
|
Automatic Undo Management (AUM)
tablespace. UNDO segments are identical to ROLLBACK.
|
Temp
|
TEMP
|
Temporary tablespace for global
temporary table, sorts, and hash joins.
|
System
|
SYSTEM
|
System tablespace used by the Oracle
Database
|
Permanent Personalizations in R12
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment