Re: Deletion Of 160 Million Rows.
- From: Jared Still <jkstill@xxxxxxxxx>
- To: wbfergus@xxxxxxxx
- Date: Wed, 9 Feb 2005 13:11:23 -0700
On Wed, 9 Feb 2005 07:39:34 -0700, William B Ferguson <wbfergus@xxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
