To delete returned item objects:
- Type the following:
./dbclean.sh -object rma -type typename -instancexml instancename -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
dbclean -object rma -type typename -instancexml instancename -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
Use host:port:sid for the Oracle database name. For example, myhost:1521:mydb.
Note: 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.
- Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.