Administer > Database Cleanup utility > Clean the database

Delete catalog entry objects

To delete catalog entry objects:

Procedure

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

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

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

   • • ./dbclean.sh -object catentry -type typename -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password

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

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

   Notes:

   1. For the -type parameter, you can specify without_orderitems to indicate catalog entries which are not referenced to any order item or without_orderitems_iitems to indicate catalog entries which are not referenced to any order item or interest list item.

   2. 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