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 ...

Get Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.