Tuesday, January 04, 2011

Purging SOA Suite: Not fully completed

As we have purge scripts loaded in the dehyradtion database to clean up the data, we saw that not all the data is removed. The table AUDIT_COUNTER grows.  I assume it is a bug/feature of the frabric package.

You should update your fabric package, or create your own :-), to delete this data as well. But this can only be done if the CIKEY doe not exists in the CUBE_INSTANCE table.

delete from audit_counter ac
where ac.cikey not in 
(
   select ci.cikey from cube_instance ci
);


Post a Comment