Question about creating an "updatable" test instance of database
Hi,
I just want to ask the following:
1. Is it possible to create a copy of our production database in which we can do testing (update, delete, insert data, do table partition, connected to test application) AND AT THE SAME TIME we can update it to the current latest state of the production if we want?
2. If possible, what is the best and easiest way to do it without re creating the whole database?
At the moment, the process I do for this is to make a test database using datapump utility. However, this is tedious as I still need to re-install the database then do import-export and I think our test instance doesn't behave exactly like the production if it's replicated through this process.
I just want to ask the following:
1. Is it possible to create a copy of our production database in which we can do testing (update, delete, insert data, do table partition, connected to test application) AND AT THE SAME TIME we can update it to the current latest state of the production if we want?
2. If possible, what is the best and easiest way to do it without re creating the whole database?
At the moment, the process I do for this is to make a test database using datapump utility. However, this is tedious as I still need to re-install the database then do import-export and I think our test instance doesn't behave exactly like the production if it's replicated through this process.
0