Re: expdp and impdp with schema change
From: Werner Hofmann <superomega_at_t-online.de>
Date: Tue, 28 Apr 2009 12:26:41 +0200
Message-ID: <gt6mgm$i3d$1_at_svr7.m-online.net>
Werner Hofmann wrote:
Date: Tue, 28 Apr 2009 12:26:41 +0200
Message-ID: <gt6mgm$i3d$1_at_svr7.m-online.net>
Werner Hofmann wrote:
> Hallo,
>
> I have a full pump of a db with schema s1.
> Now I want to make a impdp to the same database but to schema s2.
> Is this possible to do?
>
> Werner
Ths solution:
impdp <import description> remap_schema=old_schema:new_schema
In my case this was working except the types were not imported. This could be, because I use Oracle 10.1
Werner Received on Tue Apr 28 2009 - 05:26:41 CDT