Re: deleting many rows from a table

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 14 Jan 2010 04:53:40 -0800 (PST)
Message-ID: <2984e474-4c27-43de-a6ef-c2c8e495b09c_at_a15g2000yqm.googlegroups.com>



How about:
1) CREATE table t1 with the same structure and necessary storage definitions
2) INSERT /*+ append */ INTO t1 select only necessary rows
3) drop old table t
4) RENAME t1 to t;

Of course it means, that all privileges should be regranted and dependant procedural units recompiled.

Minimum downtime (only steps 3 and 4) - the only problem is need for extra space and recompile units/regrant privileges.

Gints Plivna
http://www.gplivna.eu Received on Thu Jan 14 2010 - 06:53:40 CST

Original text of this message