Tuesday, May 15, 2018

How many tablespaces are introduced in OATM?

How many tablespaces are introduced in OATM?


OATM contains twelve consolidated tablespaces for all products, including temporary tablespace, system tablespace, and undo segments:


Tablespace Type
Tablespace Name
Contents
Transaction Tables
APPS_TS_TX_DATA
Tables that contain transaction data.
Transaction Indexes
APPS_TS_TX_IDX
Indexes on transaction tables.
Reference
APPS_TS_SEED
Reference and set-up 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.


No comments:

Post a Comment