Re: DML table purging; does partitioning make any difference?

David Van Zandt wrote:
>
> My team is "discussing" alternatives to the question of periodic data
> purges. Options include the old-fashioned removal of obsolete rows from
> tables by the DBA; adding application logic to have a user run a purge
> script; or do some something with partitioned tables, and drop older
> partitions as appropriate. This is not an Oracle app (10.7/11i), just
> home-grown code -- and Metalink fails to address the question.
>
> At this time our tables are not partitioned (gasp). Would converting them
> buy us the ability to simplify the row deletion process?
>
> TIA,
> Dave

Definitely....its just a case of 'alter table xxx drop partition yyy'

if you have local indexes, then thats it. if you have global indexes, then they will need to be rebuilt although 9i has an option to maintain the global indexes as the drop occurs.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."