really? Empty Datafile/Tablespace? and RESIZE ???

Hi.
Someone of our developers wants to Resize automatically the Datafiles which are assigned to his application .
Not that i like his idea, but I need your help to proof that he perhaps does things you should not do.
There are n tables where some contain LOBS. Then ALL tables are "truncated".
The datafile should then be empty.
But the ALTER TABLE ... RESIZE gets the "data beyond" error. There should not be any more data.
Is that because Oracle has some internal things stored? Is that because LOBS go different? Is the space for them not really freed? Are there some internals?
Don't misunderstand me, I want to have hints to be able to proof that the resize is not good (not only because of later performance reasons etc.) or sometimes not possible. This guy complained this must be a bug of Oracle, I think it is not, because Oracle must have the freedom of organizing it's space by itself.

Thank you in advance ,
please excuse my bugs in writing, i am no native english person. Ric Received on Wed Dec 12 2001 - 16:46:50 CET