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

VIEW: SYS.CDB_DATA_FILES

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

Information about database data files in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE_NAME VARCHAR2 (513)
Name of the database data file
FILE_ID NUMBER

ID of the database data file
TABLESPACE_NAME VARCHAR2 (30)
Name of the tablespace to which the file belongs
BYTES NUMBER

Size of the file in bytes
BLOCKS NUMBER

Size of the file in ORACLE blocks
STATUS VARCHAR2 (9)
File status: "INVALID" or "AVAILABLE"
RELATIVE_FNO NUMBER

Tablespace-relative file number
AUTOEXTENSIBLE VARCHAR2 (3)
Autoextensible indicator: "YES" or "NO"
MAXBYTES NUMBER

Maximum autoextensible file size in bytes
MAXBLOCKS NUMBER

Maximum autoextensible file size in blocks
INCREMENT_BY NUMBER

Default increment for autoextension
USER_BYTES NUMBER

Size of the useful portion of file in bytes
USER_BLOCKS NUMBER

Size of the useful portion of file in ORACLE blocks
ONLINE_STATUS VARCHAR2 (7)
Online status of the file
CON_ID NUMBER

container id
Query Text

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


SELECT FILE_NAME
,      FILE_ID
,      TABLESPACE_NAME
,      BYTES
,      BLOCKS
,      STATUS
,      RELATIVE_FNO
,      AUTOEXTENSIBLE
,      MAXBYTES
,      MAXBLOCKS
,      INCREMENT_BY
,      USER_BYTES
,      USER_BLOCKS
,      ONLINE_STATUS
,      CON_ID
FROM SYS.CDB_DATA_FILES;

Dependencies

[top of page]

SYS.CDB_DATA_FILES does not reference any database object

SYS.CDB_DATA_FILES is referenced by following:

SchemaPUBLIC
SynonymCDB_DATA_FILES