APEX

Hi All,

i have installed Apex on 10g express. BY using object browser i can only browse local database like "XE".
But i have another 2, 3 databases in different servers. I know how to connect them using database link and query them.
But the issue is when i want to write a query, i need to specify the database sid/instance always like below...which is so difficult since i'm writing long queries...

select * from table_s@testdb t1, table_d@testdb t2;

likewise i have to pass db sid everywhere in the query which is bit difficult.
if i dont mention that; then it says table or view does not exist...
How can i overcome this issue...??? is this the nature of apex or can i change the default database instance from local to whatever the db i want and directly query without passing instance name?

And the other thing is i cant access the tables through the wizard which are not local since those are located in a different server...so i have to write whole query by hand.... :S

I think you got my query clearly....

Can anybody please give me a hand to solve this issue...

Thanks in Advance,
Max