【正文】 er the name of this object was system generated (Y) or not (N)SECONDARYVARCHAR2(1)Whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N)dba_extentsColumnDatatypeNULLDescriptionOWNERVARCHAR2(30)Owner of the segment associated with the extentSEGMENT_NAMEVARCHAR2(81)Name of the segment associated with the extentPARTITION_NAMEVARCHAR2(30)Object Partition Name (Set to NULL for nonpartitioned objects)SEGMENT_TYPEVARCHAR2(18)Type of the segment: INDEX PARTITION, TABLE PARTITIONTABLESPACE_NAMEVARCHAR2(30)Name of the tablespace containing the extentEXTENT_IDNUMBERExtent number in the segmentFILE_IDNUMBERFile identifier number of the file containing the extentBLOCK_IDNUMBERStarting block number of the extentBYTESNUMBERSize of the extent in bytesBLOCKSNUMBERSize of the extent in Oracle blocksRELATIVE_FNONUMBERRelative file number of the first extent blockdba_tablespacesColumnDatatypeNULLDescriptionTABLESPACE_NAMEVARCHAR2(30)NOT NULLName of the tablespaceBLOCK_SIZENUMBERNOT NULLTablespace block sizeINITIAL_EXTENTNUMBERDefault initial extent sizeNEXT_EXTENTNUMBERDefault incremental extent sizeMIN_EXTENTSNUMBERNOT NULLDefault minimum number of extentsMAX_EXTENTSNUMBERDefault maximum number of extentsPCT_INCREASENUMBERDefault percent increase for extent sizeMIN_EXTLENNUMBERMinimum extent size for this tablespaceSTATUSVARCHAR2(9)Tablespace status: ONLINE OFFLINE READ ONLYCONTENTSVARCHAR2(9)Tablespace contents: UNDO PERMANENT TEMPORARYLOGGINGVARCHAR2(9)Default logging attribute: LOGGING NOLOGGINGFORCE_LOGGINGVARCHAR2(3)Indicates whether the tablespace is under force logging mode (YES) or not (NO)EXTENT_MANAGEMENTVARCHAR2(10)Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY) or locally managed (LOCAL)ALLOCATION_TYPEVARCHAR2(9)Type of extent allocation in effect for the tablespace: SYSTEM UNIFORM USERPLUGGED_INVARCHAR2(3)Indicates whether the tablespace is plugged in (YES) or not (NO)SEGMENT_SPACE_MANAGEMENTVARCHAR2(6)Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO)DEF_TAB_COMPRESSIONVARCHAR2(8)Indicates whether default table pression is enabled (ENABLED) or not (DISABLED) Note: Enabling default table pression indicates that all tables in the tablespace will be created with table pression enabled unless otherwise specified.RETENTIONVARCHAR2(11)Undo tablespace retention: GUARANTEE Tablespace is an undo tablespace with RETENTION specified as GUARANTEEA RETENTION value of GUARANTEE indicates that unexpired undo in all undo segments in the undo tablespace should be retained even if it means that forward going operations that need to generate undo in those segments fail. NOGUARANTEE Tablespace is an undo tablespace with RETENTION specified as NOGUARANTEE NOT APPLY Tablespace is not an undo tablespaceBIGFILEVARCHAR2(3)Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO)dba_data_files ColumnDatatypeNULLDescriptionFILE_NAMEVARCHAR2(513)Name of the database fileFILE_IDNUMBERNOT NULLFile identifier number of the database fileTABLESPACE_NAMEVARCHAR2(30)NOT NULLName of the tablespace to which the file belongsBYTESNUMBERSize of the file in bytesBLOCKSNUMBERNOT NULLSize of the file in Oracle blocksSTATUSVARCHAR2(9)File status: AVAILABLE or INVALID (INVALID means that the file number is not in use, for example, a file in a tablespace that was dropped)RELATIVE_FNONUMBERRelative file numberAUTOEXTENSIBLEVARCHAR2(3)Autoextensible indicatorMAXBYTESNUMBERMaximum file size in bytesMAXBLOCKSNUMBERMaximum file size in blocksINCREMENT_BYNUMBERNumber of tablespace blocks used as autoextension increment. Block size is contained in the BLOCK_SIZE column of the DBA_TABLESPACES view.USER_BYTESNUMBERThe size of the file available for user data. The actual size of the file minus the USER_BYTES value is used to store file related metadata.USER_BLOCKSNUMBERNumber of blocks which can be used by the dataONLINE_STATUSVARCHAR2(7)Online status of the file: SYSOFF SYSTEM OFFLINE ONLINE RECOVERdba_temp_filesColumnDatatypeNULLDescriptionFILE_NAMEVARCHAR2(513)Name of the database temp fileFILE_IDNUMBERFile identifier number of the database temp fileTABLESPACE_NAMEVARCHAR2(30)NOT NULLName of the tablespace to which the file belongsBYTESNUMBERSize of the file (in bytes)BLOCKSNUMBERSize of the file (in Oracle blocks)STATUSCHAR(9)File status: AVAILABLERELATIVE_FNONUMBERTablespacerelative file numberAUTOEXTENSIBLEVARCHAR2(3)Indicates whether the file is autoextensible (YES) or not (NO)MAXBYTESNUMBERmaximum size of the file (in bytes)MAXBLOCKSNUMBERMaximum size of the file (in Oracle blocks)INCREMENT_BYNUMBERDefault increment for autoextensionUSER_BYTESNUMBERSize of the useful portion of the file (in bytes)USER_BLOCKSNUMBERSize of the useful portion of the file (in Oracle blocks)dba_rollback_segsColumnDatatypeNULLDescriptionSEGMENT_NAMEVARCHAR2(30)NOT NULLName of the rollback segmentOWNERVARCHAR2(6)Owner of the rollback segmentTABLESPACE_NAMEVARCHAR2(30)NOT NULLName of the tablespace containing the rollback segmentSEGMENT_IDNUMBERNOT NULLID number of the rollback segmentFILE_IDNUMBERNOT NULLFile identifier number of the file contai