LTM

[Marco]

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?....offl ine....?

Thanks,

Marco

[Mark D Powell]

Re: LTM

themommi@iol.it (Marco) wrote in message news:<1bd20b7d. 0404280214.15da 6afa@posting.go ogle.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?....offl ine....?
>
Thanks,
>
Marco

Marco, once created the size of extents in a tablespace defined as
locally managed using uniform extents is set for the life of the
tablespace. You will have to save off the objects, drop and then
recreate the tablespace to change the extent size.

HTH -- Mark D Powell --