RE: Can I changed a locally managed tablespace ?(Sorry COrrection

Hi Siva,
Have you tried modifying the uniform extent size of a locally managed tablespace?. I don't think its possible unless you recreate the tablespace?. The minimum extent can be altered for dict tablespaces but I am not sure if the uniform extent size can be altered for locally managed tablespaces.

Thanks
Madhavan
IBM Corporation

>From: Siva_Chintalapati <Siva_Chintalapati_at_satyam.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Can I changed a locally managed tablespace ?(Sorry COrrection
>Date: Tue, 25 Jul 2000 10:55:31 -0800
>
> > Hi,
> > U can increase but U can increase in Restricted mode.If U want to
>decrease
> > U have to drop table space and recreate it.
> >
>Regards
>
>Siva Kumar Chintalapati
>GE GDC
>
>Satyam Computer Services Limited
>Tel : +91 40 7846101 Extn 5644
>E mail: siva_chintalapati_at_hht.satyam.com
>
>
>
> > ----------
> > From: Siva_Chintalapati[SMTP:Siva_Chintalapati_at_satyam.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Tuesday, July 25, 2000 11:39 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Can I changed a locally managed tablespace ?
> >
> > Hi,
> > U can increase but U cant increase in Restricted mode.If U want to
> > decrease U have to drop table space and recreate it.
> >
> > ----------
> > From: paquette stephane[SMTP:stephane_paquette_at_yahoo.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Monday, July 24, 2000 8:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Can I changed a locally managed tablespace ?
> >
> > Hi,
> >
> > I've a locally managed tablespace with uniform
> > extents. I want to change the size of the extents.
> > Can I change the size or do I have to drop/recreate
> > the tablespace ?
> >
> > TIA
> >
> > =====
> > Stephane Paquette
> > DBA Oracle
> > stephane_paquette_at_yahoo.com
> > spaquette_at_houra.fr
> > (33) 01 53 93 06 50
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get Yahoo! Mail - Free email you can access from anywhere!
> > http://mail.yahoo.com/
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> > INET: stephane_paquette_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >