Re: Move schema and tablespace

From: michael ngong <mngong_at_yahoo.com>
Date: 27 Feb 2002 12:49:14 -0800
Message-ID: <ecf365d5.0202271249.46e7df2a@posting.google.com>

Peter Sylvester <peters_at_mitre.org> wrote in message news:<3C7CEE7F.70FBF874_at_mitre.org>...
> 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

Just to add to what philip said
use the fromuser touser while importing

Michael Tubuo Ngong(Sr DBA) Received on Wed Feb 27 2002 - 14:49:14 CST