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
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