Administer > Database Cleanup utility > Clean the database

Delete returned item objects

Procedure

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

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

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

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

     • dbclean -object rma -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 abandoned to indicate an abandoned record, canceled to indicate a canceled record, not_approved to indicate a rejected record, approved_or_partly_approved to indicate an approved or partly approved record, or completed to indicate a completed record.

   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