Oracle 视图 DBA_ADVISOR_DIR_DEFINITIONS 官方解释,作用,如何使用详细说明

本站中文解释

Oracle 视图 DBA_ADVISOR_DIR_DEFINITIONS 用于提供数据库中指定的通知目录的定义信息,例如:通知目录的上级目录/父目录,最高禁止权限等。该视图中的主要列如下所示:
(1)DIR_ID:表示通知目录ID。
(2)DIRECTORY_NAME:表示通知目录名称。
(3)PARENT_DIR_ID:表示通知目录的上级目录。
(4)DESCRIP:表示通知目录的描述信息。
(5)USER_ID:表示创建者的ID。
(6)CREATION_TIME:表示通知目录的创建时间。
(7)DENY_ADD_DIR:表示是否禁止在该目录下添加子目录。
(8)DENY_UPD_DIR:表示是否禁止修改目录的属性。

使用该视图的方法:
可以通过 Oracle DBMS_ADDM 包中的 DBMS_ADDM_DIR API 来使用该视图。该 API 用于创建、更新和查询通知目录。它的参数DIR_ID,用于指定所要操作的目录及父目录的 ID。

例:
下面的语句用于查询名为 “my_notification_dir” 的通知目录的上级目录:
SELECT PARENT_DIR_ID
FROM DBA_ADVISOR_DIR_DEFINITIONS
WHERE DIRECTORY_NAME = ‘my_notification_dir’;

官方英文解释

DBA_ADVISOR_DIR_DEFINITIONS provides a definition of the base directive.

Column Datatype NULL Description

ID

NUMBER

NOT NULL

Unique id for directive. The directive management engine automatically generates ID numbers. The identifier is unique among all directives regardless of the domain name and directive name.

ADVISOR_ID

NUMBER

NOT NULL

Identifier number of the owner advisor.

ADVISOR_NAME

VARCHAR2(128)

NOT NULL

The name of the advisor to which this directive belongs.

DIRECTIVE_NAME

VARCHAR2(128)

NOT NULL

Any value that further classifies this directive within a domain. The domain and the name form a unique key for the directive.

DOMAIN_NAME

VARCHAR2(128)

NOT NULL

Domain or namespace name.

DESCRIPTION

VARCHAR2(256)

NOT NULL

An optional description that documents the purpose of the directive.

TYPE

NUMBER

NOT NULL

Further describes the use of the directive. Possible values are:

  1. Filter – An Xpath filter

  2. Single Value – Evaluation returns a single string value

  3. Multiple Values – Evaluation returns one to many string values

  4. Conditional – Evaluation returns a single value based on an input key, similar to a CASE or SWITCH statement

TYPE_NAME

VARCHAR2(15)

A decoded version of the TYPE column.

TASK_STATUS

VARCHAR2(9)

The status of the directive instances when a task is not in its initial state. Possible values are:

  • IMMUTABLE

  • MUTABLE

INSTANCES

VARCHAR2(8)

Indicates whether a directive will permit multiple instances. Possible values are:

  • SINGLE

  • MULTIPLE

METADATA

CLOB

NOT NULL

A DTD that is used to process the directive.


数据运维技术 » Oracle 视图 DBA_ADVISOR_DIR_DEFINITIONS 官方解释,作用,如何使用详细说明