You can partition an index-organized table by RANGE, HASH, or LIST on column
values. The partitioning columns must form a subset of the primary key columns. Just
like ordinary tables, local partitioned (prefixed and non-prefixed) index as well as
global partitioned (prefixed) indexes are supported for partitioned index-organized
tables.
分区索引组织表
1. 用户可以采用 RANGE，HASH，或 LIST 的方式对索引表进行分区
2. 分区列必须是属于主键列
3. 可在分区索引表上建立本地全局索引
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-983122/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Mapping Table (233)
请登录后发表评论
登录
全部评论
-
博文量740
-
访问量2002887
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
