Partitions on AUDSYS.aud$unified table is getting counted towards “Partition License” ? (Doc ID 2883768.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

Partitions on AUDSYS.aud$unified table is getting counted towards “Partition License” ?

Example:

SQL> select table_name,partition_name,INTERVAL,HIGH_VALUE,HIGH_VALUE_LENGTH from dba_tab_partitions where table_name='AUD$UNIFIED';

TABLE_NAME PARTITION_NAME INT HIGH_VALUE HIGH_VALUE_LENGTH
----------------------------- ----------------------------- --- ------------------------------------------------------------ -----------------
AUD$UNIFIED AUD_UNIFIED_P0 NO TIMESTAMP' 2014-07-01 00:00:00' 31 ====>After purging one partition left

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.