Madhavan, you must be right, I've tried without
success to change a locally managed tablespace with
uniform extents and found nothing on metalink or in
the doc.
Anybody ?
We're a 24h system and I find that a real pain to
recreate a tablespace.
- Madhavan Amruthur <mad012000_at_hotmail.com> a
écrit : > 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).
> > >
> > >
>
>
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
>
> --
> Author: Madhavan Amruthur
> INET: mad012000_at_hotmail.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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Received on Thu Jul 27 2000 - 03:42:01 CDT
