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

From: Siva_Chintalapati <Siva_Chintalapati_at_satyam.com>
Date: Thu, 27 Jul 2000 22:26:30 +0530
Message-Id: <10571.113143@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF7EB.A102CA80
Content-Type: text/plain;

charset="iso-8859-1"

Hi,
U R right.I have extended the size of a DataFile but not extent size.

Regards
Sia

> ----------
> From: Madhavan Amruthur[SMTP:mad012000_at_hotmail.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, July 27, 2000 8:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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).
> > >
> > >
>
> ________________________________________________________________________
> 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).
>

------_=_NextPart_001_01BFF7EB.A102CA80
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">
<TITLE>RE: Can I changed a locally managed tablespace ?(Sorry = COrrection</TITLE>
</HEAD>
<BODY>

Hi, U R right.I have = extended the size of a DataFile but not extent size.

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Sia</FONT>
</P>
<BR>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Madhavan =

Amruthur[SMTP:mad012000_at_hotmail.com] Reply To: =       ORACLE-L_at_fatcity.com
 Sent:   = Thursday, July 27, 2000 8:24 = AM
 To: =     Multiple = recipients of list ORACLE-L
 Subject: =        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.

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Madhavan</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">IBM Corporation</FONT>
</P>
<BR>

>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

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Hi,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; U can increase but U can =

increase in Restricted mode.If U want to >decrease > > U have to drop table space = and recreate it.

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Regards</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Siva Kumar Chintalapati</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;GE GDC</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Satyam Computer Services =

Limited
 >Tel    : +91 40 7846101 = Extn 5644
 >E mail: = siva_chintalapati_at_hht.satyam.com

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; ----------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; 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 ?

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Hi,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; 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

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; the tablespace ?</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; &nbsp;&nbsp;&nbsp; =

TIA
 > > > >     = =3D=3D=3D=3D=3D

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Stephane Paquette</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; DBA Oracle</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; =
stephane_paquette_at_yahoo.com</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; spaquette_at_houra.fr</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; (33) 01 53 93 06 50</FONT>

> > > >     =

__________________________________________________</FONT>

> > Do You Yahoo!? > > Get Yahoo! Mail - Free = email you can access from anywhere! > > <A = HREF=3D"http://mail.yahoo.com/" =
TARGET=3D"_blank">http://mail.yahoo.com/</A> > > -- > > Author: = =3D?iso-8859-1?q?paquette=3D20stephane?=3D

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;&nbsp;&nbsp; INET: =
stephane_paquette_at_yahoo.com</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; &nbsp;&nbsp;&nbsp; Fat City =

Network Services    -- (858) 538-5051  FAX: (858) = 538-5051
 > > San Diego, = California        -- Public Internet = access / Mailing Lists
 > > =

--------------------------------------------------------------------</FO=

NT>
 > > 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

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; (or the name of mailing =
list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; also send the HELP command =

for other information (like subscribing).

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
</P>

<FONT SIZE=3D2 =

FACE=3D"Arial">_________________________________________________________=

_______________
 Get Your Private, Free E-mail from = MSN Hotmail at <A HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A>

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Madhavan Amruthur</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

mad012000_at_hotmail.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 = Received on Thu Jul 27 2000 - 11:56:30 CDT