Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Delete fast

Re: Delete fast

From: <mccmx_at_hotmail.com>
Date: 28 Jun 2006 05:43:03 -0700
Message-ID: <1151498583.441431.87530@j72g2000cwa.googlegroups.com>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US