Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: import fails?

Re: import fails?

From: tmgn <tmgn_at_excite.com>
Date: Tue, 24 Aug 1999 10:26:48 -0400
Message-ID: <37C2ABA8.8174967B@excite.com>


Pls find out what is the default RECORDLENGTH parameter used in HP-UX and specify the same Value while doing the Import onto NT ...

Also Did you transfer the Dump file in Binary mode ? Otherwise the Export file gets corrupted...

-Thiru

David Spaisman wrote:

> 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 - 09:26:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US