Subsetting Production Data
Just about every database out there has at least three copies of itself: production, test, and development. Some shops take this even further with separate test and stress-test instances. It’s pretty obvious that production is the real deal and hence the source of data for the copies. But how do you make relationally correct, subset copies of production data for both test and development? Oracle provides no tools for simply taking 10% of the production data and copying it to another database. The DBA or developer must either write extensive scripts themselves or utilize TOAD’s new Data Subset Wizard (debuted in TOAD 7.3).
TOAD’s Data Subset Wizard is a simple four-step utility for automatically generating relationally ...
Get TOAD® Handbook 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.
