To delete order objects:
- Type the following:
./dbclean.sh -object order -type typename -instancexml instancename -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
dbclean -object order -instancexml instancename -type typename -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 one of seven different types: completed to indicate a completed order, canceled to indicate a canceled order, shipped to indicate a shipped order, deposited to indicate an order which has been deposited, stale_guest to indicate stale orders from guest customers, stale_non_guest to indicate stale orders by customers who are not guests, or markfordelete to indicate a requisition list or an order item that needs to be deleted.
- Examine the dbclean_yyyy.mm.dd_hh.mm.ss.zzz.log file.