The communication protocol for the database link. Whether the database link is homogeneous ( NO) or heterogeneous ( YES).

Whether the database link is currently logged on. SCOTT EMP.US.ACME.COM SCOTT inst2 23-JUN-99 JANE DBL.UK.ACME.COM BLAKE ora51 23-JUN-99 PUBLIC DBL1.UK.ACME.COM BLAKE ora51 23-JUN-99 SYS TARGET.US.ACME.COM SYS inst1 23-JUN-99 Here, the script is invoked and the resulting output is shown: DB_LINK USER SERVICE CREATED The following script queries the DBA_DB_LINKS view to access link information: COL OWNER FORMAT a10

Only those with additional privileges can use the ALL_DB_LINKS or DBA_DB_LINKS view. The net service name used to connect to the remote database.Īny user can query USER_DB_LINKS to determine which database links are available to that user. Maintained for backward compatibility only. If there is no fixed user, the column is NULL. If the link definition includes a fixed user, then this column displays the username of the fixed user.

If the link is public, then the user is listed as PUBLIC.

Oracle database toad