Summary

When we set up test systems, it is often the case that full production copies cannot be used due to the cost of storage, especially for large databases. In such cases, you would need to extract a relationally valid subset of data. Doing this manually is not an easy task, but it has to be done. Consequently, setting up test systems is often a slow, error-prone, manually-scripted process.

A lot of investigation is required to find the relationships in the database across various schemas; the rules for extraction need to be defined (keeping intact all the relationships), and even then you are not sure of the space requirements for the extracted subset.

The Test Data Management Pack allows you to reverse engineer an Application Data Model from your database, which is stored in the Enterprise Manager Cloud Control 12c repository. The metadata definition of tables and relationships from a single or multiple schemas can exist in a model, which can then be used to enable test data operations...