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