All Products
Search
Document Center

SHRINK

Last Updated: Jun 18, 2021

Description

This statement reorganizes the data in the table. This indicates that the data is rewritten during the merge process.

Syntax

ALTER TABLE table_name SHRINK SPACE

Parameter description

Parameter

Description

table_name

The table name.

Examples

  • Reorganize the data of table t1.

OceanBase(admin@test)>ALTER TABLE t1 SHRINK SPACE;