Hi,
Truncate table "Tablename" Reuse Storage.
What does Reuse Storage do? Does it keeps the space reserved for the table. Or the table space is released for other tables.
Printable View
Hi,
Truncate table "Tablename" Reuse Storage.
What does Reuse Storage do? Does it keeps the space reserved for the table. Or the table space is released for other tables.
hi akhil,
there r two clauses used in conjuction with TRUNCATE command
1.DROP STORAGE clause
2.REUSE STORAGE Clause
The DROP STORAGE clause (default) is used then the space used by the table beyond the initial extents is returned to the tablespace
The REUSE STORAGE clause is used then the space is retained by the table for reuse.The space freed in the associated indexes is reused as well
Hope this will help u.
pras