935299 wrote:Then you should check out the documentation some more.
What segment space management type is defined for the tablespace in question?
But even if you shrink the table segement what is that going to do for the data file size?Your thread is titled "Table space not reduce after delete in oracle 11G" which implies to me that you are interested in reducing the size of a tablespace (which really means reducing the size of the underlying datafile(s)).
I don't undertand you.
935299 wrote:consider that a table is like a bucket.
I have a tablespace ADDU.
I have a table sys.aud$ on the tablespace ADDUU with 20Gb.
DELETE FROM sys.aud$ where NTIMESTAMP# BETWEEN '31-DEC-07' AND '01-JAN-012';
12368569 rows deleted.
But the tablespace AUDD continue with 20Gb.
How Can I reduce the size of the TB AUDD?