Wednesday, September 17, 2008

TRUSTED_SERVERS

TRUSTED_SERVERS displays whether a server is trusted or untrusted.

Column

Datatype

NULL

Description

TRUST

VARCHAR2(9)

Trustedness of the server listed. Values can be TRUSTED or UNTRUSTED servers which are not listed in the NAME column have opposite trustedness.

NAME

VARCHAR2(128)

Server name. Can be a specific server name or ALL for all servers.

The following table shows examples of the values returned depending on the status of the servers.

Condition (If . . . )

TRUSTED column

NAME column

... all servers are trusted

Trusted

ALL

... no servers are trusted

Untrusted

ALL

... all servers except DB1 are trusted

Untrusted

DB1

... all servers except DB1 are untrusted

Trusted

DB1

Note:

1.

select * from TRUSTED_SERVERS;

TRUST

NAME

Trusted

All

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment