Re: Move objects from one tablespace to another

There is a variant of "alter table" that does this, at least with 8.1.7. -Peter

Philip Morrow wrote:
>
> I need to move all the objects from one tablespace to another but keeping
> them in the same schema. Is there an easy way to do this. I'd like all the
> constraints and relationships to remain intact.
>
> Thanks for the help
>
> Phil
Received on Wed Feb 27 2002 - 08:32:05 CST