RE: DB Links

And what happens if the local database is 8i, and the remote database is 9i?

Man are we makin stew or what!!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Gogala, Mladen [mailto:Mladen.Gogala_at_aetn.com] Sent: Thursday, September 23, 2004 10:57 AM To: 'Goulet, Dick'; thomas.mercadante_at_labor.state.ny.us; adar76_at_inter.net.il; adar76_at_inter.net.il; Oracle-L (E-mail) Subject: RE: DB Links

This depends on the version of the database on the driving site. If your driving site runs 8i, ALL of the data will be brought back and filtered locally. In 9i, the behavior is that single table access predicates that can be resolved remotely, are resolved remotely. Oracle 10g uses gridlock method for remote execution. Just kidding, haven't actually tried with 10.

--
Mladen Gogala
A & E TV Network
Ext. 1216




> -----Original Message-----

> From: Goulet, Dick [mailto:DGoulet_at_vicr.com]

> Sent: Thursday, September 23, 2004 10:53 AM

> To: Mladen.Gogala_at_aetn.com; 

> thomas.mercadante_at_labor.state.ny.us; adar76_at_inter.net.il; 

> adar76_at_inter.net.il; Oracle-L (E-mail)

> Subject: RE: DB Links

> 

> 

> Mladen,

> 

> 	My experience is somewhat different from yours.  In the

> case of "FROM EMP_at_LINK WHERE EMPNO = 1234" I have found that 

> the local database will pass that along to the remote 

> database for resolution since there will definelty be one and 

> only one row returned.  Now "FROM EMP_at_LINK WHERE EMPNO > 

> 1234" would also resolve itself on the remote db, but "FROM 

> dept a, EMP_at_LINK b WHERE a.empno = b.empno and b.EMPNO > 

> 1234" will result in emp becoming a local temp table.

--
http://www.freelists.org/webpage/oracle-l