Re: expdp and impd error: ORA-39013
From: joel garry <joel-garry_at_home.com>
Date: Wed, 13 Oct 2010 09:59:51 -0700 (PDT)
Message-ID: <78c29188-9b28-4bc6-957c-b7e3e54c5727_at_s13g2000prb.googlegroups.com>
On Oct 12, 11:49 pm, Noons <wizofo..._at_gmail.com> wrote:
> 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.
Date: Wed, 13 Oct 2010 09:59:51 -0700 (PDT)
Message-ID: <78c29188-9b28-4bc6-957c-b7e3e54c5727_at_s13g2000prb.googlegroups.com>
On Oct 12, 11:49 pm, Noons <wizofo..._at_gmail.com> wrote:
> 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.
It appears that is what he tried to do, note the parfile he used. The answer may be to use the username/password for expdp as he did for impdp.
jg
-- _at_home.com is bogus. http://www.theage.com.au/travel/passengers-still-waiting-on-virgin-20100927-15u4j.htmlReceived on Wed Oct 13 2010 - 11:59:51 CDT