Re: Moving tables/indexes from one tablespace to another

depends what version you are one

> 8i yes its easy

alter table xxx move tablespace yyy;
alter index zzz rebuild tablespace zzz;

On 6/14/05, John Dunn <jdunn_at_sefas.com> wrote:
> Is there any easy way to move tables and indexes from one tablespace to
> another, other than dropping and recreateing?
>=20
> John

--
http://www.freelists.org/webpage/oracle-l