Permanent Personalizations in R12

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

No comments:

Post a Comment