If you have not used CIM to create your Oracle ATG Web Commerce tables, you can create them using the scripts described in this section.
Create tables for Oracle ATG Web Commerce platform by following the instructions provided in the ATG Installation and Configuration Guide.
Create tables for Oracle ATG Web Commerce by running the
dcs_ddl.sql
script from the following directory:<ATG10dir>/DCS/sql/install/
database-vendor
Note that if you want to run the Motorprise Reference Application, you can instead follow the instructions provided in Creating Motorprise Reference Application Tables.
The dcs_ddl.sql
script includes the subscripts listed in the table below. If necessary, you can run these subscripts individually from the following directory:
<ATG10dir>/DCS/sql/db_components/
database-vendor
production_core schema
claimable_ddl.sql
commerce_user.sql
dcs_mappers.sql
inventory_ddl.sql
order_ddl.sql
contracts_ddl.sql
organization_ddl.sql
order_markers_ddl.sql
user_giftlist_ddl.sql
user_promotion_ddl.sql
invoice_ddl.sql
priceLists_ddl.sql
product_catalog_ddl.sql
custom_catalog_ddl.sql
promotion_ddl.sql
publishing schema
commerce_user.sql
inventory_ddl.sql
user_promotion_ddl.sql
order_ddl.sql
contracts_ddl.sql
user_giftlist_ddl.sql
dcs_mappers.sql
order_markers_ddl.sql
invoice_ddl.sql
organization_ddl.sql
The following scripts can be found in the <ATG10dir>/DCS/sql/db_components/
database-vendor
directory:
versioned_claimable_ddl.sql
versioned_commerce_site_ddl.sql
versioned_priceLists_ddl.sql
versioned_product_catalog_ddl.sql
versioned_custom_catalog_ddl.sql
versioned_promotion_ddl.sql
For descriptions of individual Oracle ATG Web Commerce database tables, see Appendix B, Oracle ATG Web Commerce Databases.
If you are using an Oracle or MSSQL database with Commerce, see Using Oracle ATG Web Commerce with an Oracle Database and Using Oracle ATG Web Commerce with an MSSQL Database respectively for important information.