You can run Oracle scripts in a sharded deployment by running specific
scripts.
Procedure
- Run all of the scripts within each directory
for each shard: <INSTALL_DIR>/database/oracle/scripts/CustomDBViews/<tabletype>
where <tabletype> is configuration, transaction,
and master.
- Run the configuration table
type scripts for the Configuration shard, the transaction table
type scripts for the Transaction shard, and the master table
type scripts for the Master shard.
- Additionally, for a sharded deployment, run yfs_addnl_index.sql in
<INSTALL_DIR>/database/db2/scripts/CustomDBIndexes/<tabletype>
where <tabletype> is configuration and
transaction.
Note: When running the custom view scripts manually, ignore the wms_master_db_script.sql
script.