Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Challenge: Partitioning is a wrong idea
mikharakiri_nosp..._at_yahoo.com wrote:
> delete from sales_history
> where txn_date < ...
BTW, what happens if some partition-unaware user issues this statement on a partitioned table? Would it
i. drop the partitions in the range
ii. truncate them, or
iii. do "normal" delete from the relevant partitions
? Received on Thu Apr 07 2005 - 14:11:36 CDT