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

Home -> Community -> Usenet -> c.d.o.misc -> error handling during import

error handling during import

From: George D. Benetos <gbenet_at_intranet.gr>
Date: Mon, 22 Apr 2002 12:43:54 +0300
Message-ID: <aa0m3p$qe8$1@newsserv.intranet.gr>


I have the following problem using importng utility when there is a unique constraint , then i get the follwing message ...

if there are many duplicated errors then the log file has a very large size ....

Is there any way that this error mesages are not displayed in the terminal , and only the final message concerning the total number of rows inserted is displayed ???

thanx .........



import done in EL8ISO8859P7 character set and EL8ISO8859P7 NCHAR character set . . importing table "PERF_PTH_NETWORKELEMENT"
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (RTTMS.PC_PTH_NETWORKELEMENT) violated
Column 1 21-DEC-2001:00:30:00
Column 2 37
Column 3 2
Column 4 96
Column 5 50132
Column 6 36462
Column 7 19546
Column 8 30586
Column 9 20098
Column 10 22234
Column 11 84
Column 12 3162
Column 13 16762
Column 14 19572
Column 15 17364
Column 16 19098
Column 17 82
Column 18 2450
Column 19
Column 20
Column 21
Column 22
Column 23
Column 24
Column 25 10475
Column 26
Column 27 11.75
Column 28 20.89
Column 29 28688.5
Column 30 362928.48
Column 31 160952.29
                                                            0 rows imported
About to enable constraints...
Import terminated successfully with warnings.
-- 

---------------------------------------------------------------------------------
George D. Benetos Electrical & Computer Engineer N.T.U.A -------------------------------------------------------------------------
Received on Mon Apr 22 2002 - 04:43:54 CDT

Original text of this message

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