GS_DB_LINKS
GS_DB_LINKS displays information about DATABASE LINK objects. You can view information about your own DATABASE LINK objects and DATABASE LINK objects at the PUBLIC level.
Name |
Type |
Description |
---|---|---|
dblinkid |
oid |
OID of the current DATABASE LINK object. |
dlname |
name |
Name of the current DATABASE LINK object. |
dlowner |
oid |
Owner ID of the current DATABASE LINK object. If the object owner is public, the value is 0. |
dlownername |
name |
Name of the owner of the current DATABASE LINK object. |
options |
text[] |
Connection information of the current DATABASE LINK object. The value is a character string in the "keyword=value" format. |
useroptions |
text |
Information of the remote end user to which the current DATABASE LINK object connects. |
heterogeneous |
text |
Not supported. Its value is NULL. |
protocol |
text |
Not supported. Its value is NULL. |
opencursors |
text |
Not supported. Its value is NULL. |
intransaction |
Boolean |
Specifies whether the current DATABASE LINK object exists in a transaction. |
updatasent |
Boolean |
Specifies whether the current DATABASE LINK object uses statements for updating data. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.