Re: Need to rename a tablespace

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/03/15
Message-ID: <38CF990A.2A3E@yahoo.com>#1/1

Sybrand Bakker wrote:
>
> You simply CAN'T rename a tablespace.
> expor/drop/import is the way to go.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> David Van Zandt <dvanzandt_at_iquest.net> wrote in message
> news:38CF31A1.1183D2D3_at_iquest.net...
> > Hi all, I am trying to change a tablespace name in 7.3.4.5, and it looks
> > like I'm SOL. Am I missing something obvious, 'cause the doc CD
> > examples skip over this one....
> >
> > TIA,
> > Dave

A (very) unsupported way is to hack into TS$ .. I wouldn't recommend it but I've seen it done.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Wed Mar 15 2000 - 00:00:00 CST