Re: index rebuilding...

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 5 Feb 2003 22:55:02 +1100
Message-ID: <NP60a.41233$jM5.103756@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. 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.

Regards
HJR Received on Wed Feb 05 2003 - 05:55:02 CST