Re: Rename Tablespace name

From: Eric Junkermann <eric_at_deptj.demon.co.uk>
Date: Sat, 06 Mar 1999 18:45:17 GMT
Message-ID: <36d46ebf.8480526@news.demon.co.uk>

On Tue, 02 Feb 1999 15:54:49 -0800, Dan Morgan <dmorgan_at_exesolutions.com> wrote:

>> I want to rename tablespace's name, but I have no idea about it.
>> Please anyone tell me the way to rename tablespace.
>
>You can't.

True

>
>But why would you want to. Tablespace names are reasonably meaningless.
>

Tablespaces are places to put things. Every tablespace should, in effect, have a policy statement on what is meant to go in it. The easiest way to do this is to use meaningful names (e.g. app1_large_indexes).

If I was keen enough to change the name, I would find a excuse for a re-org to justify the down-time if any, save the contents, drop and re-create the ts, and reload.

Regards,

Eric Received on Sat Mar 06 1999 - 12:45:17 CST