Hmm. If they are straight views to the database, I fail to see how this protects Database A from bad queries as the bulk of the work will be done on Database A anyway. If they are using materialized views, or streams, or Logical Standby, or any other form of replication, I would probably agree with them. Bradd Piontek Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd On Wed, Sep 24, 2008 at 10:07 AM, Brady, Mark <Mark.Brady@xxxxxxxxxxxxxxxxx>wrote: > I have a friend (no really, this isn't some lame way of telling you about > me but trying to hide that by … ) > > > I have a friend, and at his company they have an Oracle database with > tables and data. We'll call it Database A and they have another Database B > that has views across dblinks to each of the tables in Database A. The data > team says that this protects Database A from bad queries. > > So can anyone think of any possible benefit from this arrangement? Will > administration be easier, queries faster, performance more predictable? > Anything? > > > >>> This e-mail and any attachments are confidential, may contain legal, > >>> professional or other privileged information, and are intended solely for > >>> the addressee. If you are not the intended recipient, do not use the > >>> information in this e-mail in any way, delete this e-mail and notify the > >>> sender. CEG-IP1 > >