Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Customize Your Partitioning Scheme › Partition Names

Partition Names

By default, partition names include: a ‘TP_’ prefix; the name of the database table being partitioned; and the partition end date (the date format is defined by the wgn_get_pn_date_fmt function. Partition names use this pattern:

TP_<table name><end date>

For example:

TP_WGN3EVENT2006/01/31

If required, you can customize the partition naming convention. The function prototype is shown below:

FUNCTION wgn_get_partition_name
(table_name IN VARCHAR2,
date_range IN VARCHAR2) 
RETURN VARCHAR2;