Updated on 2025-05-29 GMT+08:00

Online DDL Operations

enable_online_ddl

Parameter description: This parameter is used together with the ONLINE or OFFLINE keyword to specify whether to enable an online DDL or VACUUM operation. For details about the keywords, see "SQL Reference > SQL Syntax > A > ALTER TABLE" and "SQL Reference > SQL Syntax > V > VACUUM" in Developer Guide.

Parameter type: Boolean.

Unit: none

Value range:

  • on: Online DDL is enabled and does not take effect in the current version.
  • off: Online DDL is disabled and does not take effect in the current version.

Default value: off

Setting method: This is a USERSET parameter. Set it based on instructions provided in Table 1.

Setting suggestion:

  • You are advised to disable this parameter. If this parameter is enabled, it does not take effect in the current version. If you need to use the new online DDL features in 505.2, add the keyword ONLINE to the syntax.

Risks and impacts of improper settings: Change the parameter value after fully understanding the parameter meaning and verifying it through testing.