of coz the table is brought to local database

if I run

select *
from emp, dept@dblink
where emp.deptno = dept.deptno

where do you think the join takes place? do you think emp is sent to remote database and joined there then data is sent back?

if you look the SQL run in remote database you will see

select * from dept