I want to be able to run a select on a remote oracle database, if the local database is not available, using PL/SQL.
For example if I run the follwing select and the DB is offline I want rerun a similar select on the remote database, but I cannot figure how to check if the local DB is offline
Select on the local db =
'SELECT * FROM test_id'
Select on the remote db =
'SELECT * FROM test_id@test' (where test is our database link)