Re: Table with ~255+ columns

Sayan,

I'd forgotten that little gem in the pdf you listed. It reminded me of the little quiz I posted:
https://jonathanlewis.wordpress.com/2012/03/30/quiz-night-17

I've just been following up the MOS reference in the comments - with the increasingly common result that I've found bug notes and SRs disappearing, or articles that were relevant 20 years ago being labelled with a very recent "last major update" date, but containing no new information since 9i.

Wondering if there were any fixes backported from the 12.2 to 11.2.0.4 - there are people running SE that probably won't ever want to upgrade to 12c because of the new restrictions in SE2, but could run into trouble with 11g bugs.

Regards
Jonathan Lewis

On Thu, 19 Nov 2020 at 00:40, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:

> Hi Lok,
>
> As I see you are on 11.2.0.4 now. So first of all, I would suggest you to
> upgrade to at least oracle 12.2, since intra-block row chaining doesn't
> work for updates before 12.2:
> http://orasql.org/2017/02/12/intra-block-row-chaining/
> http://orasql.org/2017/06/17/intra-block-row-chaining-optimization-in-12-2/
>
> http://orasql.org/wp-content/uploads/2017/04/Intra-block-row-chainingRuOUG.pdf
> The last example in the presentation above shows how just 1 row has been
> split into 101 blocks.
> So any updates of null values in the end of rows you ran before split row
> into another block.
>
>
> --
> Best regards,
> Sayan Malakshinov
> Oracle ACE Associate
> Oracle DB Developer Choice Award winner
> http://orasql.org
>

--
http://www.freelists.org/webpage/oracle-l