Re: Renme Tablespace in 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 6 Oct 2001 12:16:38 +0200
Message-ID: <trtmo3ljapr538@news.demon.nl>

"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?
>
>

The hard way?!:
alter table <table_name> move <new_tablespace> provided the compatible parameter is at least 8.1.0 and not 8.0.5 (which is the default for 8i)

Regards,

Sybrand Bakker Bakker, Senior Oracle DBA Received on Sat Oct 06 2001 - 05:16:38 CDT