Sounds like maybe an Materialized View would help you out. Also check out Advanced Replication. http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/bus_intl.htm#i31809 -- http://www.freelists.org/webpage/oracle-l