Administer > Database Cleanup utility > Clean the database

Delete organization objects

Procedure

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

   • •   ./dbclean.sh -object organization -type specified -db dbname -dbuser user -loglevel loglevell -name organizationid -instancexml WC_INSTALL/instances/instance/xml/ instance.xml

     • dbclean -object organization -type specified -db dbname -loglevel loglevell -name organizationid -instancexml WC_INSTALL/instances/instance/xml/ instance.xml

   • • ./dbclean.sh -object organization -type specified -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password -name organizationid -instancexml WC_INSTALL/instances/instance/xml/ instance.xml

     • dbclean -object organization -type specified -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password -name organizationid -instancexml WC_INSTALL/instances/instance/xml/ instance.xml

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

   Notes:

   1. For the -type parameter, you can specify organization to indicate any organization record.

   2. For details on the syntax and parameters for the dbclean script, see Database Cleanup utility script.  

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