Re: Move schema and tablespace

I think this will be more complicated... Basically you will need to export the DDL and create the objects and constraints in the new schema. Then use export/import to move the data.

-Peter

Philip Morrow wrote:
>
> Basically the same question as the previous post but now I also need to put
> the tables and indexs in a different schema and tablespace keeping all the
> constraints and relationships intact.
>
> Thanks again
>
> Phil
Received on Wed Feb 27 2002 - 08:34:39 CST