首批通过分布式安全可靠测评，为关键业务系统打造
查看动态分区表
更新时间：2026-03-10 16:23:17
编辑
分享
动态分区表创建成功后，您可以通过 SHOW CREATE TABLE 语句查看表的定义和视图查看数据库中的动态分区表信息。
查看表的定义
表创建成功后，您可以使用 SHOW CREATE TABLE table_name; 语句查看表的定义。
更多有关 SHOW 语句的介绍信息，参见 SHOW。
示例如下：
查看表 test_tbl1 的定义。
SHOW CREATE TABLE test_tbl1;
查询结果如下：
+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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 | 展示本租户的动态分区表信息。 |
| sys.V$OB_DYNAMIC_PARTITION_TABLES | 展示当前租户的动态分区表信息。该视图从内存中读取动态分区表相关属性，读取性能较好。 |
示例如下：
SELECT * FROM sys.DBA_OB_DYNAMIC_PARTITION_TABLES
WHERE TABLE_NAME = 'TEST_TBL1';
返回结果如下：
+---------------+------------+----------+----------------------------------------+--------+-----------+----------------+-------------+-----------+------------------+
| 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
