Re: Renaming tablespace

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 04 Sep 1998 06:13:15 GMT
Message-ID: <35ef84ed.374887@news.siol.net>

On Thu, 3 Sep 1998 17:22:53 +0200, "Manu" <ebontemps_at_altern.org> wrote:

>Hi,
>
>Does somebody know if it's possible to rename a tablespace without moving
>including objects ?

Yes it is, but it is unsupported by Oracle, because it involves updating tables owned by SYS.

!!! WARNING: you are doing the following at your own risk !!!!

CONNECT SYS/PWD
UPDATE sys.ts$ SET name='NEW_TS_NAME' WHERE name = 'OLD_TS_NAME';

Restart the database (or at least flush the shared pool).

>Thanks for your tips !
>
>Ciao

HTH,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Sep 04 1998 - 01:13:15 CDT