She has 8i, so there is no need for export and import. A simple 'alter
table X move tablespace Y' will do the deed.
Regards
HJR
--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================
"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message
news:Zk8y7.51$Z16.46077139_at_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 Sun Oct 14 2001 - 15:17:56 CDT
