configure streams to pick only a subset of table data
edited Jul 29, 2013 4:24AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
I have a 30 GB table with millions of rows having years of data but our developers need only one day's of data to run reports as querying the whole table is taking too long and consuming resources on the Production database.
I had suggested to implement oracle streams to replicate the table to another similar table in another db but I dont know how to configure streans to pick only current day's data from the table as opposed to all data from the table.
Please advise on how I can configure streams to achieve this or is there an alternative method to having another table in another db with replicated one day's data from PROD db table.
I had suggested to implement oracle streams to replicate the table to another similar table in another db but I dont know how to configure streans to pick only current day's data from the table as opposed to all data from the table.
Please advise on how I can configure streams to achieve this or is there an alternative method to having another table in another db with replicated one day's data from PROD db table.
0