How to find all objects that use dblinks to connect to remote servers (using regular expressions on Oracle’s all_views) First – create temporary table as data of dictionary view ALL_VIEWS and convert column TEXT (view text) to CLOB type CREATE TABLE tmp_views AS SELECT Read more