-
import error-ORA-00001: unique constraint (GLISADM.C_CUS_SK_01) violated
Hi All,
I am doing an import on HP-UX(11.2) database is 10.2.0.2 ,database is empty before import just precreated tablespaces,target characterset is AL32UTF8
and source is 9.2.0.5.0 on hpux characterset is UTF8,but i am getting the following error when there is no data in the tables(clean) prior to import.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by EXP_FULL, not by you
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export client uses UTF8 character set (possible charset conversion)
. importing SYSTEM's objects into SYSTEM
. importing GLISADM's objects into GLISADM
. . importing table "PLAN_TABLE" 0 rows imported
. . importing table "T_ANSWER" 0 rows imported
. . importing table "T_APL" 29900 rows imported
. . importing table "T_CALL" 81761 rows imported
. . importing table "T_CDPART" 1379 rows imported
. . importing table "T_CODEWORD" 2235054 rows imported
. . importing table "T_COUNTRY" 259 rows imported
. . importing table "T_CUSTOMER"
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (GLISADM.C_CUS_SK_01) violated
Column 1 139351
Column 2 ���ũҵ��ɽ��ʡ��
Column 3 ����
Column 4 570
Column 5 V
Column 6 CUSTST
Column 7 ɽ��ʡ���
Column 8
Column 9
Column 10 ���γ��·168����Ӵ���Ƽ�...
Column 11
Column 12
Column 13
Column 14
Column 15
Column 16
Column 17 12-JUL-2004:07:46:31
Column 18 SAP5000
Column 19 20-APR-2005:23:25:55
Here is my parfile for export
userid=exp_full/exp
buffer=500000000
consistent=y
compress=n
full=y
log=expGLIS1.log
statistics=none
~
--------------------------
import parfile
userid='/ as sysdba'
buffer=500000000
ignore=y
full=y
rows=y
indexes=n
constraints=n
grants=y
log=impGLIS11.log
statistics=none
commit=y
~
any suggestion would really helpful
Last edited by areeb; 06-22-2007 at 03:30 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|