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.sqlscript from the following directory:<ATG10dir>/DCS/sql/install/database-vendorNote 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.sqlcommerce_user.sqldcs_mappers.sqlinventory_ddl.sqlorder_ddl.sqlcontracts_ddl.sqlorganization_ddl.sqlorder_markers_ddl.sqluser_giftlist_ddl.sqluser_promotion_ddl.sqlinvoice_ddl.sqlpriceLists_ddl.sqlproduct_catalog_ddl.sqlcustom_catalog_ddl.sqlpromotion_ddl.sql
publishing schema
commerce_user.sqlinventory_ddl.sqluser_promotion_ddl.sqlorder_ddl.sqlcontracts_ddl.sqluser_giftlist_ddl.sqldcs_mappers.sqlorder_markers_ddl.sqlinvoice_ddl.sqlorganization_ddl.sql
The following scripts can be found in the <ATG10dir>/DCS/sql/db_components/database-vendor directory:
versioned_claimable_ddl.sqlversioned_commerce_site_ddl.sqlversioned_priceLists_ddl.sqlversioned_product_catalog_ddl.sqlversioned_custom_catalog_ddl.sqlversioned_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.
