Re: LTM

From: Richard A Foote <richard.foote_at_tbigpond.nospam.com>
Date: Wed, 28 Apr 2004 12:38:37 GMT
Message-ID: <hBNjc.2552$TT.123@news-server.bigpond.net.au>

"Marco" <themommi_at_iol.it> wrote in message news:1bd20b7d.0404280211.10dbac4c_at_posting.google.com...
> Hi all,
>
> I have a newbie question for Oracle DBA.
>
> If I have a LTM (Locally Managed Tablespace) defined with "uniform
> size", is it possible to alter the size (of the extents...) via
> sqlplus (without OEM) ?
>
> Is't possible online?....offline....?
>

Hi Marco,

No, for the simple reason that if you could, all the extents wouldn't be very uniform anymore.

Therefore, choose wisely.

Or use autoallocate ...

Cheers

Richard Received on Wed Apr 28 2004 - 07:38:37 CDT