Hi Greg,
Thanks. But we do not want to pay another $ 200K for the partioning
license.
Vasu
Greg Moore wrote:
> If you have purchased the partitioning option, you may be able to partition
> the table in a way that will allow you to drop the partition that contains
> all the rows you want to delete. It's much faster to drop a partition
> containing 400K rows than to delete 400K rows.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
begin:vcard
n:Ramasamy;Vasu
tel;fax:650 859 3668
tel;work:650 859 4818
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:Principal Database Administrator
fn:Vasu Ramasamy
end:vcard
