Administer > Database Cleanup utility > Clean the database


Delete distributor objects


Procedure

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

      • ./dbclean.sh -object contract -type obsolete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -db dbname -dbuser user -dbpasswd password

      • dbclean -object contract -type obsolete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -db dbname -dbuser user -dbpasswd password

      • . dbclean.sh -object contract -type obsolete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -db dbname -dbtype oracle -dbuser user -dbpasswd password

      • dbclean -object contract -type obsolete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -db dbname -dbtype oracle -dbuser user -dbpasswd password

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

  2. From the WC_INSTALL/bin directory, type the following to delete fulfillment objects:

      • ./dbclean.sh -object fulfillment_center -type obsolete - instancexml WC_INSTALL /instances/ instance /xml/ instance .xml db dbname -dbuser user -dbpasswd password

      • dbclean -object fulfillment_center -type obsolete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -db dbname -dbuser user -dbpasswd password

      • . dbclean.sh -object fulfillment_center -type obsolete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -db dbname -dbtype oracle -dbuser user -dbpasswd password

      • dbclean -object fulfillment_center -type obsolete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -db dbname -dbtype oracle -dbuser user -dbpasswd password

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

  3. From the WC_INSTALL/bin directory, type the following to delete store objects:

      • . dbclean.sh -object store -type markedfordelete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -name storeID -db dbname -dbuser user -dbpasswd

      • password

    • dbclean -object store -type markedfordelete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -name storeID -db dbname -dbuser user -dbpasswd password


    • . dbclean.sh -object store -type markedfordelete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -name storeID -db dbname -dbtype oracle -dbuser user -dbpasswd password

    • dbclean -object store -type markedfordelete -instancexml WC_INSTALL /instances/ instance /xml/ instance .xml -name storeID -db dbname -dbtype oracle -dbuser user -dbpasswd password

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

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