Re: Renme Tablespace in 8i

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Sun, 14 Oct 2001 04:16:57 GMT
Message-ID: <Zk8y7.51$Z16.46077139@newssvr13.news.prodigy.com>

"Linda Tuner" <LindaTuner_at_hotmail.com> wrote in message news:ZkAv7.57575$0x.21711673_at_typhoon.southeast.rr.com...
> We have a vendor database that "prefers" that certain objects be in
> certain tablespaces. The manual was not RTF'd and now we have the
> objects in the wrong TS. Is it possible to rename a tablespace in 8i,
> or do we have to do it the hard way?
>
>

Linda,

You can rename datafiles in tablespace but not the tablespace names.

You can export/import the objects from the old tablespace to the new tablespace.

Hope that helps.

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com Received on Sat Oct 13 2001 - 23:16:57 CDT