Hi ac,

Can you tell me the result of these queries?

select tablespace_name, sum(bytes) free_bytes
from dba_free_space
group by tablespace_name
/

select d.tablespace_name, sum(d.bytes) total_size
from dba_data_files d
group by d.tablespace_name
/

When you create a datafile on disk the space for the datafile is allocated at once on discWhen new no objects are placed in this datafile so in a way it is empty.

Hope this helps.

tycho