Re: Extent sizes in LMT

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 5 Jun 2001 13:04:21 +0100
Message-ID: <3b1ccaca$0$12242$ed9e5944@reading.news.pipex.net>

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B1C6AB6.228C6859_at_exesolutions.com...
> > One
> > table's growth rate was severly underestimated and now I'm stuck with
10m
> > extents on a 10g table that's growing at 11m per day. The table is
receiving
> > inserts 24x7 and needs to be available continuously. Any suggestions
would
> > be appreciated.
>
> Create another tablespace with 1GB extents and move the table.

Not in my environment where a datafile should only be a maximum size of 2GB you won't.

Niall Received on Tue Jun 05 2001 - 07:04:21 CDT