Re: expdp and impd error: ORA-39013

From: Noons <wizofoz2k_at_gmail.com>
Date: Tue, 12 Oct 2010 23:49:15 -0700 (PDT)
Message-ID: <9c8c171d-2e74-4b3d-ba83-a8254cc54ca6_at_a7g2000prb.googlegroups.com>

On Oct 13, 7:55 am, python <ang..._at_gmail.com> wrote:

> I was able to do this in Oracle10g R2, but this command doesn't work
> in 11gR2.
> Am I missing something?
>

Not a good idea to do this even if possible in 10gr2. There are way too many public views and other objects in the SYSTEM schema for it to be cloned without unintended consequences. If all you want is to move app tables from system tablespace and system ownership to somewhere else, then just expdp/impdp those tables explicitly, rather than the entire SYSTEM schema. Received on Wed Oct 13 2010 - 01:49:15 CDT