Select Distinct SysDate, s.user#As UserID, ;;;;u.name;As UserName, s.ts#;;As TableSpaceID, d.tablespace_name As TableSpaceName, s.FILE#As DataFileID, d.file_name;;;;As DataFileName, d.bytesAs Bytes, d.maxbytes;;;;;As MaxBytes, d.user_bytes;;;As UserBytes, d.autoextensible; As AutoExtensible, d.increment_by;As InCrementBy, d.status; As StatusFrom sys.seg$ s, sys.user$ u, dba_data_files dWhere s.user# = u.user#Ands.file# = d.file_id;