Message-Id: <10704.124049@fatcity.com> From: "Mohan, Ross" Date: Fri, 8 Dec 2000 11:24:42 -0500 Subject: OT RE: Changing the name of a tablespace with Oracle ? 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_01C06133.5E85D770 Content-Type: text/plain; charset="iso-8859-1" I CAN'T Tear up my Oracle Support Contract...it's TOO important! I am using it for toilet paper in case we run out. I knew I could REALLY count on it for something! -----Original Message----- From: Rachel Carmichael [mailto:carmichr@hotmail.com] Sent: Friday, December 08, 2000 10:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Changing the name of a tablespace with Oracle ? Well you could do this I suppose.... you could also just tear up your support contract, as Oracle Support doesn't usually deal with people who update the SYS tables without explicit instructions. I *can* shoot myself in the foot...... but would I want to? >From: "Shreepad Vaidya" >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: RE: Changing the name of a tablespace with Oracle ? >Date: Thu, 07 Dec 2000 21:20:20 -0800 > > > >Hi , >I agree that there is no normal method to rename a tablespace in >Oracle . > >But i also agree with the method jorma tried out. > >I created a user . Assigned a default tablespace and created a table . > >updated the column "name" in sys.ts$ . > >Checked out the dba_tables . This showed the changed value for the >tablespace for the corresponding table. >Also checked dba_segments . This also showed the appropriate new >value. > >So it should be accepted that it can be done............ > >I guess dba_tables , dba_segments picks up data from sys.ts$. > > >HTH > > shreepad. > > > > >To: Shreepad Vaidya/EMEA/ALLTELCORP, ORACLE-L@fatcity.com AT > INTERNET@CCMAIL >cc: > > > >Hello Yannick !! How is going in Grenoble ? > >For You question: > >No, it's not possible by Oracle supported way. > >Of course, You can update column "name" of the data dictionary >table sys.ts$ if You want excitement in Your life. Done before >in my test db and it works fine :), but I don,t recommend it. > >Br.Jorma >----------------------------------------------------------------- >Name: Jorma Vuorio Phone: +358-9-511 68043 >Company: Nokia Networks Fax: +358-9-511 68050 >Address: P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND >Internet: jorma.vuorio@nokia.com Mobile: +358-40-522 8532 >----------------------------------------------------------------- > > > > -----Original Message----- > > From: EXT Yannick Tireford [mailto:yannick_tireford@hp.com] > > Sent: 06 December, 2000 16:56 > > To: Multiple recipients of list ORACLE-L > > Subject: Changing the name of a tablespace with Oracle ? > > > > > > Hello, > > > > does anybody know if there is a way to change the name of an >already > > created tablespace ? Oracle version is 8.0.6. > > > > Thanks, > > > > Yannick > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yannick Tireford > > INET: yannick_tireford@hp.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@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). > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: Jorma.Vuorio@nokia.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@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). > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Shreepad Vaidya > INET: Shreepad.Vaidya@alltel.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@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 more from the Web. FREE MSN Explorer download : http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr@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@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_01C06133.5E85D770 Content-Type: text/html; charset="iso-8859-1" OT RE: Changing the name of a tablespace with Oracle ?

I CAN'T Tear up my Oracle Support Contract...it's
TOO important!  I am using it for toilet paper in
case we run out.

I knew I could REALLY count on it for something!

-----Original Message-----
From: Rachel Carmichael [mailto:carmichr@hotmail.com]
Sent: Friday, December 08, 2000 10:18 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Changing the name of a tablespace with Oracle ?


Well you could do this I suppose.... you could also just tear up your
support contract, as Oracle Support doesn't usually deal with people who
update the SYS tables without explicit instructions.

I *can* shoot myself in the foot...... but would I want to?


>From: "Shreepad Vaidya" <Shreepad.Vaidya@alltel.com>
>Reply-To: ORACLE-L@fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
>Subject: RE: Changing the name of a tablespace with Oracle ?
>Date: Thu, 07 Dec 2000 21:20:20 -0800
>
>
>
>Hi ,
>I agree that there is no normal method to rename a tablespace in
>Oracle .
>
>But  i also agree with the method jorma tried out.
>
>I created a user . Assigned a default tablespace and created a table .
>
>updated the column "name"  in sys.ts$ .
>
>Checked out the dba_tables . This showed the changed value for the
>tablespace  for the corresponding table.
>Also checked dba_segments .  This also showed the appropriate new
>value.
>
>So it should be accepted that it can be done............
>
>I guess dba_tables , dba_segments picks up data from sys.ts$.
>
>
>HTH
>
>                shreepad.
>
>
>
>
>To:   Shreepad Vaidya/EMEA/ALLTELCORP, ORACLE-L@fatcity.com AT
>       INTERNET@CCMAIL
>cc:
>
>
>
>Hello Yannick !! How is going in Grenoble ?
>
>For You question:
>
>No, it's not possible by Oracle supported way.
>
>Of course, You can update column "name" of the data dictionary
>table sys.ts$ if You want excitement in Your life. Done before
>in my test db and it works fine :), but I don,t recommend it.
>
>Br.Jorma
>-----------------------------------------------------------------
>Name:     Jorma Vuorio                   Phone:  +358-9-511 68043
>Company:  Nokia Networks                 Fax:    +358-9-511 68050
>Address:  P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND
>Internet: jorma.vuorio@nokia.com         Mobile: +358-40-522 8532
>-----------------------------------------------------------------
>
>
> > -----Original Message-----
> > From: EXT Yannick Tireford [mailto:yannick_tireford@hp.com]
> > Sent: 06 December, 2000 16:56
> > To: Multiple recipients of list ORACLE-L
> > Subject: Changing the name of a tablespace with Oracle ?
> >
> >
> > Hello,
> >
> >   does anybody know if there is a way to change the name of an
>already
> > created tablespace ? Oracle version is 8.0.6.
> >
> > Thanks,
> >
> >    Yannick
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Yannick Tireford
> >   INET: yannick_tireford@hp.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@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).
> >
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   INET: Jorma.Vuorio@nokia.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@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).
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Shreepad Vaidya
>   INET: Shreepad.Vaidya@alltel.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@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 more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: carmichr@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@fatcity.com (note EXACT spelling of 'ListGuru') and in