---
title: "查看动态分区表 - OceanBase 数据库 V4.5.0 | OceanBase 文档中心"
description: 查看动态分区表 动态分区表创建成功后，您可以通过 SHOW CREATE TABLE 语句查看表的定义和视图查看数据库中的动态分区表信息。 查看表的定义 表创建成功后，您可以使用 SHOW CREATE TABLE table_name; 语句查看表的定义。 更多有关 SHOW 语句的介绍信息，参见 SHOW 。 示…
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.5.0

# 查看动态分区表

更新时间：2026-03-10 16:23:17

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.5.0/zh-CN/700.reference/300.database-object-management/200.manage-object-of-oracle-mode/200.manage-partitions-of-oracle-mode/260.dynamic-partition-of-oracle-mode/300.view-dynamic-partition-table-of-oracle-mode.md)  

动态分区表创建成功后，您可以通过 `SHOW CREATE TABLE` 语句查看表的定义和视图查看数据库中的动态分区表信息。

## 查看表的定义

表创建成功后，您可以使用 `SHOW CREATE TABLE table_name;` 语句查看表的定义。

更多有关 `SHOW` 语句的介绍信息，参见 [SHOW](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004480974)。

**示例如下：**

查看表 `test_tbl1` 的定义。

```sql
SHOW CREATE TABLE test_tbl1;

```

查询结果如下：

```shell
+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| TABLE     | CREATE TABLE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| TEST_TBL1 | CREATE TABLE "TEST_TBL1" (
  "COL1" NUMBER(*,0),
  "COL2" TIMESTAMP(6)
) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 DYNAMIC_PARTITION_POLICY = (ENABLE = TRUE, TIME_UNIT = 'HOUR', PRECREATE_TIME = '3HOUR', EXPIRE_TIME = '1DAY', TIME_ZONE = '+8:00', BIGINT_PRECISION = 'NONE')
 partition by range(col2)
(partition "P0" values less than (Timestamp '2024-11-11 13:30:00.000000')) |
+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set

```

## 使用视图查看动态分区表信息

| 视图名 | 功能描述 |
| --- | --- |
| [sys.DBA_OB_DYNAMIC_PARTITION_TABLES](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004477220) | 展示本租户的动态分区表信息。 |
| [sys.V$OB_DYNAMIC_PARTITION_TABLES](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004476954) | 展示当前租户的动态分区表信息。该视图从内存中读取动态分区表相关属性，读取性能较好。 |

**示例如下：**

```sql
SELECT * FROM sys.DBA_OB_DYNAMIC_PARTITION_TABLES
WHERE TABLE_NAME = 'TEST_TBL1';

```

返回结果如下：

```shell
+---------------+------------+----------+----------------------------------------+--------+-----------+----------------+-------------+-----------+------------------+
| DATABASE_NAME | TABLE_NAME | TABLE_ID | MAX_HIGH_BOUND_VAL                     | ENABLE | TIME_UNIT | PRECREATE_TIME | EXPIRE_TIME | TIME_ZONE | BIGINT_PRECISION |
+---------------+------------+----------+----------------------------------------+--------+-----------+----------------+-------------+-----------+------------------+
| SYS           | TEST_TBL1  |   507940 | Timestamp '2024-11-11 13:30:00.000000' | TRUE   | HOUR      | 3HOUR          | 1DAY        | +8:00     | NONE             |
+---------------+------------+----------+----------------------------------------+--------+-----------+----------------+-------------+-----------+------------------+
1 row in set

```

## 相关文档

- [动态分区概述](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004479306)
 - [创建动态分区表](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004479304)
 - [修改动态分区表](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004479307)
 - [动态分区管理任务](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004479305)

 上一篇 下一篇 ![有帮助](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) 咨询热线