select over dblink hangs

 Hi guyz,

I have a weired problem with a new dblik I've just created.

When I do select count - select count (*) from sysobjects@mydblink;

it returns results (700) within 2 seconds

When I do select with where clause - select * from sysobjects@mydblink where rownum<=1000;

it display results within several seconds

But when I do select without where clause - select * from sysobjects@mydblink;

it hangs and never return any result.

I've been waiting for hours, but still nothing comes up

Can anyone explain why that weird thing happened?

Regards,

Ariella