Re: rowid value
- From: Jared Still <jkstill@xxxxxxxxx>
- To: kibeha@xxxxxxxxx
- Date: Fri, 8 Aug 2014 11:23:12 -0700
On Wed, Aug 6, 2014 at 1:15 AM, Kim Berg Hansen <kibeha@xxxxxxxxx> wrote:
> If the idea of deleting the "higher" ROWID is to delete the "newest" row,
> that is not at all certain. But if the rows are identical duplicates, that
> shouldn't matter ;-)
Probably this is already stated somewhere in this thread, but it bears
repeating.
Duplicate refers to PK/UK, not the row.
Identifying which 'duplicate' to delete it not always straight forward.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Sr Oracle DBA at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
