RPT_ tables in WCC ORA DB

Document ID : KB000097722
Last Modified Date : 29/05/2018
Show Technical Document Details
Question:
The RPT_* tables in the WCC database have grown very large.  Is there a way to purge or truncate them so they are back to their original size when WCC was first installed?
Environment:
Workload Control Center 11.4.x
Platform - ANY
Database - Oracle.
Answer:
Stop WCC.
Run the following in the database as the wcc admin user: 

drop table RPT_AS_EVENT_DIMENSION; 
drop table RPT_AS_JOB_DEF_DIMENSION; 
drop table RPT_AS_JOB_DESC_DIMENSION;
drop table RPT_AS_JOB_OWNER_DIMENSION; 
drop table RPT_AS_JOB_RUN_EVENT_FACT; 
drop table RPT_AS_JOB_RUN_EVENT_STAGE; 
drop table RPT_AS_JOB_RUN_FACT; 
drop table RPT_AS_JOB_RUN_STAGE; 
drop table RPT_AS_MACHINE_DIMENSION; 
drop table RPT_AS_STATISTIC_FACT; 
drop table RPT_AS_STATISTIC_STAGE; 
drop table RPT_AS_STATUS_DIMENSION; 
drop table RPT_DATE_DIMENSION; 
drop table RPT_PROFILE; 
drop table RPT_SERVER_DIMENSION; 
drop table RPT_TIME_DIMENSION; 
drop sequence RPT_AS_EVENT_SEQ; 
drop sequence RPT_AS_JOB_DEF_SEQ; 
drop sequence RPT_AS_JOB_DESC_SEQ; 
drop sequence RPT_AS_JOB_OWNER_SEQ; 
drop sequence RPT_AS_JOB_RUN_EVENT_FACT_SEQ; 
drop sequence RPT_AS_MACHINE_SEQ; 
drop sequence RPT_AS_STATUS_SEQ; 
drop sequence RPT_SERVER_SEQ; 

Restart WCC and the RPT tables/objects will be recreated.