To create data warehouse tables for Oracle ATG Web Commerce Search, load the following SQL scripts into the data warehouse database.

<ATG10dir>/ARF/DW/Search/sql/db_components/db_name:

If you are using Search with Commerce, after you create the Search tables, run the following script:

<ATG10dir>/DCS/DW/Search/sql/db_components/db_name/dcs_srch_ddl.sql

Note: There are foreign key dependencies among the tables created by dcs_srch_ddl.sql and the Search and platform tables.