import fails?

From: David Spaisman <davedba_at_intercall.net>
Date: Mon, 23 Aug 1999 22:12:51 -0700
Message-ID: <37C229D3.1FF860D5@intercall.net>

Hello:

          I have been in the process of trying to load a full export from a hp-ux

          10.20 oracle 7.3.21 database onto an
          Oracle 8.0.4.00 NT 40. sp4 database via an import.

          I only have the oracle 7.3.21 dump file, the hpux server has
been removed
          so i can't go back and take an export
          by owner only.

          The inport file is using the following parms:

          userid=system/manager_at_FLPD
          file=K:\full_flprod.dmp
          log=E:\orant\bin\fullflpdimp_080499.log
          commit=y
          grants=n
          indexes=y
          buffer=512000
          ignore=y
          fromuser=flprod
          touser=flpd


          The first time I tried the import, it died with login

problems.

          Oracle suggested that this was a bug and it would be fixed in 80430 and

          suggested I use 80440 pathcset.
          After loading the parchset an running the import again, the
import start,
          ran about one-third of the way through
          and then failed with the following:



          "IMP-00017: following statement failed with ORACLE error 2261:





          "ALTER TABLE "T102A" ADD CONSTRAINT "UK_T102A" UNIQUE


("REC_NR") USING
          INDE"


          "X STORAGE (INITIAL 61440 NEXT 20480 MINEXTENTS 1 MAXEXTENTS


249
          PCTINCREASE"


          " 0 FREELISTS 1 ) TABLESPACE "FLPROD_INDEX1""


          IMP-00003: ORACLE error 2261 encountered
          ORA-02261: such unique or primary key already exists in the
table
          . . importing table "T102B"
          IMP-00009: abnormal end of export file
          IMP-00021: operating system error - error code (dec 22, hex
0x16)
          IMP-00018: partial import of previous table completed: 31275
rows imported
          Import terminated successfully with warnings."

          I understand the constraint violations since I forgot to
disable constraints
          but I am baffled by the sudden
          termination, Oracle doesn't have a response yet.

          Has any one ever seen this before? Any suggetions on how I can
the import
          to fully load?

          Any information would be greatly appreciated. Thanks.

          David Spaisman

Received on Tue Aug 24 1999 - 00:12:51 CDT