error handling during import
From: George D. Benetos <gbenet_at_intranet.gr>
Date: Mon, 22 Apr 2002 12:45:27 +0300
Message-ID: <aa0m6l$qhj$1_at_newsserv.intranet.gr>
import done in EL8ISO8859P7 character set and EL8ISO8859P7 NCHAR character set
. . importing table "PERF PTH NETWORKELEMENT"
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
About to enable constraints...
Import terminated successfully with warnings.
Date: Mon, 22 Apr 2002 12:45:27 +0300
Message-ID: <aa0m6l$qhj$1_at_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) violatedColumn 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 rowsimported
About to enable constraints...
Import terminated successfully with warnings.
George D. Benetos
Electrical & Computer Engineer N.T.U.A
--
George D. Benetos
Electrical & Computer Engineer N.T.U.A
--
Received on Mon Apr 22 2002 - 11:45:27 CEST