RE: Splitting LCR's Using Streams

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Fri, 4 Jul 2008 08:08:14 -0700
Message-Id: <20080704150819.0CC868690C6@turing.freelists.org>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 04 2008 - 10:08:14 CDT

This message: [ Message body ]
Next message: Hemant K Chitale: "Re: Cloning a database with backup pieces in a different location"
Previous message: Stuart Blackburn: "Splitting LCR's Using Streams"
Maybe in reply to: Stuart Blackburn: "Splitting LCR's Using Streams"
Next in thread: Roman Podshivalov: "Re: Splitting LCR's Using Streams"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message