Re: Truncate before drop. Any real improvement?

Franky R. wrote:
>
> Hello,
>
> Due to testing with some really big tables (creating, deleting,
> altering and updating involved) sometimes it's needed to drop the full
> table and start again.
> AFAIK, "truncate" is the best way to remove all rows in a table,
> besides, it does not generate undo information.
>
> So, does it make any sense to truncate a big table before dropping it?
> Is there any improvement in deleting a table previously truncated?
>
> Thanks in advance.

In the days of dictionary managed tablespaces, there was occasionally some merit in doing:

• truncate reuse storage
• loop
  • alter table deallocate storage keep ...
• drop table

to keep control of fet$/uet$, but all that should be a thing of the past.

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------