If you are using the Oracle ATG Web Commerce multisite feature, see the ATG Multisite Administration Guide for configuration information. You will need to run the following additional database script against your administration, production, and versioned database schemas:

<ATG10dir>\Search10.2\SearchAdmin\common\sql\db_components\db_type\
search_site_ddl.sql