Cross Schema Table Reference After Migration to Oracle Commerce 11.1
Last updated on DECEMBER 22, 2016
Applies to:Oracle Commerce Platform - Version 11.1 and later
Information in this document applies to any platform.
After migrating to Oracle Commerce 11.1, there are a number of tables that have cross-schema references (foreign keys to tables that live in different schemas).
|Source Schema(s)||Source Table||Referenced Schema(s)||Referenced Table|
|Switching Catalog A, Switching Catalog B||
|Switching Catalog A, Switching Catalog B||dcs_product_rltd_article||Core||wcm_article|
|Core||dcs_wcm_media_rltd_prod||Switching Catalog A, Switching Catalog B||dcs_product|
This is only a problem if you are currently using switching datasources.
Upgraded to Oracle Commerce 11.1 using the SQL migration scripts.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms