Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add comments to a database link

gassenmjNov 19 2019 — edited Nov 19 2019

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?

Comments

Processing

Post Details

Added on Nov 19 2019
1 comment
811 views