Re: Renaming Tablespaces

From: Steve Adams <steveadams_at_acslink.net.au>
Date: 1997/11/25
Message-ID: <347a437d.1572644672@newsserver.trl.oz.au>#1/1

Hi Randy,

You can update sys.ts$ directly, then bounce the instance immediately. Although this works (I have done it) it is NOT officially supported by Oracle.

Regards,
Steve Adams
steveadams_at_acslink.net.au

---

On Wed, 19 Nov 1997 21:44:12 -0800, julienpr_at_erols.com wrote:

>I have been researching the Oracle docs for a way to rename
>tablespaces, but have come to believe that Oracle doesn't support
>it. Short of dropping/recreating the tablespaces, does anyone
>have an alternative?
>
>I am using Oracle 7.3.2.3 on Solaris 2.5.1
>
>thanks!
>
>Randy
Received on Tue Nov 25 1997 - 00:00:00 CST