#db_link

[laurentschneider]

check invalid database link for the DBA

check invalid database link for the DBA

followup of http://laurentschneider.com/wordpress/2017/09/check-invalid-database-link.html If you need to check db link in another schema, you need to create code that run with that schema.

base on the example from yesterday, here is an extended version for the dba

CREATE FUNCTION dba_status (owner VARCHAR2, db_link VARCHAR2) RETURN VARCHAR2 IS PRAGMA AUTONOMOUS_TRANSACTION; status VARCHAR2…

View On WordPress

[laurentschneider]

check invalid database link

check invalid database link

If one database link is invalid, you cannot select through it SQL> select * from dual@z; select * from dual@z * ERROR at line 1: ORA-02019: connection description for remote database not found

However, there is no STATUS command in your user_db_links table that you could use. For this purpose, write a function. create function status(db_link varchar2) return varchar2 is x number;

View On WordPress