Michael, given your description it sounds like you are looking at the partitioned views. However, I'd try to avoid having two different schemas scenario at all, it is not really clear what's the definition of the "group" but see if composite partitioning might be applied to your case. > Any suggestions? -- Alex Fatkulin, http://afatkulin.blogspot.com http://www.linkedin.com/in/alexfatkulin -- //www.freelists.org/webpage/oracle-l