Deleting marketing activity statistics
You can delete statistics that are associated with Management Center marketing
activities (Web, Dialog, and Email activities) that are deleted.
Procedure
-
From the WC_installdir/bin
directory, run the following script:
-
- ./dbclean.sh -object marketing_activity -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbuser user -loglevel loglevel
- dbclean -object marketing_activity -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -loglevel loglevel
-
- ./dbclean.sh -object marketing_activity -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
- dbclean -object marketing_activity -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
-
- Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.