This discussion is archived
1 Reply Latest reply: Nov 15, 2012 11:54 PM by user85109 RSS

MDM 2.0.1 - What are the "_k" table in mdm database?

dfilgueiras Newbie
Currently Being Moderated
What are the "_k" table in mdm database? What do they contain? Examples:
* d1_dvc_k
* d1_contact_k
* d1_sp_k
* d1_install_evt_k
  • 1. Re: MDM 2.0.1 - What are the "_k" table in mdm database?
    user85109 Journeyer
    Currently Being Moderated
    These tables are the 'key' tables. This concept is part of the Oracle Utilities Application Framework and is used to maintain unique key values for entities among different environments. In the past it was for example used by the archive engine to ensure the key value of entries transferred to your archive, would still remain in your live system. This would prevent the system from creating a new entry having the same key value as an entry in your archive.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points