Re: Is it possible to rename a tablespace ?

From: Norman Dunbar <Oracle_at_MSSQLBountifulSolutions.co.uk>
Date: Sun, 24 Aug 2003 22:07:09 +0000
Message-ID: <bib98l$hqt$1$8302bc10@news.demon.co.uk>

Daniel Morgan wrote:

> Luigi wrote:
>

>> Dear all,
>> I'd like to know if it's possible to rename a tablespace with Oracle 9i.
>> Thanks a lot
>> Luigi

>
> No. But I wonder why you would care. Tablespace names are absolutely
> irrelevant. Not a single piece of application SQL will ever mention a
> tablespace name: Just ignore it.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)

Hi Daniel,

On the contrary I'm afraid. It *shouldn't* be hard coded, but I know of at least two applications (written by the same company actually) which do hard code the tablespace names.

However, assuming you have a tablespace called FRED then this works in 8.0 (I havent tested it in later versions) :

CREATE SYNONYM BARNEY FOR FRED; Unfortunately, you cannot then CREATE TABLE ..... TABLESPACE BARNEY;

Shame :o)

Cheers,
Norman. (At home lurking :o)

-- 
Remove a certain other database to reply :o)

Received on Sun Aug 24 2003 - 17:07:09 CDT