Previous Topic: Temporary Table NameNext Topic: Customizable Pre-and Post-Operation Procedures

Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Customize Your Partitioning Scheme › Tablespace Name

Tablespace Name

Only CA DataMinder tables containing captured or imported events can be partitioned. By default, these tables are in the WGNDATA tablespace, but you can specify a different tablespace. The function prototype is shown below:

FNCTION wgn_get_tablespace_name
(table_name IN VARCHAR2) 
RETURN VARCHAR2

Note: The wgn_get_tablespace_name function assumes that all partitioned tables are in the same tablespace. But if you have separated these tables into separate tablespaces (for example, assigning event, auditing and trigger tables to separate tablespaces), then you will need to implement wgn_get_tablespace_name with a custom function that reflects your own site-specific database deployment.