Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_FILE_GROUP_FILES

ALL_FILE_GROUP_FILES shows the file set for each versioned file group accessible to the current user.

Related Views

Column Datatype NULL Description
FILE_GROUP_OWNER VARCHAR2(30) NOT NULL Owner of the file group
FILE_GROUP_NAME VARCHAR2(30) NOT NULL Name of the file group
VERSION_NAME VARCHAR2(30) NOT NULL Name of the version to which the file belongs
VERSION NUMBER NOT NULL Internal version number of the file group version to which the file belongs
FILE_NAME VARCHAR2(512) NOT NULL Name of the file
FILE_DIRECTORY VARCHAR2(30) NOT NULL Directory object for the directory where the file is stored
FILE_TYPE VARCHAR2(32)   User-specified file type
FILE_SIZE NUMBER   Size of the file
FILE_BLOCK_SIZE NUMBER   Block size for the file
COMMENTS VARCHAR2(4000)   Comments about the file group