SQL Language (MOSC)

MOSC Banner

Ignore database link when linked DB offline

edited Mar 7, 2017 10:40PM in SQL Language (MOSC) 7 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center