Re: Automatic Segment-Space Management Segments and LOBs

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 03 Jan 2006 21:16:23 +0000
Message-ID: <i9qlr19uhe25hsq5mqo6ornsj31uggf4ib@4ax.com>

On Wed, 28 Dec 2005 13:27:06 GMT, Mladen Gogala <gogala_at_sbcglobal.net> wrote:

>> As I know, Automatic Segment-Space management can not be used for
>> tablespaces witch will contain LOBs.
>
>And where did you stumble upon this myth?

The 9.0 manual:

http://download-west.oracle.com/docs/cd/A91202_01/901_doc/appdev.901/a88879/adl04m10.htm#98328

"LOBs cannot be stored in tablespaces created with SEGMENT SPACE MANAGEMENT set to AUTO."

They apparently finished implementing it in 9.2 as the restriction was removed.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Tue Jan 03 2006 - 15:16:23 CST