Re: Move objects from one tablespace to another
From: Peter Sylvester <peters_at_mitre.org>
Date: Wed, 27 Feb 2002 09:32:05 -0500
Message-ID: <3C7CEDE5.D569ADE9_at_mitre.org>
Date: Wed, 27 Feb 2002 09:32:05 -0500
Message-ID: <3C7CEDE5.D569ADE9_at_mitre.org>
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 - 15:32:05 CET