Re: Deletion Of 160 Million Rows.

On Wed, 9 Feb 2005 07:39:34 -0700, William B Ferguson <wbfergus_at_usgs.gov> wrote:
> Okay, here's another way I thought of (please critique me if I'm wrong
> anywhere). This will eliminate any problems with undo, or archives. Test
...
> 3. Create an INSTEAD_OF trigger for the view, so any insert, update, or
> delete will copy the real record to a temporary table so the action can =
> be

At least one possible pitfall comes to mind.

This would not work well in FK relationships.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l