Re: Why tablespaces still need coalescing

Good point - it might be in 7.3.4, but
it is possible that it's only in 8.0

Generally, though once the defaults are
set for the tablespace, don't use any
clauses for the individual objects and
you will be okay apart from

    create table as select
    create index
if run in parallel, then you need to set event 10901 (see my web site for an
article on SMON) to stop extent trimming creating havoc.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Gary wrote in message <38C61900.2C673F3D_at_btinternet.com>...


>Is that available on 7.3 ?

>

>Jonathan Lewis wrote:





>> N.B.  Have you also set MINIMUM EXTENT

>> for the tablespace as well is initial, next

>> and pctincrease ?