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

Storage: Oracle Default Tablespace Configuration

Note: When assigning storage to tables and indexes, SQL Server uses ‘File Groups’ while Oracle uses ‘Tablespaces’. In the following sections, the term ‘tablespace’ is used as a generic reference to either of these terms.

By default, the generated SQL scripts assume that four tablespaces will be created for use by CA DLP:

WGN

This tablespace holds all tables containing administration data, that is, user, group, machine, and policy data.

WGNIDX

This tablespace holds the indexes associated with the tables in the WGN tablespace.

WGNDATA

This tablespace holds all tables containing captured or imported event data, including event audit details, participants, and trigger data.

WGNDATAIDX

This holds the indexes associated with the tables in the WGNDATA tablespace.

The scripts reference these tablespaces, but do not physically create them.