Re: How to find Space Used???

try this:

select n.file#, n.name, to_char(d.creation_time,'DD/MM/RRRR HH24:MI:SS'), d.bytes, f.fc from v$dbfile n, v$datafile d, (select file_id, sum(bytes) fc from dba_free_space group by file_id) f where n.file#=d.file# and d.file#=f.file_id Received on Thu Mar 01 2001 - 08:52:35 CST