Oracle Test data management in oracle database 12c

Whenever we get a requirement from developer to create a development database that is exact replica of production after a produciton patching , upgrade etc it becomes resource intensive operation particularly in terms of space. Say, the developer has 1 year old database and current dev demands 100Gb additional space to ahve latest code in place. To circumvent this space issue Oracle database 12c test data management tool comes handy. Using this we can

1) Create a development (or) test environment that is replica of produciton data
2) Create a subset of actual prod – In simple terms the dev (or) test env will ahve all enterprise application logics, referential integrity in place but with smaller footprint
3) Only smaller footprint (or) subset of produciton is made use of to create test (or) dev. This saves space

MongoDB,NoSQL Database Articles,Tutorials, Free Interview Q&A,Training

Delivered by FeedBurner