DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBFS_CONTENT

Object Details
Object Name: DBFS_CONTENT
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
STORE VARCHAR2 (256)
MOUNT VARCHAR2 (256)
PATHNAME VARCHAR2 (1024)
PATHTYPE VARCHAR2 (32)
FILEDATA BLOB (32767)
STD_ACCESS_TIME TIMESTAMP(6) (20)
STD_ACL VARCHAR2 (1024)
STD_CHANGE_TIME TIMESTAMP(6) (20)
STD_CHILDREN NUMBER

STD_CONTENT_TYPE VARCHAR2 (1024)
STD_CREATION_TIME TIMESTAMP(6) (20)
STD_DELETED NUMBER

STD_GUID NUMBER

STD_MODIFICATION_TIME TIMESTAMP(6) (20)
STD_OWNER VARCHAR2 (32)
STD_PARENT_GUID NUMBER

STD_REFERENT VARCHAR2 (1024)
OPT_HASH_TYPE VARCHAR2 (32)
OPT_HASH_VALUE VARCHAR2 (128)
OPT_LOCK_COUNT NUMBER

OPT_LOCK_DATA VARCHAR2 (128)
OPT_LOCKER VARCHAR2 (128)
OPT_LOCK_STATUS NUMBER

OPT_VERSION NUMBER

OPT_VERSION_PATH VARCHAR2 (1024)
OPT_CONTENT_ID RAW (128)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT STORE
,      MOUNT
,      PATHNAME
,      PATHTYPE
,      FILEDATA
,      STD_ACCESS_TIME
,      STD_ACL
,      STD_CHANGE_TIME
,      STD_CHILDREN
,      STD_CONTENT_TYPE
,      STD_CREATION_TIME
,      STD_DELETED
,      STD_GUID
,      STD_MODIFICATION_TIME
,      STD_OWNER
,      STD_PARENT_GUID
,      STD_REFERENT
,      OPT_HASH_TYPE
,      OPT_HASH_VALUE
,      OPT_LOCK_COUNT
,      OPT_LOCK_DATA
,      OPT_LOCKER
,      OPT_LOCK_STATUS
,      OPT_VERSION
,      OPT_VERSION_PATH
,      OPT_CONTENT_ID
FROM SYS.DBFS_CONTENT;

Dependencies

[top of page]

SYS.DBFS_CONTENT references the following:

SchemaSYS
PL/SQL PackageDBMS_DBFS_CONTENT - show dependent code
TYPESYS_PLSQL_9470731_2709_1
SYS.DBFS_CONTENT is referenced by following:

SchemaPUBLIC
SynonymDBFS_CONTENT