Remember that when you register an environment as a ConfigLab , there is a database relationship from the CISUSER schema in the ConfigLab environment database that points to the CISUSER schema in the target environment. This database relationship allows a subset of tables (i.e., the system-generated key tables) to access the target environment's CISUSER schema when generating a key value for a new record.
When a system-generated key value is assigned, the key value is also kept in the table's corresponding "key table" (see Defining Table Options). Key tables store the environment identifier along with the key value.
The key table in the target environment holds the key values of rows in its own environment plus the key values of rows in the ConfigLab environment. This ensures that system-generated keys added in the ConfigLab are not used in the target environment.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.