Database Guide › Database Storage and Partitioning › Obtain the Native DDL Scripts › Partitioning: Default Configuration

Partitioning: Default Configuration

(Applicable to Oracle databases only) Partitioning is only supported for captured or imported events, and only tables in the specified tablespace are partitioned. By default, this is the WGNDATA tablespace.

Notes:

• Tables are configured for RANGE partitioning on the EventTimestamp column.
• Tables are sub-partitioned by HASH on the EventUID column. By default, the scripts specify four subpartitions.
• A single default MAXVALUE partition is created by default in the specified tablespace.

More information:

Customizable Names for Partitions, Temporary Tables and Tablespaces