Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate before dropping table>
> In 10g, there may be some benefit to truncating before dropping. With
> the new flashback table & recyclebin. But I'm not real sure, as I
> would think that the recyclebin would still hold the table pre-
> truncate at least until it was aged out.- Hide quoted text -
>
I use the format DROP TABLE XXXX PURGE; to avoid it going to the
recycle bin when I am dropping all the SYSADM tables in PeopleSoft.
Received on Tue May 29 2007 - 12:39:17 CDT