Add comments to a database link

gassenmj

There are pros and cons about database links in the Oracle DB. One point of criticism to me seems that there is always very few documentation of what You would break if changing the DB link.

I was thinking about offering a way to add a comment to a DB link. We have that opportunity for a long time for several other objects and it helps a lot to document Your work:

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/COMMENT.html#GUID-65F447C4-6914-4823-9691-F15D52DB74…

That might allow developers and DBAs that want/have to work with DB links to at least document a bit why the distributed setup has been chosen.

We could store a lot of helpful information in such a comment: What would break if we export/import such a DB link; What DB is connected remotely; is it read only or read/write;...

Ideally we could query such a comment in the data dictionary, e.g.

select * from db_links;

or a new object like

select * from db_link_comments;

What do You think?

Mike Kutz

This idea seems to be a subset of the more general idea: 

Related idea would be

MK