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

Temporary Table Name

By default, the names of temporary tables include a ‘_TEMP’ suffix:

<table name>_TEMP

For example,

WGN3EVENT_TEMP

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

FUNCTION wgn_get_tmp_tab_name
(table_name IN VARCHAR2) 
RETURN VARCHAR2;