Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 24, 2013 11:51 PM by
Prod to Test Data Sync
Apr 3, 2013 4:18 AM
I am trying to evaluate ways to replicate subsets of data from our production to our test environments.
Please suggest possible products that can be used (The cheaper/free the better)
Last time it was done via DB links but it was very slow.
Also export import is not an option.
Tables may have different structure so the product must be able to dot the proper mapping.
I also had a look at Oracle Test Management Pack: http://www.oracle.com/technetwork/oem/pdf/511875.pdf which looks quite interesting.
This content has been marked as final.
Show 1 reply
Re: Prod to Test Data Sync
Apr 24, 2013 11:51 PM
in response to
You can use Oracle streams to replicate subset of data using subset rules. Please go through Oracle documentation related to streams and let me know if you have any further queries.