Deleting distributor objects
To delete distributor objects from the database, use the Database Cleanup utility.
Procedure
-
From the WC_installdir/bin
directory, run the following script:
-
- ./dbclean.sh -object contract -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbuser user -dbpasswd password
- dbclean -object contract -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbuser user -dbpasswd password
-
- .dbclean.sh -object contract -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbtype oracle -dbuser user -dbpasswd password
- dbclean -object contract -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbtype oracle -dbuser user -dbpasswd password
Use host:port:sid for the database name for example, myhost:1521:mydb.
-
-
From the WC_installdir/bin directory, type the
following to delete fulfillment objects:
-
- ./dbclean.sh -object fulfillment_center -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml db dbname -dbuser user -dbpasswd password
- dbclean -object fulfillment_center -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbuser user -dbpasswd password
-
- . dbclean.sh -object fulfillment_center -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbtype oracle -dbuser user -dbpasswd password
- dbclean -object fulfillment_center -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbtype oracle -dbuser user -dbpasswd password
Use host:port:sid for the database name for example, myhost:1521:mydb.
-
-
From the WC_installdir/bin directory, type the
following to delete store objects:
-
- .dbclean.sh -object store -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -name storeID -db dbname -dbuser user -dbpasswd password
- dbclean -object store -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -name storeID -db dbname -dbuser user -dbpasswd password
-
- .dbclean.sh -object store -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -name storeID -db dbname -dbtype oracle -dbuser user -dbpasswd password
- dbclean -object store -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -name storeID -db dbname -dbtype oracle -dbuser user -dbpasswd password
Use host:port:sid for the database name for example, myhost:1521:mydb.
-
- Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.