locally managed tablespace - autoallocate

I am using Oracle9i on HP UNIX 11i. I have a locally managed tablespace with auto allocate extent size (instead of uniform size). Which data dictionary view will show me what is the size of next extent for a table. I know next extent size is determined by an internal Oracle algorithm, but where in the data dictionary it is shown.

I want to write a script to find whether my datafile has enough space for next 2 extents for any table in the tablespace. I have scripts to find this in dictionary managed tablespace, but struggling how to modify them to LMT with autoallocate option.

Prem Received on Wed Dec 08 2004 - 20:05:07 CST