首页 > Linux操作系统 > Linux操作系统 > EBS表空间


原创 Linux操作系统 作者:lyf10086 时间:2011-07-12 12:49:49 0 删除 编辑

Oracle Applications Tablespace Model - OATM(表空间,表領域)

APPS_TS_INTERFACE - All the interface tables are kept in this tablespace for example the GL_INTERFACE table.
APPS_TS_SUMMARY - All objects that record summary information are grouped under this tablespace.
APPS_TS_NOLOGGING - This tablespace contains the materialized views that are not used for summary purposes and other temporary object that do not require redo log entries.
APPS_TS_QUEUES - With the support for advanced queuing in Oracle Applications, the advanced queue tables and related objects form. a part of this tablespace.
APPS_TS_MEDIA - This tablespace holds multimedia objects like graphics sound recordings and spital data.
APPS_TS_ARCHIVE - Tables that are obsolete in the current release of Oracle Applications 11i are stored here. These tables are  preserved to maintain backward compatibility of custom programs or migration scripts.
UNDO - The undo tablespace is used as automatic undo management is enabled by default in 11.5.10.This acts as a replacement to red log files.
TEMP - The Temp tablespace is the default temporary tablespace for Oracle Applications.
SYSTEM - This is the SYSTEM tablespace used by the Oracle Database

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: SQL PDF
下一篇: 没有了~
请登录后发表评论 登录


  • 博文量
  • 访问量