DBA Data[Home] [Help]

VIEW: SYS.CDB_DATA_FILES

Source

View Text - Preformatted

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 CONTAINERS("SYS"."DBA_DATA_FILES")
View Text - HTML Formatted

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 CONTAINERS("SYS"."DBA_DATA_FILES")