Re: index rebuilding...

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<pan.2003.02.05.19.09.32.309530_at_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
>

Hi Howard,

I totally missed the first word "SYSTEM" when you said "LMT SYSTEM tablespaces are not the default" which kinda changes its meaning somewhat.

There's really only one thing I can say in a situation like this and that's to say "OOOpppppsssss".

And sorry ;)

Richard Received on Wed Feb 05 2003 - 18:17:19 CST