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