Re: expdp and impdp with schema change

From: Werner Hofmann <>
Date: Tue, 28 Apr 2009 12:26:41 +0200
Message-ID: <gt6mgm$i3d$>

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

Original text of this message