On May 7, 2008, at 9:51 AM, Martin Bowes wrote:
> BTW. Expanding to 8k will probably buy me another year before I'm
> in this problem again … on this column. Can I make the etab a
> partitioned table?
>
>
>
No.
But etabs are supposed to ac***ulate if one fills up. Obviously that
is not
working, which would be a bug.
Also, I think I recall discovering that etabs on a partitioned base
table aren't quite right -- each partition gets its own etab, but
all the blob data goes into the partitioned master's etab, which
certainly wasn't what I had in mind originally. It's been
a while since I poked around with blobs in a partitioned
table, though.
You might want to go to 16K pages, or larger, instead of 8.
Karl


|