After installing ATG Search, create the database tables.
Run SQL scripts to create the Search Routing tables in your production database schema:
<ATG10dir>\DAF\Search\Routing\sql\db_components\db_type\
routing_ddl.sql<ATG10dir>\DAF\Search\Index\sql\db_components\db_type\
search_ddl.sql<ATG10dir>\DAF\Search\common\sql\db_components\db_type\
refinement_ddl.sql<ATG10dir>\DAF\Search\Topics\sql\db_components\db_type\
search_topics_ddl.sql
The
search_ddl.sqlscript creates the tables used by theIncrementalLoaderto track changes to the indexed repository. Therefinement_ddl.sqlscript creates the tables used by theRefinementRepository.Run the scripts to create the Search Administration tables in the production database schema. The following script is located in the
<ATG10dir>\Search10.1\SearchAdmin\common\sql\db_components\db_type\directory:searchadmin_admin_ddl.sql
The following scripts are located in the
<ATG10dir>\Search10.1\SearchAdmin\customizations\sql\db_components\db_type\directory:searchadmin_dictionary_ddl.sqlsearchadmin_termweights_ddl.sqlsearchadmin_queryrules_ddl.sqlsearchadmin_tpo_ddl.sqlsearchadmin_facet_ddl.sql
If you have not already done so for any of your other applications, run the following script to create Oracle ATG Web Commerce Business Control Center tables:
<ATG10dir>\BIZUI\sql\install\db_type\bizui_all_ddl.sql
