To delete records of a base search space for a category do the following:
- Open a command window, which corresponds to the database that you are using.
- Run the following SQL statement:
Refer to the WebSphere Commerce Installation Guide for information on how to run the SQL statements against the WebSphere Commerce database.
- delete from ICEXPLFEAT where CATGROUP_ID=xxxx
- delete from ICROOTCAT where CATGROUP_ID=xxxx
Where, xxxx is the category reference number for which search space needs to be deleted.
- delete from ICEXPLFEAT where CATGROUP_ID=xxxx