Skip to Main Content

Query remote data dictionary via db-link

BEDEMay 8 2018 — edited May 9 2018

It would be so wonderful, when having a db_link to be able to select * from all_objects@db_link. And also from all_arguments@db_link, all_tables@db_link, all_tab_columns@db_link, and so on.

Otherwise it's quite difficult to have two different database connections and look in two separate places in order to develop some procedure accessing data via a db-link.

Comments
Post Details
Added on May 8 2018
2 comments
13 views