Select Distinct
Sysdate,
S.user # as userid,
u.Name as username,
S.TS # as tablespaceid,
D. TableSpace_name as tablespaceename,
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;
