Re: LTM

Hi Niall,

>> 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....?
>If you mean can you alter the extent
>size for the tablespace

exactly...

>the answer is not directly.

ok.. I supposed this...

>You could I suppose use the DBMS_SPACE_ADMIN
>package to migrate the tablespace from
>local to dictionary managed and then back again
>with a different uniform size, but
>you'd be better off creating a new ts
>with the appropriate storage clause
>and moving objects to it.

and the "Reorganize" of the menu item "Tablespace Map..." of the OEM.... how does it work?

Thanks very much!,

Marco. Received on Wed Apr 28 2004 - 09:27:31 CDT