---
title: 系统表 __all_virtual_table_mgr 中 table_type 的含义-OceanBase数据库使用指南
description: 了解OceanBase数据库在实际应用中关于系统表 __all_virtual_table_mgr 中 table_type 的含义相关的常见问题和使用技巧，帮助您快速解决系统表 __all_virtual_table_mgr 中 table_type 的含义的难题。
---
切换语言

- 简体中文
- English

划线反馈

# 系统表 __all_virtual_table_mgr 中 table_type 的含义

更新时间：2026-05-21 01:56

适用版本： V3.1.x、V3.2.x、V4.0.x、V4.1.x、V4.2.x 内容类型：Troubleshoot  

在 `__all_virtual_table_mgr` 等系统表中，`table_type` 用整数数字表示，本文解释这些数字代表的含义。

## 适用版本

OceanBase 数据库 V3.x、V4.x 版本。

## V3.x 版本的 table_type

```shell
  enum TableType {
    MEMTABLE = 0,
    MAJOR_SSTABLE = 1,
    MINOR_SSTABLE = 2,  // obsoleted type after 2.2
    TRANS_SSTABLE = 3,  // new table type from 3.1
    MULTI_VERSION_MINOR_SSTABLE = 4,
    COMPLEMENT_MINOR_SSTABLE = 5,            // new table type from 3.1
    MULTI_VERSION_SPARSE_MINOR_SSTABLE = 6,  // reserved table type
    MINI_MINOR_SSTABLE = 7,
    RESERVED_MINOR_SSTABLE = 8,
    MAX_TABLE_TYPE
  };

```

## V4.x 版本的 table_type

```shell
enum TableType : unsigned char
  {
    // < memtable start from here
    DATA_MEMTABLE = 0,
    TX_DATA_MEMTABLE = 1,
    TX_CTX_MEMTABLE = 2,
    LOCK_MEMTABLE = 3,
    DIRECT_LOAD_MEMTABLE = 4,
    MAX_MEMTABLE_TYPE,
    // < add new memtable here

    // < sstable start from here
    MAJOR_SSTABLE = 10, //Reuse type, also represents row store column group in column store
    MINOR_SSTABLE = 11,
    MINI_SSTABLE = 12,
    META_MAJOR_SSTABLE = 13,
    DDL_DUMP_SSTABLE = 14,
    REMOTE_LOGICAL_MINOR_SSTABLE = 15,
    DDL_MEM_SSTABLE = 16,
    COLUMN_ORIENTED_SSTABLE = 17,
    NORMAL_COLUMN_GROUP_SSTABLE = 18,
    ROWKEY_COLUMN_GROUP_SSTABLE = 19,
    COLUMN_ORIENTED_META_SSTABLE = 20,
    DDL_MERGE_CO_SSTABLE = 21, // used for column store ddl, for base sstable
    DDL_MERGE_CG_SSTABLE = 22, // used for column store ddl, for normal cg sstable, rowkey cg not supported
    DDL_MEM_CO_SSTABLE = 23,
    DDL_MEM_CG_SSTABLE = 24,
    DDL_MEM_MINI_SSTABLE = 25,
    MDS_MINI_SSTABLE = 26,
    MDS_MINOR_SSTABLE = 27,
    MICRO_MINI_SSTABLE = 28,
    INC_MAJOR_SSTABLE = 29,
    INC_COLUMN_ORIENTED_SSTABLE = 30,
    INC_NORMAL_COLUMN_GROUP_SSTABLE = 31,
    INC_ROWKEY_COLUMN_GROUP_SSTABLE = 32,
    INC_MAJOR_DDL_DUMP_SSTABLE = 33,
    INC_MAJOR_DDL_MERGE_CO_SSTABLE = 34,
    INC_MAJOR_DDL_MERGE_CG_SSTABLE = 35,
    INC_MAJOR_DDL_MEM_CO_SSTABLE = 36,
    INC_MAJOR_DDL_MEM_CG_SSTABLE = 37,
    INC_MAJOR_DDL_MEM_SSTABLE = 38,
    INC_MAJOR_DDL_AGGREGATE_CO_SSTABLE = 39,
    INC_MAJOR_DDL_AGGREGATE_CG_SSTABLE = 40,

    MAX_TABLE_TYPE
  };

```

Previous

[Oracle 模式 Update 更新 Clob 报错 ret_code=-5083](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000322504)

Next

[将已有的表添加到 tablegroup 后没有均衡的原因和解决方法](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000001120450) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线