Optimizing searches on 2 databases

Hi Guys...
I am relatively new at Oracle and have been trying to find a way of accomplishing this for a bit... I'm hoping someone can point me in the right direction...

I have 2 databases set up...
DB1
Employee_Id - from E0001 to E0099

DB2
Employee_Id - from E0100 to E1000.

When I issue an SQL statement - Select Employee_Id where Employee_Id is > E0100, it goes out and searches both databases (accross the network) obviously not returning any values from DB1, only the ones from DB2 that fit the criteria. How would I prevent this? Is there a way to specify to only go to the one database since I know the Emp_Id ranges on both?

Any help/tip/link would be appreciated!

AngieB

Hi,

you can define a dblink in db1 connecting to the emp table in db2:

create database link db2 connect to user identified by password using 'db2';

after that you can:

select * from emp@db2;

you have to define the connect string in the tnsnames under the db1 machine.

good luck.