RE: Splitting LCR's Using Streams

  • From: Jeremiah Wilton <jeremiah@xxxxxxxxxxx>
  • To: <sblackbu@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 Jul 2008 08:08:14 -0700


Stuart Blackburn wrote:

> I'm looking for some advice on how to split 
> lcr's into multiple tables... 

From your description it sounds like Change Data Capture would be a suitable 
solution. You would just need to write a pl/sql procedure to populate the 
target table columns from the subscriber view.

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

Other related posts: