Oracle Database Discussions

Hello all,

I have a view called V_MEDGEN_LISTRADIO but I can't run

SELECT * FROM V_MEDGEN_LISTRADIO

ORA-02020: too many database links in use

The cause is that we call in the view 5 tables over dblink and the open_links parameter is set to 4.

What is strange is that when I run this select by adding a where clause then it works!

SELECT * FROM V_MEDGEN_LISTRADIO WHERE SPRR = 3645;

Can someone explain me ? (use of index so all tables are not called ???)

Thanks