Re: deleting many rows from a table

From: Gints Plivna <>
Date: Thu, 14 Jan 2010 04:53:40 -0800 (PST)
Message-ID: <>

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 Received on Thu Jan 14 2010 - 06:53:40 CST

Original text of this message