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.bytes As Bytes, d.maxbytes As MaxBytes, d.user_bytes As UserBytes, d.autoextensible As AutoExtensible, d.increment_by As InCrementBy, d.status As Status From sys.seg$ s, sys.user$ u, dba_data_files d Where s.user# = u.user# And s.file# = d.file_id; |