Re: Challenge: Partitioning is a wrong idea

mikharakiri_nosp..._at_yahoo.com wrote:
>
> Spell it out: what kind of table reorganization do you need. Dropping
a
> partition is a straw man. Anything else?

Straw man? Have you considered the physical effect of dropping large quantities of rows on indices, redo, rollback, buffer cleansing, user response time, controller flooding and latches? Even this guy can come up with more things:
http://www.dba-oracle.com/oracle_tips_partitioning.htm

If you don't need partitioning, don't use it. You might consider reading the concepts manual.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c12parti.htm#460853

jg

--
@home.com is bogus.
Click on the satellite link, my house is the one with the pool at the
end of a long walkway:
http://maps.google.com/maps?q=Vista,CA&ll=33.228394,-117.214026&spn=0.002571,0.004341&hl=en