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

STORE

VARCHAR2(256)

Name of store

MOUNT

VARCHAR2(256)

Location at which instance of store is mounted

PATHNAME

VARCHAR2(1024)

Name of path to item

PATHTYPE

VARCHAR2(32)

Type of path item (see DBMS_DBFS_CONTENT Constants – Path Name Types)

FILEDATA

BLOB

BLOB locator that can be used to access data in the path item

STD_ACCESS_TIME

TIMESTAMP(6)

Time of last access of a path name’s contents

STD_ACL

VARCHAR2(1024)

Access Control List (in standard ACL syntax)

STD_CHANGE_TIME

TIMESTAMP(6)

Time of last change to the path name

STD_CHILDREN

NUMBER

Number of child directories/folders a directory/folder path has (this property should be available in providers that support the FEATURE_FOLDERS feature)

STD_CONTENT_TYPE

VARCHAR2(1024)

One or more client-supplied mime-types (in standard RFC syntax) describing the path name which is typically of TYPE_FILE. The content type is not necessarily interpreted by the store.

STD_CREATION_TIME

TIMESTAMP(6)

Time at which the item was created. Once set, this value remains the same for the lifetime of the path name.

STD_DELETED

NUMBER

Set to a nonzero number if the path name has been soft-deleted but not yet purged (see DBMS_DBFS_CONTENT Constants – Store Features)

STD_GUID

NUMBER

Store-specific unique identifier for a path name. Clients must not depend on the GUID being unique across different stores, but a given (store-name, store-specific-path name) has a stable and unique GUID for its lifetime.

STD_MODIFICATION_TIME

TIMESTAMP(6)

Time of last change to the data associated with a path name. Changes to the content of a TYPE_FILE or TYPE_REFERENCE path, the referent of the TYPE_LINK path, and addition or deletion of immediate children in a TYPE_DIRECTORY path, all constitute data changes.

STD_OWNER

VARCHAR2(32)

Client-supplied (or implicit) owner name for the path name

STD_PARENT_GUID

NUMBER

Store-specific unique identifier for the parent of a path name. Clients must not depend on the GUID being unique across different stores, but a given (store-name, store-specific-path name) has a stable and unique GUID for its lifetime.

The GUID of the parent of this path name (that is that std_parent_guid(pathname) == std_guid(parent(pathname))).

STD_REFERENT

VARCHAR2(1024)

Content of the symbolic link of a TYPE_LINK path, otherwise NULL. The STD_REFERENT can be an arbitrary string and must not necessarily be interpreted as path name by clients (or such interpretation should be done with great care).

OPT_HASH_TYPE

VARCHAR2(32)

Type of hash provided in the OPT_HASH_VALUE property (see DBMS_CRYPTO for possible options)

OPT_HASH_VALUE

VARCHAR2(128)

Hash value of type OPT_HASH_TYPE describing the content of the path name

OPT_LOCK_COUNT

NUMBER

Number of compatible locks placed on a path name. If different principals are allowed to place compatible (read) locks on a path, the OPT_LOCKER must specify all lockers with repeats so that lock counts can be correctly maintained.

OPT_LOCK_DATA

VARCHAR2(128)

Client-supplied user-data associated with a user-lock, uninterpreted by the store

OPT_LOCKER

VARCHAR2(128)

One or more implicit or client-specified principals that applied a user-lock on a path name

OPT_LOCK_STATUS

NUMBER

One of the (LOCK_READ_ONLY, LOCK_WRITE_ONLY, LOCK_READ_WRITE) values describing the type of lock currently applied on a path name

OPT_VERSION

NUMBER

Sequence number for linear versioning of a path name

OPT_VERSION_PATH

VARCHAR2(1024)

Version path name for hierarchical versioning of a path name

OPT_CONTENT_ID

RAW(128)

A provider-generated store-specific unique contentID in the form of a string for a file element (that may optionally not be associated with a path (see FEATURE_CONTENT_ID and FEATURE_LAZY_PATH in DBMS_DBFS_CONTENT Constants – Store Features)