Re: Datawarehousing using Oracle8i over multiple servers

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 9 Sep 1999 10:29:56 +0100
Message-ID: <936870045.21149.0.nnrp-04.9e984b29@news.demon.co.uk>

There is a structural change in how LOBs are stored between 8.0 and 8.1 - in 8.0 there is a separate segment for the LOB index which you put in its own tablespace. In 8.1 the lob index is embedded in the lob segment - so only one segment and only one tablespace for all the lob parts. I don't know what the upgrade cost (in effort) might be.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Alex Hudghton wrote in message <7r7pph$ljb$1_at_taliesin.netcom.net.uk>...
>
>Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message
>news:936862801.21872.1.nnrp-02.9e984b29_at_news.demon.co.uk...
><snip>
>> When using LOBS (and you had better use 8.1 from
>> the start) you are likely to end up with 3 tablespaces
>> per 'set' of files -
>>
>
>Jonathan - why the suggestion to use 8.1 for LOBS ???
>
>
>Alex
>
>
Received on Thu Sep 09 1999 - 04:29:56 CDT