Drop temporary aggregate tables and indexes
Dropping temp tables at regular intervals can save users lots of disk space.
Symptoms
You need to restore storage space and speed up database utilities. Usage:$TOP/src/db/schema/util/drop_temp_agg_tables.sh
Resolving the problem
You can use the drop_temp_agg_tables.pl maintenance script to drop temporary aggregate tables and indexes.For more information, see the following links for a list of database admin scripts and commands:
- Oracle - Scripts and commands for Oracle
- DB2®- Scripts and commands for Db2