X-Received: by 10.236.4.201 with SMTP id 49mr4580197yhj.47.1400168530919; Thu, 15 May 2014 08:42:10 -0700 (PDT) X-Received: by 10.50.112.135 with SMTP id iq7mr340259igb.0.1400168530720; Thu, 15 May 2014 08:42:10 -0700 (PDT) Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!209.85.213.216.MISMATCH!c1no7371021igq.0!news-out.google.com!qf4ni1808igc.0!nntp.google.com!r10no5001241igi.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Thu, 15 May 2014 08:42:10 -0700 (PDT) In-Reply-To: <02224d05-ee5c-49d1-b245-3594be03217e@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=69.4.5.254; posting-account=KXUmygkAAABvBFmgDBe4RBLFwhTRAMZC NNTP-Posting-Host: 69.4.5.254 References: <02224d05-ee5c-49d1-b245-3594be03217e@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <17575345-d6dc-408a-93a6-026bdb0dd50f@googlegroups.com> Subject: Re: Oracle 11g: problem with datapump From: ddf Injection-Date: Thu, 15 May 2014 15:42:10 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Xref: news.cambrium.nl On Thursday, May 15, 2014 4:00:13 AM UTC-6, Robert Grzesiak wrote: > Welcome, >=20 >=20 >=20 > I have problem with datapump exp/imp using DBMS_DATAPUMP package: >=20 > This problem occures same times, not always in RAC, in cases:=20 >=20 > - start running 1 job exp from DBO schema, next start running 2nd exp job= from the same schema with another SCN >=20 > - parallel runs 2 jobs: exp from DBO schema and imp on the another schema >=20 > - other cases - generally if parallel runs exp and imp jobs on the same t= ime >=20 > errors, for example (not always the same tables): >=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 > ORA-02354: b=C4=B9=E2=80=9A=C3=84=E2=80=A6d podczas eksportowania/importo= wania danych >=20 > ORA-01466: nie mo=C4=B9=C4=BDna odczyta=C3=84=E2=80=A1 danych - definicja= tabeli jest zmieniona >=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 > ORA-02354: b=C4=B9=E2=80=9A=C3=84=E2=80=A6d podczas eksportowania/importo= wania danych >=20 > ORA-01466: nie mo=C4=B9=C4=BDna odczyta=C3=84=E2=80=A1 danych - definicja= tabeli jest zmieniona >=20 >=20 >=20 > I thing that it is same internal problem with datapump with parallel task= s. >=20 > If jobs runs sequentially everything is ok... >=20 >=20 >=20 >=20 >=20 > Regards >=20 > Robert It isn't an internal problem, you are trying to export the same data from t= wo different snapshots at basically the same time. That's what the series of error messages is telling you. David Fitzjarrell