Administer > Database Cleanup utility > Clean the database
Delete available to promise inventory objects
Procedure
- From the WC_INSTALL/bin directory, run the following script:
- . dbclean.sh -object atp_inventory -type typename -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -dbuser user -loglevel loglevel
- dbclean -object atp_inventory -type typename -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -loglevel loglevel
- . dbclean.sh -object atp_inventory -type typename -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -loglevel loglevell -dbtype oracle -dbuser user -dbpasswd password
- dbclean -object atp_inventory -type typename -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -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.
- Examine the WC_INSTALL/instances/instance/logs/DBClean/DBClean. timestamp.log file.
Related concepts
Related reference
Database Cleanup utility objects