Hey,
I have small problem to properly understand and use 'REUSE STORAGE' clause of TRUNCATE TABLE.
I have table my_table which has some data, after gather statistics by:
exec dbms_stats.gather_table_stats('MY_SCHEMA','MY_TABLE');
and then user_tables shows:
| table_name | num_rows | blocks | empty_blocks |
|---|
| my_table | 6 | 5 | 0 |
Then when I do
TRUNCATE TABLE my_table REUSE STORAGE;
next gather stats again then user_tables shows:
| table_name | num_rows | blocks | empty_blocks |
|---|
| my_table | 0 | 0 | 0 |
when I would expect to get all equal to zeros except empty_blocks which should be equal to 5?