Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: LTM

Re: LTM

From: Richard A Foote <richard.foote_at_tbigpond.nospam.com>
Date: Thu, 29 Apr 2004 09:42:20 GMT
Message-ID: <064kc.3553$TT.2858@news-server.bigpond.net.au>


Comments embedded

"Marco" <themommi_at_iol.it> wrote in message news:1bd20b7d.0404282214.6776c9da_at_posting.google.com...
> Hi Richard,
>
> First of all, thank you for the reply.
>
> >> 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....?
>
> >No, for the simple reason that if you could,
> >all the extents wouldn't be
> >very uniform anymore.
> I would like to alter all extents, pre-existents included.

Hi Marco,

Let's just think this through a little...

If you want to change the uniform size from 512K to 3M, what about:

In short, how can Oracle efficiently convert a tablespace that has 512K chunks of allocated storage for all it's objects and 512K chunks of free fragmented space suddenly into 3M chunks of space ?

In short it can't.

>
> I have only write wrong DDL..... "uniform size 512K" instead of
> "uniform size 3M" and I searched for the "best" way to remedy ;-)
> (the tablespace already contains data segments)

The only way to do this would be to create a tablespace with the required uniform size and "move" all the segments across to this tablespace. Note you can't even use Niall's suggestion, as by increasing the required uniform size, it's extremely unlikely that 3M would be a low enough denominator to make the conversion possible.

So MOVE, CTAS, export/import etc. from one tablespace to the other is the way to go (which BTW is what OEM does under the covers).

>
> thank you very much and excuse me for my awful English language.....

It's better than my Italian.

Cheers

Richard Received on Thu Apr 29 2004 - 04:42:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US