DBA_DATA_FILES

SQL>DESC DBA_DATA_FILES

 Name                                              Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_NAME                                               VARCHAR2(513)
 FILE_ID                                                         NUMBER
 TABLESPACE_NAME                                   VARCHAR2(30)
 BYTES                                                           NUMBER
 BLOCKS                                                          NUMBER
 STATUS                                                           VARCHAR2(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                    VARCHAR2(3)
 MAXBYTES                                                        NUMBER
 MAXBLOCKS                                                        NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                                       NUMBER
 USER_BLOCKS                                                      NUMBER
 ONLINE_STATUS                                                    VARCHAR2(7)

No comments:

Post a Comment