RE: Changing the name of a tablespace with Oracle ?

Do you really think you know how Oracle internally maintains the data dictionary?

Manually changing the data dictionary without the supervision of OWS is foolish, and will likely cause you much grief later.

Don't do it to any database you value.

Jared

On Thu, 7 Dec 2000, Shreepad Vaidya wrote:

>
>
> 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_at_fatcity.com AT
> INTERNET_at_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_at_nokia.com Mobile: +358-40-522 8532
> -----------------------------------------------------------------
>
>
> > -----Original Message-----
> > From: EXT Yannick Tireford [mailto:yannick_tireford_at_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_at_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_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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Jorma.Vuorio_at_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_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).
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shreepad Vaidya
> INET: Shreepad.Vaidya_at_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_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).
Received on Fri Dec 08 2000 - 11:00:02 CST