Re: index rebuilding...

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 06 Feb 2003 06:09:32 +1100
Message-ID: <pan.2003.02.05.19.09.32.309530@yahoo.com.au>

On Wed, 05 Feb 2003 23:42:22 +1000, Richard Foote wrote:

> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:NP60a.41233$jM5.103756_at_newsfeeds.bigpond.com...

>>
>> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
>> news:3e3fb9f6$0$248$ed9e5944_at_reading.news.pipex.net...
>> > "Noons" <nsouto_at_optusnet.com.au.nospam> wrote in message
>> > news:Xns9318EB0C520B9mineminemine_at_210.49.20.254...
>> > > Pete Sharman <peter.sharman_at_oracle.com> wrote in
>> > > news:b1m6e30258f_at_drn.newsguy.com and I quote:
>> > > Has anyone here tried to dump the first extent off a LMT,
>> > > table with just one block of data, 64K uniform alloc, 4096
>> > > block size?  Ie, 16 blocks/extent?  Now, that was a surprise
>> > > for me: Oracle takes an apparently weird choice as to which
>> > > block gets data first!  Weird, I tell you.  :)
>> >
>> > Take a look at http://www.oaktable.net/fullArticle.jsp?id=4 which I

> think

>> > deals with what you are on about about halfway down.
>>
>> It's a good article. But it contains one minor error. Locally-managed

> system

>> tablespaces are NOT the default in 9iR2.

>
> Hi Howard,
>
> Ummmm, yes they are ? If you do not specify an extent management clause, the
> default is LMT, regardless of the System TS.
>

Have another read Richard! 'LMT SYSTEM tablespaces are not the default'.  

>>They are if you use the dbca to
>> create your database (the error I fell into). But issue manual 'create
>> database' commands, and DMT for system is still the default.

>
> This is correct.

Which is all I was saying!

> The default TS for *System* is DMT,

Ok. Compare these two sentences:

"The default TS for System is DMT"
"LMT system tablespaces are not the default"

Now. What's the logical difference between them?

Good.

>but regardless, the

> default for all other tablespaces is LMT.
>

I didn't say otherwise.

HJR  
> Cheers
>
> Richard
Received on Wed Feb 05 2003 - 13:09:32 CST