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

VIEW: SYS.CDB_FILE_GROUPS

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

Details about file groups in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE_GROUP_OWNER VARCHAR2 (30) Yes Owner of the file group
FILE_GROUP_NAME VARCHAR2 (30) Yes Name of the file group
KEEP_FILES VARCHAR2 (1) Yes Should on-disk files be purged when removed?
MIN_VERSIONS NUMBER
Yes Minimum number of versions to keep
MAX_VERSIONS NUMBER
Yes Maximum number of versions to keep
RETENTION_DAYS NUMBER
Yes Keep versions at least this number of days
CREATED TIMESTAMP(6) WITH TIME ZONE (13) Yes When the file group was created
COMMENTS VARCHAR2 (4000)
User specified comment
DEFAULT_DIRECTORY VARCHAR2 (128)
Default directory object
CON_ID NUMBER

container id
Query Text

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


SELECT FILE_GROUP_OWNER
,      FILE_GROUP_NAME
,      KEEP_FILES
,      MIN_VERSIONS
,      MAX_VERSIONS
,      RETENTION_DAYS
,      CREATED
,      COMMENTS
,      DEFAULT_DIRECTORY
,      CON_ID
FROM SYS.CDB_FILE_GROUPS;

Dependencies

[top of page]

SYS.CDB_FILE_GROUPS does not reference any database object

SYS.CDB_FILE_GROUPS is referenced by following:

SchemaPUBLIC
SynonymCDB_FILE_GROUPS