Originally posted by mrvajrala
Since this is a LOCALLY Managed tablespace , you can not check the DBA_FREE_SPACE for the un used space.
....SNIP.....
That's not true, I think you've confused that with localy managed temporary tablespace! For other permanent localy managed tablespaces DBA_FREE_SPACE still works the same way as in the old days.