Re: Application & Table Merging Query

Alan Moore wrote:

> A User updating their subset (view) of data also requires 'read only'
> access to the other 3 representative areas IN THE SAME TABLE.
>
> The intention here is to attempt a DBA solution as opposed to changing
> the entire Application code.

  You can use snapshot (for read-only) or replication. Alternatively, you can use location transparently. In other word, it is to make use of synonym and database link to achieve your purpose. I think it is the easiest way.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.