I don't believe you alter a LMT. =20
What we do is a create a new LMT and use ALTER TABLE MOVE to=20
move all tables over. We have a script somewhere that I wrote that=20
goes thru all tables for a given schema and builds a SQL script that=20
contains ALTER TABLE MOVE for all tables in the schema, and REBUILD
for all indexes. This is how we migrate from data-dictionary=20
to LMTs.
Jeff T
thomasje_at_tce.com
-----Original Message-----
From: paquette stephane [mailto:stephane_paquette_at_yahoo.com]
Sent: Thursday, July 27, 2000 4:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Can I changed a locally managed tablespace ?(Sorry
COrrection
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
=E9crit=A0: > Hi Siva,
> Have you tried modifying the uniform extent size of
> a locally managed=20
> tablespace?. I don't think its possible unless you
> recreate the tablespace?.=20
> The minimum extent can be altered for dict
> tablespaces but I am not sure if=20
> the uniform extent size can be altered for locally
> managed tablespaces.
>=20
> Thanks
> Madhavan
> IBM Corporation
>=20
>=20
> >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=20
> >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:=20
> 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
> > >
> > > =3D=3D=3D=3D=3D
> > > Stephane Paquette
> > > DBA Oracle
> > > stephane_paquette_at_yahoo.com
> > > spaquette_at_houra.fr
> > > (33) 01 53 93 06 50
> > >
> > >=20
> __________________________________________________
> > > Do You Yahoo!?
> > > Get Yahoo! Mail - Free email you can access from
> anywhere!
> > > http://mail.yahoo.com/
> > > --
> > > Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> > > INET: stephane_paquette_at_yahoo.com
> > >
> > > Fat City Network Services -- (858) 538-5051=20
> 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).
> > >
> > >
>=20
>
________________________________________________________________________=
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
>=20
> --=20
> Author: Madhavan Amruthur
> INET: mad012000_at_hotmail.com
>=20
> 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).
=3D=3D=3D=3D=3D
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/
--=20
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
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
Received on Fri Jul 28 2000 - 08:11:41 CDT
