Hi All,
After a long time i have to take dbasupport guru's advice, so i am here....

Create tablespace t1 datafile 'C:\TEST.DBF'
size 11M autoextend on next 1M maxsize unlimited
extent management local uniform size 10M
/
Create tablespace t2 datafile 'C:\TEST2.DBF'
size 3072M autoextend on next 201M maxsize unlimited
extent management local uniform size 1024M
/

select tablespace_name,bytes from dba_free_space
/
TABLESPACE_NAME BYTES
--------------- --------
T1 (datafile_size - 1M)
T2 (datafile_size - 1024M)

I wonder, is this is normal behaviour ?
I can understand with t1, but why T2 should freeze 1GB ?
For a new table (lesser of 3GB , enough to give room for bitmap maintanance ) being created in T2 is resulting in extending the datafile instead of using current 3GB space.

Is this is a bug or something in 9.2.0.2.1 or did i missed any basics.

Thanx in advance
Jr.