Hello,

I am running the following 2 queries.

1. select tablespace_name,sum(bytes) bytes from dba_data_files
where tablespace_name like 'CZ%'
group by tablespace_name;

Result:
TABLESPACE_NAME BYTES
------------------------------ ----------
CZD 20971520
CZX 26214400

2. select tablespace_name,max(bytes) lgstcont, sum(bytes) bytes, count(*)
fs_extents from dba_free_space
where tablespace_name like 'CZ%'
group by tablespace_name;

Result:
TABLESPACE_NAME LGSTCONT BYTES FS_EXTENTS
------------------------------ ---------- ---------- ----------
CZX 1187840 1187840 1

I am not sure why the CZD tablespace is not listed in the second query. Can
anybody throw some light on this ?

Regards,
Dhilip Ranganathan.
Oracle LazyDBA home page