Re: rowid value
From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 8 Aug 2014 11:23:12 -0700
Message-ID: <CAORjz=PhyyhCaXkEUxKQzkmA1=st4w_LLTFh=d4H0G+=9+ysjA_at_mail.gmail.com>
On Wed, Aug 6, 2014 at 1:15 AM, Kim Berg Hansen <kibeha_at_gmail.com> wrote:
Date: Fri, 8 Aug 2014 11:23:12 -0700
Message-ID: <CAORjz=PhyyhCaXkEUxKQzkmA1=st4w_LLTFh=d4H0G+=9+ysjA_at_mail.gmail.com>
On Wed, Aug 6, 2014 at 1:15 AM, Kim Berg Hansen <kibeha_at_gmail.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 08 2014 - 20:23:12 CEST