Re: rowid value
- From: Kim Berg Hansen <kibeha@xxxxxxxxx>
- To: Hemant-K.Chitale@xxxxxx
- Date: Wed, 6 Aug 2014 10:15:53 +0200
Exactly.
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 ;-)
But supposing there are a *lot* of duplicates to remove (someone by mistake
ran a big import job twice, for example), wouldn't always picking "higher"
ROWID to delete be somewhat helpful in that there's a bigger chance of
clearing space by "emptying" blocks?
Regards
Kim Berg Hansen
http://dspsd.blogspot.com
kibeha@xxxxxxxxx
@kibeha
On Wed, Aug 6, 2014 at 9:04 AM, Chitale, Hemant K <Hemant-K.Chitale@xxxxxx>
wrote:
> AAAocvACXAAAPFJAAb is the “higher” ROWID. But it might be holding the
> “older” row.
>
>
>
> Hemant K Chitale
>
>
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Zelli, Brian
> *Sent:* Tuesday, August 05, 2014 11:07 PM
> *To:* oracle-l (oracle-l@xxxxxxxxxxxxx)
> *Subject:* rowid value
>
>
>
> Another dba I’m covering for told me to delete a duplicate with the higher
> rowid?
>
> Which one is the higher rowid? AAAocvACXAAAPFJAAa or AAAocvACXAAAPFJAAb?
>
>
>
>
>
> Brian
>
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
> .
>
Other related posts:
