Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete fast
> All the alternatives mean
> to copy
> the table to a new table and recreate indexes, for this table we don't
> have enough
> space to do it, so time to accomplish it is the only problem.
>
> Thanks anyway,
My 'alternative' doesn't require any more space...
Just drop all the indexes before your delete and re-create them after.... this doesn't require any more space than you are using now..
Mattt Received on Wed Jun 28 2006 - 07:43:03 CDT