Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

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:

  • Splitting LCR's Using Streams
  • RE: Splitting LCR's Using Streams
  • Re: Splitting LCR's Using Streams




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.