469,284 Members | 2,507 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,284 developers. It's quick & easy.

LTM

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

Thanks,

Marco
Jul 19 '05 #1
1 2040
th******@iol.it (Marco) wrote in message news:<1b**************************@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....?

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 --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.