X-Received: by 10.236.128.112 with SMTP id e76mr6575468yhi.38.1400226838777; Fri, 16 May 2014 00:53:58 -0700 (PDT) X-Received: by 10.140.101.111 with SMTP id t102mr298221qge.5.1400226838666; Fri, 16 May 2014 00:53:58 -0700 (PDT) Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!85.12.40.131.MISMATCH!xlned.com!feeder3.xlned.com!news.glorb.com!c1no7897172igq.0!news-out.google.com!qf4ni2012igc.0!nntp.google.com!r10no5310433igi.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Fri, 16 May 2014 00:53:58 -0700 (PDT) In-Reply-To: <17575345-d6dc-408a-93a6-026bdb0dd50f@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=195.245.84.100; posting-account=IUeF4goAAAAmZ9JWqbQ_yttnXC0-YQep NNTP-Posting-Host: 195.245.84.100 References: <02224d05-ee5c-49d1-b245-3594be03217e@googlegroups.com> <17575345-d6dc-408a-93a6-026bdb0dd50f@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: Oracle 11g: problem with datapump From: Robert Grzesiak Injection-Date: Fri, 16 May 2014 07:53:58 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Xref: news.cambrium.nl W dniu czwartek, 15 maja 2014 17:42:10 UTC+2 u=C5=BCytkownik ddf napisa=C5= =82: > On Thursday, May 15, 2014 4:00:13 AM UTC-6, Robert Grzesiak wrote: >=20 > > Welcome, >=20 > >=20 >=20 > >=20 >=20 > >=20 >=20 > > I have problem with datapump exp/imp using DBMS_DATAPUMP package: >=20 > >=20 >=20 > > This problem occures same times, not always in RAC, in cases:=20 >=20 > >=20 >=20 > > - start running 1 job exp from DBO schema, next start running 2nd exp j= ob from the same schema with another SCN >=20 > >=20 >=20 > > - parallel runs 2 jobs: exp from DBO schema and imp on the another sche= ma >=20 > >=20 >=20 > > - other cases - generally if parallel runs exp and imp jobs on the same= time >=20 > >=20 >=20 > > errors, for example (not always the same tables): >=20 > >=20 >=20 > >=20 >=20 > >=20 >=20 > > ORA-31693: Nie uda=C4=B9=E2=80=9Ao si=C3=84=E2=84=A2 wczyta=C3=84=E2=80= =A1/usun=C3=84=E2=80=A6=C3=84=E2=80=A1 z pami=C3=84=E2=84=A2ci obiektu "DBO= "."SYSYSPAR" danych tabeli; obiekt jest pomijany wskutek b=C4=B9=E2=80=9A= =C3=84=E2=84=A2du: >=20 > >=20 >=20 > > ORA-02354: b=C4=B9=E2=80=9A=C3=84=E2=80=A6d podczas eksportowania/impor= towania danych >=20 > >=20 >=20 > > ORA-01466: nie mo=C4=B9=C4=BDna odczyta=C3=84=E2=80=A1 danych - definic= ja tabeli jest zmieniona >=20 > >=20 >=20 > >=20 >=20 > >=20 >=20 > > ORA-31693: Nie uda=C4=B9=E2=80=9Ao si=C3=84=E2=84=A2 wczyta=C3=84=E2=80= =A1/usun=C3=84=E2=80=A6=C3=84=E2=80=A1 z pami=C3=84=E2=84=A2ci obiektu "PRO= C"."PRREL_R" danych tabeli; obiekt jest pomijany wskutek b=C4=B9=E2=80=9A= =C3=84=E2=84=A2du: >=20 > >=20 >=20 > > ORA-02354: b=C4=B9=E2=80=9A=C3=84=E2=80=A6d podczas eksportowania/impor= towania danych >=20 > >=20 >=20 > > ORA-01466: nie mo=C4=B9=C4=BDna odczyta=C3=84=E2=80=A1 danych - definic= ja tabeli jest zmieniona >=20 > >=20 >=20 > >=20 >=20 > >=20 >=20 > > I thing that it is same internal problem with datapump with parallel ta= sks. >=20 > >=20 >=20 > > If jobs runs sequentially everything is ok... >=20 > >=20 >=20 > >=20 >=20 > >=20 >=20 > >=20 >=20 > >=20 >=20 > > Regards >=20 > >=20 >=20 > > Robert >=20 >=20 >=20 > It isn't an internal problem, you are trying to export the same data from= two different snapshots at basically the same time. >=20 >=20 >=20 > That's what the series of error messages is telling you. >=20 >=20 >=20 >=20 >=20 > David Fitzjarrell Exactly: I'm starting expdp 1 with slashback_scn 1 and after few/several mi= nutes I'm starting expdp 2 with slashback_scn 2, because next, using impdp = I need 2 different new schemas with the specified scn's state. But... Why I can't do it parallely ? Is there any restriction in flashback = mechanism on it ? If I do it sequentially: exp1 on scn1 and next after fini= shing start exp2 on scn2 - everything is ok. Regards Robert