Ignore database link when linked DB offline
Is it possible to ignore DB link when linked DB is offline?
CREATE OR REPLACE FORCE VIEW employee_names ("name") AS
select name from employee@orcl10
UNION ALL
select name from employee@orcl20
UNION ALL
select name from employee@orcl30
Normally, if orcl20 is offline and I run: select * from employee_names; I get below error
ERROR at line 1:
ORA-12541: TNS:no listener
Is it possible to just get it to ignore it, so it can resume with the other links and select successfully?
Thank you,
Ayman