Have you looked at partitioning the base table and MV's? Partition Change Tracking might help you.
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules
Reply With Quote