Re: segment space management used with DMTs

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Thu, 26 Jan 2006 02:01:56 GMT
Message-ID: <o4WBf.227131$V7.65505@news-server.bigpond.net.au>

"serge" <serg78_at_adelphia.net> wrote in message news:1138231819.230175.293480_at_g14g2000cwa.googlegroups.com...
> Hello everyone, here is my question, is it possible to create a DMT
> (dictionary managed tablespace) with the segment space management
> clause (regardless if it's set to auto or manual). Is segment space
> management an applicable feature for DMTs?
>

Hi Serge,

No, ASSM is a feature with LMTs only. The SQL manuals are pretty clear about this:

"The segment_management_clause is relevant only for permanent, locally managed tablespaces".

Cheers

Richard Received on Wed Jan 25 2006 - 20:01:56 CST