Administer > Database Cleanup utility > Clean the database


Delete forum message objects


Procedure

  1. From the WC_INSTALL/bin directory, run the following script:

      •   . dbclean.sh -object forummsg -type obsolete -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -dbuser user -days daysold -loglevel loglevel

      • dbclean -object forummsg -type obsolete -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevel

      • . dbclean.sh -object forummsg -type obsolete -instancev WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevell -dbtype oracle -dbuser user -dbpasswd password

      • dbclean -object forummsg -type obsolete -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevell -dbtype oracle -dbuser user -dbpasswd password

      Use host:port:sid for the database name. For example, myhost:1521:mydb.


    Note: For details on the syntax and parameters for the dbclean script, see Database Cleanup utility script.  

  2. Examine the WC_INSTALL/instances/instance/logs/DBClean/DBClean. timestamp.log file.


Related concepts

Database Cleanup utility

Related reference

Dbclean utility script

Database Cleanup utility objects

Examples: Deleting objects


+

Search Tips   |   Advanced Search