Re: LTM

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 28 Apr 2004 11:38:55 +0100
Message-ID: <408f89bf$0$20509$ed9e5944@reading.news.pipex.net>

"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....?

If you mean can you alter the extent size for the tablespace the answer is not directly. 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.

If you mean can you alter the size of the extents that an object acquires in an LMT with uniform extent management then the answer is no and neither would you want to.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/

Received on Wed Apr 28 2004 - 05:38:55 CDT