TRUNCATE TABLE-ApsaraDB for OceanBase (Deprecated)(OceanBase)-阿里云帮助中心

This topic describes the conversion scope of TRUNCATE TABLE DDL operations during data migration from an Oracle database to an Oracle tenant of OceanBase Database.

Syntax

TRUNCATE TABLE [schemaName.] tableName
  [ {PRESERVE | PURGE} MATERIALIZED VIEW LOG ]
  [ {DROP [ ALL ] | REUSE} STORAGE ] [ CASCADE ] ;

Supported operations

Truncating a table by using the TRUNCATE TABLE [schemaName.] tableName statement is supported. Sample code:

TRUNCATE TABLE sales;

Ignored clauses and options

Note

The following clauses and options will be ignored and will not be resolved or converted when they are specified in the synchronized DDL statements.

PRESERVE MATERIALIZED VIEW LOG
PURGE MATERIALIZED VIEW LOG
DROP STORAGE
DROP ALL STORAGE
REUSE STORAGE
CASCADE