How to shrink table WRI$_OPTSTAT_SYNOPSIS$
Hi,
In a datawarehouse on Oracle 11.2.0.2 on AIX 6.1, we are using Incremental statistics for our fact tables and staging tables which are partitioned by date interval range and, for the fact tables, subpartitionned by hash.
For business reasons, we were not purging the tables so the table WRI$_OPTSTAT_SYNOPSIS$ grew up to 1.2 billion record with a size of 42GB.
few days ago, we ran our purging process which drop partitions. The table WRI$_OPTSTAT_SYNOPSIS$decreased to 334 Millions records but is still 42GB!
Is there a way to shrink that table, as it is a system table?
Thanks
Christophe
In a datawarehouse on Oracle 11.2.0.2 on AIX 6.1, we are using Incremental statistics for our fact tables and staging tables which are partitioned by date interval range and, for the fact tables, subpartitionned by hash.
For business reasons, we were not purging the tables so the table WRI$_OPTSTAT_SYNOPSIS$ grew up to 1.2 billion record with a size of 42GB.
few days ago, we ran our purging process which drop partitions. The table WRI$_OPTSTAT_SYNOPSIS$decreased to 334 Millions records but is still 42GB!
Is there a way to shrink that table, as it is a system table?
Thanks
Christophe
0