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: About partitioning and undo

Re: About partitioning and undo

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sat, 15 Oct 2005 02:38:04 GMT
Message-ID: <gYZ3f.48868$K91.41279@twister.nyroc.rr.com> 





MTNorman wrote:


> Stefano,

> 

> Do you have global indexes or are all indexes local?  If all indexes

> are local then "drop partition" will work fine.  If you have a global

> index, then truncating the partition first may work better.

> 

> Regards,

> Margaret

> 




"May work better"?



Maybe not?



Are we dealing with lotto here or do we have reasons why?



Anurag
Received on Fri Oct 14 2005 - 21:38:04 CDT












Original text of this message













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